Category Archives: Uncategorized

Mastering Excel Dynamic Arrays

?Dynamic arrays are here for all users of Office 365! What are dynamic arrays, you ask? They are a rebuild of the Excel calculation engine and the inclusion of several new formulas that are magic.

Seriously. Once you see and use this version of Excel, it will totally change how you build files. You will be able to do things that weren't possible unless you wanted to write
complex macros.

If you've landed on this page but don't have the lesson yet, head on over to Amazon and get it, then you can use the form below to sign up and get the follow along workbooks.

If you already have the lesson, then input your info below, check your email in a few
minutes and you'll get all the workbooks.

Note: If the form does not appear below, turn off your ad blocker or try another browser. I promise you it's there.

Drawing Tools

If you are in the habit of using PowerPoint or Visio to create hierarchies and other data driven images, you will love this lesson. I will cover how to use Excel’s powerful image manipulation tools to create and link the images to the data in your spreadsheets…when your data updates, so will your images!

If you do not see the sign up form below, turn off your ad blocker.
If you still don’t see the sign up form, please try another browser (I promise you it’s there!)

Mastering Excel Macros: Charts

This macro lesson focuses on how to write macros that update and alter charts in Excel. I don’t go into all the chart object model because it is very deep and complex…but I do give you enough information to be dangerous. 🙂

I’ll show you how to have charts update automagically, let users change the color of the chart and much more.

If you do not see the sign up form below, disable your ad blocker and reload the page. If you still don’t see it, try another browser. I promise you the sign up form is there.

Power Pack Bundle

Hi,

Mark Moore here. I wanted to talk about the newest addition to Excel. Power BI. Power BI makes Excel really shine and opens a whole new world of data analysis and reporting.

What is Power BI?

Power BI is a collection of several tools that let Excel collects data, manage the data model and build interactive dashboards. No extra software needed. It’s all inside Excel.

A major limitation of Excel is that it cannot handle several million rows of data. Are you running into this wall? Have you thought about using Access to store the data and then have Excel as the analysis engine? That’s clunky and unstable. Can you create interactive dashboards from millions of rows? Do you want to be the Excel guru of the office? I’ll help you do that.

The tools in Power BI are:

  • Mastering Excel: Power Query (extract data from databases, the web, Excel files, etc.)
  • Mastering Excel: Power Pivot (manage the data)
  • Mastering Excel: Power View (create dashboards)
  • Mastering Excel: Power Map (create geographical data-based maps)

The Power BI lessons are written in plain English, from a non-technical perspective. There are several step-by-step exercises with plenty of images to help you learn these powerful features.
Additionally, the book comes with several practice workbooks so you can work alongside the text to get hands-on experience.

You can find the eBook version in Amazon.com here:
Mastering Excel: Power Pack Bundle (ebook)

You can find the paperback version in Amazon.com here:
Mastering Excel: Power Pack Bundle (paperback)

Once you buy the book, remember to come back to this page! Input your info below to get your practice workbooks via email.

If you do not see the form below, please turn off your ad blocker and try again. If that still doesn’t work, try another browser.

Note that you must have Excel 2016 or Office 365 Pro Plus to use all the features. You might get away with Excel 2013 for some of them but not all features will be supported in that version of Excel.