We Have Taught Professionals from 300+ Companies Including
LATEST TUTORIALS
Learn a new Excel tip or trick every week. You’ll also find some PowerPoint tips and Accounting articles here.
How to Use Checkboxes in Excel
Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas and conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.
Excel Job Interview Questions by Position
In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.
Create a Pivot Table from Multiple Sheets
Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.
Excel Generate Random Numbers
This tutorial shows you different methods to generate random numbers in Excel (including no repeats). You might need random numbers if you're preparing test data. Or if you need to share your files with consultants and have to replace official values with random ones.
Excel Dashboards with Radio Buttons
Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick: How to control the results based on the radio button selection.
LOOKING FOR SOMETHING SPECIFIC?
HAPPY STUDENTS FROM 135 COUNTRIES
★★★★★ “The instructor’s explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith
★★★★★ “Lots of tips and techniques. Already using them in my own work!” Alison
★★★★★ “It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great “hacks” for excel.” Teo
Get my Excel Tutorials & updates from me, directly to your Inbox:
You can expect to hear from me on a monthly basis. Unsubscribe anytime.