Items Tagged with 'excel'

Do you find yourself repeating the same actions or tasks in your spreadsheets? Do you have a time-consuming Excel-based process that you want to automate? Do you want to control how Excel acts when a file is opened, closed, saved or printed?

Formulas and functions are the building blocks that enable Excel to perform calculations. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.

Formulas and functions are the building blocks that enable Excel to perform calculations. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.

Formulas and functions are the building blocks that enable Excel to perform calculations. So think of any scenario that involves addition, subtraction, division or multiplication and that's where you'd use a formula.

With Power Query (known as Get and Transform in Excel 2016 and later) you can automate loading and updating external data into Excel and cleaning and transforming data. Of course, you can also do all of this with macros but who wants to learn VBA when you can do it using the Power Query Editor with a much shorter learning curve! (VBA still has its place!)

With Power Query (known as Get and Transform in Excel 2016 and later) you can automate loading and updating external data into Excel and cleaning and transforming data. Of course, you can also do all of this with macros but who wants to learn VBA when you can do it using the Power Query Editor with a much shorter learning curve! (VBA still has its place!)

A picture can be worth 10,000 numbers! Excel charts are a powerful communication tool, yet few users know more than the rudimentary basics. Take your Excel charting game to the next level with this fun, interactive training.

A picture can be worth 10,000 numbers! Excel charts are a powerful communication tool, yet few users know more than the rudimentary basics. Take your Excel charting game to the next level with this fun, interactive training.

With just a few clicks of the mouse (and no complicated formulas.) you can quickly and easily build reports, dashboards and charts that help you summarize, analyze, interpret and understand your data.

With just a few clicks of the mouse (and no complicated formulas.) you can quickly and easily build reports, dashboards and charts that help you summarize, analyze, interpret and understand your data.