Learn Excel

Excel's User Interface: Key Features Explained

The Microsoft Excel User Interface. We're going to start this particular video off by talking about the Quick Access Toolbar.

Garfield Stinvil

Cell Referencing

Improve your understanding of Excel's cell referencing system, including the use and implications of absolute and mixed cell references and how they impact...

Using Shortcut Keys in Excel

Enhance your proficiency with practical key combinations that facilitate various operations such as opening, closing, saving workbooks, copying, pasting, and...

Combining & Filtering Data from Multiple Worksheets

Learn how to combine data from two different sources with varying column arrangements and use formulas to filter and manipulate the data to achieve desired...

Working with Shapes in Excel

Dive into the intricacies of shape manipulation in digital drawing, from rotating and formatting shapes to working with Z-order and altering points, providing...

Advanced Filtering in Excel

Learn how to use Excel's Advanced Filter to handle more complex filtering operations such as filtering based on relationships between columns or unique records...

Introduction to Excel’s Page Layout Tab: Setting Margins, Page Orientation, Size, Print Area, & Breaks in Excel

Explore an in-depth guide on how to navigate the Page Layout tab in Microsoft Excel, covering commands such as Margins, Orientation, Size, Print Area, and...

Collection of Excel Tips and Tricks, Part 2

Discover various tips and tricks for Excel that can enhance your efficiency, including how to put totals in certain cells, best formulas for grand totals, how...

Making Magic Dynamic Arrays

Unveil the power of Excel's new feature, the dynamic array functions, which includes SORT, FILTER, UNIQUE, SORTBY, and RANDARRAY, to create dynamic...

How to Separate First & Last Names in Excel: Move Names to Individual Cells

Explore four methods to separate first and last names in Excel including using formulas, Text-to-Columns, Flash Fill, and new functions TEXTBEFORE and...

Navigate Data: Mastering Freeze Panes in Spreadsheets

Freeze panes. In this section, we're going to discuss how you can lock rows and columns to be able to efficiently view your data as you scroll through the...

Garfield Stinvil

Event Planning with Excel

In this article, we are going to look at how Event Planning can be done efficiently through the use of Microsoft Excel.

Rearranging Data with New Functions in Excel

In this article, we’ll explore these new functions: TOCOL, TOROW, WRAPCOLS, WRAPROWS, CHOOSECOLS, and CHOOSEROWS.

Designing Impressive Reports with Excel

In this article, we're going to look at how to build complex and thorough reports in Microsoft Excel

Protection in Excel

In this article, we are going to look at how to "Protect" your work in Microsoft Excel

Functions Built to Work with a Database

In this article, we are going to look at how to build functions to work with a database in Microsoft Excel.

Tracking Expenses in Excel

In this article, we are going to look at how to organize Expense Tracking in Microsoft Excel

Using Excel’s Analyze Data Tool

In this article, we are going to look at how to use the Analyze Data Tool in Microsoft Excel.

Formatting Cells in Excel

In this article, we are going to look at the many ways you can Format Cells in Microsoft Excel

Excel Data Analysis with Statistics

In this article, we are going to look at how Data Analysis with Statistics can be done efficiently through the use of Microsoft Excel.