December 5, 2024 - by Bill Jelen
Most people with Microsoft 365 will have a new Visio Data Visualizer tool in Excel. It is found on the Insert tab, in the Add-Ins group.
The easiest way to get started is to go to File, New and search the templates for "flowcharts". There should be five results, but these three are for the Visio tool.
Excel 2024: Perform Sentiment Analysis in Excel »
December 2, 2024 - by Bill Jelen
It is easy to quantify survey data when it is multiple choice: You use a pivot table to figure out the percentage for each answer. But what about free-form text answers? These are hard to process if you have hundreds or thousands of them.
Excel 2024: The Forecast Sheet Can Handle Some Seasonality »
November 28, 2024 - by Bill Jelen
Before Excel 2016, Excel offered a few forecasting tools that did not fit in every situation. If your sales data included some seasonality, the old forecasting tools would do a bad job.
Excel 2024: Build a Pivot Table on a Map Using 3D Maps »
November 25, 2024 - by Bill Jelen
3D Maps (Power Map) is available in the Office 365 versions of Excel 2013 and all versions of Excel 2016. Using 3D Maps, you can build a pivot table on a map. You can fly through your data and animate the data over time.
Programming PowerPoint with VBA
February 2022
This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.
Your Excel Survival Kit - Second Edition
March 2021
This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
April 2022
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.
Master Your Data with Power Query in Excel and Power BI
August 2021
Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.