Advanced Excel Techniques - Online Course


January 2022

Advanced Excel Techniques - Online Course

In this guide, I've compiled advanced skills and formulas in Excel that you should know to analyze and understand your data easier and faster.

Bill Jelen, MrExcel

category: Spreadsheets
covers: Excel

Product Details
  • 3 hours
  • Publisher: Holy Macro! Books

Understanding data is crucial, and the easiest place to start is with Microsoft Excel. Whether you're using Excel at work to compile data or at home to keep track of your budget, learning how to analyze data and use Excel formulas will make your job, and life, much easier and help you get answers to complex questions. In this guide, I've compiled advanced skills and formulas in Excel that you should know to analyze and understand your data easier and faster.

If there's something specific you'd like to follow or learn, just ask the search bar—it will take you right to it. If you get stuck or need some advice directly from me you can ask me anything with a direct message.

Watch Video

  • Fast Formula Copy
  • Breaking Data Apart
  • Convert Text Numbers to Numbers Quickly
  • Filter by Selection
  • Fill Handle Tricks
  • Fast Worksheet Copy
  • Default settings for all future workbooks
  • Recover unsaved workbooks
  • Tracking changes in your workbook using Show Changes
  • Back into an answer using Goal Seek
  • Interpolate to fill in between numbers
  • The forecast sheet and seasonality
  • Using Flash Fill
  • Number Formatting Techniques

Where to Buy

MrExcel on Retrieve

Online course from MrExcel.

MrExcel on Retrieve

Get all four Excel guides for a reduced price when you bundle them together.


Related Products


Saving Time with Excel - Online Course

January 2022

Be more efficient in Excel with these time-saving techniques in Excel.


Ace Your Job Interview Where You Have to Know Excel - Online Course

January 2022

You have a job interview this afternoon where you have to know Excel? This short video course will teach you enough Excel skills to get through the interview.


Analyzing Data With Pivot Tables in Excel - Online Course

January 2022

Bill Jelen has rolled all of his favorite Excel Pivot Table tips and techniques into a new guide on the Retrieve platform.