Excel Tutorials
A collection of written and video based Excel tutorials (Power BI coming soon)Excel: Prevent Excel Replacing Last Numbers with Zeros
Learn how to prevent Excel replacing the last 5 digits with zeros
Excel: Remove E+ From Numbers
How to change a number that displays E+ at the end so that it displays correctly
Copy Specific Table Columns
Create a dynamically-updating copy of specific columns from a Table
Excel: Case Conversion
Convert text from one case to another using formulas or Power Query
Excel: Insert Images into Cells (Non-365)
Embed an image inside a cell using a feature that is available to ALL Excel users
Excel: Track KPI’s with Traffic Lights
Show progress against actual using automatically-updating traffic lights
Excel: Create a Soccer Results Tracker
Build a simple Excel-based tracker to track match results and attendances
Excel: Link Shapes and Icons to Cell Values
How to add shapes and icons to a dashboard and link them to cells
Excel – Use IF with Wildcards
The IF function in Excel doesn’t support the use of wildcards. Here’s a workaround