Charts
Creative Infographics in Excel
Creative infographics in Excel (Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this: Set up the data table Insert a clustered column chart Insert icons into the chart Format the chart
How to create a Step Chart in Excel
This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an irregular basis. It can be used to visualize inventory or
Infographics in Excel: NOT your Usual Bar Chart
In this tutorial you learn how to create a bar chart that includes the male/female icon in a dynamic way. Let's assume you'd like to show the percentage of male/female visitors to your store - and you'd like to show it, like the image on the left hand side. Can you set this
Dashboards
First Excel Hash Challenge between 6 MVPs
What is #ExcelHash? It's the Iron Chef Tournament between 6 Excel MVP YouTubers. If you're serious about learning Excel, you've probably come across their videos: Mike Girvin from Excel is Fun; Bill Jelen from MrExcel; Mynda Treacy from MyOnlineTrainingHub; Jon Acampora from Excel Campus; Oz from Excel on Fire and myself: Leila Gharani. On September
Expandable Conditional Drop Down Lists in Excel
Smart Dependent Drop-Down Lists in Excel: Expandable & Excluding Blank Cells In situations where the contents of a drop-down list are frequently changing, it's helpful to have a dynamic drop-down list that can automatically expand, as well as exclude any blank cells in the cell references. This example uses the sample
Lookup on Pictures
Dynamic Picture Lookup in Excel Just 5 easy steps - No VBA How can you lookup different pictures based on the value of a cell? Just to give you a heads up. This is a VBA-free tutorial! We saw the dynamic picture lookup in action towards the end of this video,
Features
FIFA World Cup 2018 Excel Template for Predictions & Play
FIFA world Cup 2018 is approaching fast and I thought to share an Excel template that adds to the fun and excitement of the World Cup month. Use it to keep track of the dates & times of the games, input your predictions, make fun bets with family members or organize an office
Excel Custom Data Validation
Check for text, numbers & length Excel Custom Data Validation Custom data validation is especially useful when the normal data validation criteria options are insufficient, this way, formulas can be used to define the restrictions. TIP: Since the formula text box in the Data Validation window will not provide formula tips as
Data Validation in Excel
Should you include these in your files? Data Validation in Excel Excel’s Data Validation feature ensures that the data collected is clean and to minimize the errors and hence the time it takes to correct them. This is especially helpful when multiple people input data into the spreadsheet.
Formulas
VLOOKUP Explained with 2 Practical Examples
VLOOKUP & HLOOKUP for Dynamic Lookups These two functions are easy to write, understand, and they’re a major time-saver for simpler lookups. The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns. HLOOKUP works exactly in the same way except that
Return Multiple Match Values in Excel
Lookup 1 Value, Return Many Matches The VLOOKUP and INDEX & MATCH formulas are great for looking up a value in a large data table and returning a result from the adjacent columns. But how can you return multiple results? What if your lookup value isn't unique? What if it's repeated in your
Excel SUM Between Dates
How can you sum values between two dates in Excel? What if you wanted the sum for a specific month? And what if you decided to add in multiple criteria to your existing sum? For example get the sum by month AND division AND product? That's where Excel's SUMIFS formula comes in really
VBA
Excel ActiveX Combo Box with VBA
How can you make navigation easier for your larger workbooks? You could create an ActiveX combo-box that automatically adds the sheet names to the drop-down. Once the user selects a sheet, they jump to the respective sheet. If the user deletes a sheet, renames a sheet or adds new worksheets, the combo-box names
Excel VBA IF THEN Statement (and a useful tip)
Excel VBA IF THEN Statement is one of the most useful statements in VBA. In this tutorial, you'll quickly learn how to work with the IF, THEN, ELSE, ELSEIF as well as the AND statements. This way you can write Excel macros that are dependent on multiple conditions. We also take a look
Excel VBA FIND Function
Excel VBA FIND Function (& how to handle if value NOT found) Doing a CTRL + F on Excel to find a partial or exact match in the cell values, formulas or comments gives you a result almost instantly. In fact, it might even be faster to use this instead looping
OTHER NEWS
First Excel Hash Challenge between 6 MVPs
What is #ExcelHash? It's the Iron Chef Tournament between 6 Excel MVP YouTubers. If you're serious about learning Excel, you've probably come across their videos: Mike Girvin from Excel is Fun; Bill Jelen from MrExcel; Mynda Treacy from MyOnlineTrainingHub; Jon Acampora from Excel Campus; Oz from Excel on Fire and myself: Leila Gharani. On September
More than 100 Free Excel Tutorials in 1 Place
Over 100 Excel Tutorials in ONE Place The links in this file are updated on a monthly basis. Check back to get the latest file. On my YouTube channel, I often get questions like: "Do you have a video on *specific* topic?" or "How can I do *this* Excel task?" Actually,
Excel Power Query, Power Pivot & Power BI Resources
Excel Power Query, Power Pivot & Power BI Resources Some useful resources that will make you a data analysis pro A popular question from readers is: "Do you have any Power Query or Power Pivot courses?" I don't. At least not yet. But let me share with you my list of