Think-Cell in PowerPoint (free trail)

With the think-cell add-in for PowerPoint, you can create beautiful charts with just a few clicks. Some of my favorites are Gantt charts, Mekko charts and adding automatics totals to stacked columns or bars.

4 Excel Settings

Excel comes with default settings and options. You can easily change these by going to File / Options. Why should you? To support your workflow and be more productive. This post has my list of options you need to review.

Power BI in PowerPoint

Power BI Reports in PowerPoint Building a super-cool Power BI dashboard with full interactivity (slicers, bookmarks, drill-through, etc.) can be quite satisfying. But what do you do if you need to present this interactive dashboard in a meeting where PowerPoint is your

Bulk Import PDF Files to Excel

Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy-paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the PDF data is immediately imported to Excel.

Excel Organizational Data Types

Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial show you what organizational data types are and you can set them up from scratch.

Excel VSTACK Function

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

Excel Pivot Table Date Grouping

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

Excel LOOKUP Function

The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

Learn Financial Analysis

The reason most people fail at understanding financial analysis is that they fail to understand the fundamental concepts. Concepts such as debits and credits, journal entries, trial balance and how these connect to the income statement, balance sheet and cash flow.

Lock and Unlock Cells in Excel

Lock & Unlock Cells in Microsoft Excel If you create spreadsheets for other people to use, you may have some experience with those people deleting or changing your formulas or other aspects of your workbook. Not only is it frustrating to have