Microsoft Excel — HOW TO Disable “Protected View” in MS Excel

Overview

Microsoft Excel: Macro Code to Perform a “Contains” Text Filter

A handy piece of VBA code to have in your toolkit!

Performing an AutoFilter in Excel and I needed to perform a “contains” text filter. So, I have a description field and am going to write a macro…

Microsoft Excel: The ONE Automation Macro You Need to Use

“If you sit in front of a computer screen…

STOP IT! 3 Things I STOPPED Doing in Microsoft Excel to Boost Productivity

Microsoft Excel — Introduction to Power Query Excel Add-In

Part of the Microsoft Power BI Suite #Data #Analytics

Introduction

Microsoft Excel — HOW TO Enable “all Macros” in MS Excel

Overview

By default, Excel disables all macros and notifies you (screenshot below). You then have to enable the macros for the file. This is meant to prevent you from opening an potentially infected…

Microsoft Excel: Data Analysis; Getting Started with Pivot Tables

Microsoft Excel — ASAP Utilities Add-In — My Top Uses (#2)

#2 — Create a Hyperlinked Workbook Index Sheet

Microsoft Excel — Easily Create an Interactive Executive Resource Dashboard

Microsoft Excel user? Consider these 5 Productivity Hacks!