Tag Archives: Advanced Excel Training

Excel 2013 In-Depth Preview

What’s new in Excel 2013! Microsoft has made it possible for anyone who’d like to check out Excel 2013 (included with the full Office 2013) through their Excel 2013 pre-release trial here. UPDATE 2/20: Now they have the Office 365 full … Continue reading

Posted in Function-Related Lessons, News / Updates | Tagged , , , , | 3 Comments

Video Lesson: Information Functions in Excel

In the following lesson I go through the Experience Level 1 Information Functions.  These functions are used to obtain information about formatting & referencing about specific cell or range references.  In this lesson I review the following functions: ISBLANK – … Continue reading

Posted in Function-Related Lessons | Tagged , , , , , , | 7 Comments

Video Lesson: Basic Excel Formatting Techniques

Today’s video lesson goes through some of the basic formatting techniques in Excel 2010: – How to Use the Auto-Fill Drag Handle / Fill Series Options – How to Use the Format Painter – Freeze / Unfreeze Panes – Sheet … Continue reading

Posted in Formatting | Tagged , , , , , , , | 96 Comments

Video Lesson: Advanced Pivot Tables – Round 1

Pivot Tables are extremely useful in Excel.  This Advanced Excel video lesson is a follow-up to the Introduction to Pivot Tables and covers the first round of advanced topics. The lesson goes over some additional Pivot Table options and features including: … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , , | 67 Comments

Alternative to Merged Cells (Quick Tip)

Typically, many users are drawn to the Merged Cells feature in Excel, despite it having some significant disadvantages (especially related to copy/paste of ranges). Frequently, Merged Cells are used in areas to group cells together visually, which can be done … Continue reading

Posted in Quick Tips | Tagged , , , , | 6 Comments

Guest Excel Lesson: Introduction to Tables

User VertexVortex has been helping users out on r/Excel for quite a while.  After reaching out to him on Reddit, he agreed to help out by creating a lesson of his own specifically for this site.  Here’s his guest lesson on … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , , , | 8 Comments

Video Lesson: Math and Statistical Functions

This Excel video lesson is about the Experience Level 1 Math and Statistical Functions in Excel.  Here is the level 1 function list extract from the Master Workbook that goes along with the video lesson. The formulas discussed in the video are as … Continue reading

Posted in Function-Related Lessons | Tagged , , , , , , , , , , , | 34 Comments

VBA Walkthrough #2: Message Encoder & Decoder

This VBA macro is hopefully a bit more interesting than the last, and shows how I created a message encryptor/decryptor in Excel using VBA/macros. The lesson covers these specific areas of VBA usage: – For…Next loop (including nested loops) – … Continue reading

Posted in VBA / Macros | Tagged , , , , , , , | 7 Comments

VBA Walkthrough #1: Purchase Order Generator

VBA Macro Walkthrough One of the best ways of learning VBA is to take a look at completely functioning macros & code to see how others approach a problem.  In this video lesson, I walk you through a Purchase Order … Continue reading

Posted in VBA / Macros | Tagged , , , , , , | 19 Comments

Video Lesson: Advanced Filtering in Excel

Using auto-filters in Excel provides a useful way to drill down and extract data from spreadsheets. This video lesson explains multiple ways you can use filters in Excel. Make sure to download the most recent Master Workbook so that you … Continue reading

Posted in Data Input & Manipulation | Tagged , , , , , , | 16 Comments