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!)
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.
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.
This lesson is a bit longer than the rest of the series because this is a hefty topic. Here I cover:
These three topics are essential for heavy duty data analysis. These topics make Excel shine…like seriously. I’ll show you how to structure worksheets and have Excel perform thousands of calculations to arrive at the best answer. With these in your Excel tool belt, you’ll laugh derisively at your manager’s questions. (please…do the laughing internally. Some managers might not take too kindly to derisive laughter.) 🙂
Sign up below to get your follow along workbooks.
If you do not see the sign up form below, please disable your ad blocker. If it still does not appear, try another browser.
You will need to confirm your subscription in the first email, then the second email will have the files attached.