Charts
Dashboards
Features
Formulas
VBA
OTHER NEWS

Charts

  • infographic template excel male female

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

  • excel Step chart made easy

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

  • infographic in excel, male, female icon in bar chart

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

More

Dashboards

  • #ExcelHash challenge Excel

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

  • Excel drop down list dependent

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

  • Excel lookup multiple pictures dynamic formula no vba

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,

More

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.  

More

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

  • Excel get multiple match results by looking up one value in Excel

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

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

More

VBA

  • Excel VBA page navigation with activex combobox

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

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

More

OTHER NEWS

  • #ExcelHash challenge Excel

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

  • Free Microsoft Excel tutorials Leila Gharani

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

More
All Tutorials
Share This