Learn Excel

Navigate Data: Mastering Freeze Panes in Spreadsheets

Conditional SUMPRODUCT for Data Analysis in Excel

Joining Text in Excel: Using Concatenate and Ampersand

Match Function: Finding Positions in Rows and Columns

Paste Special: Excel Skills with Key Techniques

Streamlining Daily Reports with Macros for Accuracy

Excel's True-False Comparisons for Data Analysis

Multi-Input Functions: From Text Extraction to Rounding

Data Organization: Sorting, Filtering, and Subtotals in Excel

Windows Management: Keyboard Shortcuts for Excel

Remove Duplicates in Excel Using Data Tools

Creating Line Charts in Excel

Alt Hotkeys in Excel: Keyboard Shortcuts

Basic Excel Calculations and Order of Operations

Mixed Cell References in Excel Formulas

Absolute Cell References in Excel Calculations

AND & OR Functions: Logic in Real-Life Scenarios

Creating Dynamic Visuals with Pivot Charts in Excel

Excel's User Interface: Key Features Explained

Inserting, Deleting, Hiding, and Grouping Rows and Columns

Date Analysis with Pivot Tables: Grouping and Timelines

HLOOKUP: Mastering Horizontal Data Searches

Excel Tables: Tips for Level One Students

Managing Excel Worksheets with Ease

Excel's Autosum: Simplifying Calculations

Number Formatting in Excel

Explore the different ways to effectively format numbers in Excel, including shortcuts, custom categories, and understanding the use of individual characters.

Data Validation in Excel

Explore how to use data validation to set restrictions on cell entries, alert users, and prevent incorrect values from entering your data cells, with examples...

Conditional Formatting in Excel

Explore the wide-ranging capabilities of Excel's conditional formatting, including the ability to format cells based on specific conditions, highlight cells...

Creating Grand Totals in Excel

Explore various formulas to calculate the grand total in an Excel worksheet, discussing alternative methods, the potential for errors, and the optimal solution.

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...

Excel’s Latest Innovations

If you subscribe to Office 365, every time you fire up one of the applications, you’re getting the latest version of the software. While we used to have to buy...

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...

Using the JUSTIFY Command: Reflow Text in Microsoft Excel

Learn how to use the built-in Justify command in Excel to reflow and arrange your text, with examples and step by step instructions.

Cell Styles in Excel: How to Style Cells for Quick & Easy Modification

Discover the time-saving capabilities of cell styles in spreadsheet software, allowing easy formatting adjustments across thousands of cells with just a few...

How to Add Headers & Footers in Excel: More Fun with Excel's Page Layout Tab

Explore the detailed guide to understanding the Page Layout tab and other features in Excel, along with a step-by-step explanation on customizing headers,...

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.

Working with Rows & Columns in Excel: How to Hide Them, Show Them, & Change the Height or Width

Discover the various methods to hide, show, and change the dimensions of rows and columns in Excel. This inclusive guide primarily focuses on operations...

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...

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...

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...

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...

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...

Demystifying VLOOKUP, XLOOKUP

Learn about the unique properties and uses of an Excel table, which offers additional functionalities that can significantly enhance data management and...

Using Excel's Analyze Data Tool

Discover how to harness the power of Excel's Analyze Data tool to simplify data analysis, offering intuitive, automatic analysis of key data segments,...

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.

How to Set a Picture as a Background in Excel: Using the Page Layout Tab to Add Graphics to Your Sheets

Continue your understanding of Excel's Page Layout tab with insights into the "Background" and "Print Titles" commands, where you can customize your sheet's...

Rearranging Data with New Functions in Excel

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

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...

Collection of Excel Tips and Tricks, Part 1

Explore this comprehensive guide for insightful Excel tips and tricks to enhance your productivity, ranging from simple shortcut keys to advanced VBA code and...

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...

Filtering Data in Excel

Discover the various ways to filter data in Excel and utilize this feature to efficiently organize and analyze your datasets.

Designing Impressive Reports with Excel

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

Tracking Expenses in Excel

In this article, we are going to look at how to organize Expense Tracking 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

Using Excel's Power Query Editor

In this article, we are going to look at how to use the Power Query Editor 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.

Protection in Excel

In this article, we are going to look at how to "Protect" your work 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.

Using Excel Tables

Learn how to manage and utilize Excel Tables more effectively with this comprehensive guide, covering everything from creating tables and selecting rows or...

Get Started with UserForms: Create Simple Forms with VBA in Excel

Learn step-by-step how to create a simple UserForm in Excel using VBA coding which allows users to input information into a form that can be stored or used...

Data Validation

Learn how to ensure data consistency and accuracy within your worksheets using Data Validation, a powerful tool that establishes standards for data entry...

Using SUM for a whole Column

Learn how to use SUM for a whole Column.

Multiple Pivot Tables Excel

Learn advanced features of Pivot Tables like adding percent totals, creating slicers, and creating multiple Pivot Tables off the same dataset.

Excel Go to Special

Learn to use Go to Special to perform several time-saving tasks in your Excel spreadsheet.

Excel AND OR Logical Functions

In this section, we'll take a look at how you can use the AND OR functions to test if multiple criteria are all true, or at least one of them is true.

Excel COUNTIFs and SUMIFs

Learn to use SUMIFS and COUNTIFS to quickly get counts and sums based on a single column criteria or multiple column criteria.

Combo Charts

Combo charts combine two or more charts into a single chart with the option of adding a secondary axis.

Excel Advanced Cell Locking

Learn to create powerful formulas by locking either a column, a row, or both in Excel.

Excel Hotkeys

Learn to use a keyboard shortcut to access any commands on the ribbon on a PC.

Excel Advanced Conditional Formatting

Learn to use advanced conditional formatting to format cells based on values in another location.

Excel IF Statement with AND OR

Learn to use an IF statement with either an AND function or an OR function to expand the functionality of the IF function by adding an AND or an OR criteria...

Excel Goal Seek

Learn to use Goal Seek to calculate equations in Excel.

Pivot Table Sales Report Variances 

In this Excel tutorial, we're going to create a Pivot Table. In order to do this, we're going to have to use one of the Value Field Settings calculations that...

Excel Pivot Tables, Calculated Fields and Items

In this Excel video tutorial, we'll cover Pivot Tables, Calculated Fields and Calculated Items.

Pivot Charts in Excel

Learn how to work with Pivot charts in Microsft Excel. Pivot charts are dynamic graphical representations of Pivot Table data that work in tandem with pivot...

Excel MATCH Function

Learn to use the MATCH function to find the relative position in a column or a row of a lookup value in Microsoft Excel.

Excel VLOOKUP and MATCH Function

Learn to create a more accurate VLOOKUP by enhancing the determination of the column index number by using the MATCH function in Microsoft Excel.

Excel Index Match

Learn how INDEX and MATCH efficiently return a value in a row or column that matches a value in another row or column in Microsoft Excel.

Excel Macros

Learn to use Macros to help you to automate work in Excel.

Excel Macros Report

In this video, we'll create a macro that's going to format a report that we are going to imagine we need to create every single day.

Excel Consolidation

Learn to use the Consolidate function to consolidate information across multiple sheets in Excel.

Excel Date Functions

In this section, we'll take a look at five Excel date functions you can use to calculate dates in the future or the total number of days between any two dates,...

Excel Nested IF Statements

In this section, we're going to cover how you can nest multiple IF statements together to account for more than just two possibilities.

Excel Data Tables

Learn to use Excel Data Tables to show the range of effects of one or two different variables on a formula.

Excel Conditional SUMPRODUCT

Learn to use conditional SUMPRODUCT to extract the subset of the information that you want and exclude everything else.

Excel Index Double Match

Learn to use Index Double Match for its flexibility when we're looking up information in a table.

Excel Windows

In this section, we're going to talk about how to work with windows inside of the Windows operating system. This particular topic is not applicable to Macs.

Working Across Sheets Excel

Learn to work across multiple sheets if you need to apply formatting or summarize calculations across multiple sheets.

Adding, Naming, Moving, & Copying Worksheets

Learn how to Add, Rename, Move, and Delete Excel Worksheets.

Creating a new Workbook

Learn how to create a new Workbook

Printing Worksheets, Workbooks, and Ranges

Learn how to print Worksheets, Workbooks, and Ranges

Customize the Excel Quick Access Toolbar

Learn how to customize the Excel Quick Access Toolbar.

Editing Cells and Ranges

Learn how to edit cells and ranges in Excel.

Using SUM and AutoSUM

Learn how to use SUM and AutoSUM in Excel.

Performing a Simple Calculation in Excel

Learn how to perform a Simple Calculation.

Adjusting Column Widths and Row Heights

Learn how to adjust Column Widths and Row Heights.

Using Undo, Redo, and Repeat

Learn how to use Undo, Redo, and Repeat in Excel.

Selecting Cells, Ranges, Rows, and Columns

Learn how to select cells, ranges, rows, and columns.

Tour of the Excel Workspace

Learn to navigate the Excel Workspace.

Project Management with Excel

Download the project file Being a project manager is a lot like being a juggler. You’ve got to keep a lot of things—people, resources, schedules, tasks,...

Learn how to save Workbooks

Learn how to save Workbooks.

Customize Excel Ribbons

Learn how to customize Excel ribbons.

Entering Worksheet Content

Learn how to enter content in an Excel Worksheet.

Working with Page Breaks & Print Areas in Excel

Learn how to work with Page Breaks and Print Areas in Excel.

Applying Basic Font & Alignment Formatting in Excel

Learn how to apply Basic Font and Alignment Formatting in Excel.

Applying Basic Number Formats

Learn how to apply basic number formats.

Applying Borders and Shading

Learn how to apply Borders and Shading.

Merging and Centering Tiles

Learn how to Merge and Center Tiles.

Inserting Current Dates and Times with Functions

Learn how to insert Current Dates and Times with Functions.

Working with Date and Time Formats

Learn how to work with Date and Time Formats.

Controlling Content Placement in Worksheet Cells

Learn how to Control Content Placement in Worksheet Cells.

Creating and Modifying a Custom List

Learn how to create and modify a custom list.

Inserting and Deleting Cells, Columns, and Rows

Learn how to Insert and Delete Cells, Columns, and Rows.

Using AutoFill to create Lists

Learn how to use AutoFill to create Lists.

Working with Flash Fill

Learn how to work with Flash Fill.

Using Cut, Copy, Paste, and Paste Special

Learn how to use Cut, Copy, Paste, and Paste Special.

Applying Conditional Formatting

Learn how to apply Conditional Formatting.

Mastering the Format Painter

Learn how to master the Format Painter.

Understanding Formulas vs. Functions

Understand Formulas vs. Functions in Excel.

Using COUNT Functions

Learn how to use COUNT Functions.

Nesting Functions

Learn how to Nest Functions.

Using SUM and AVERAGE Functions

Learn how to use SUM and AVERAGE Functions.

Working with IF Function Variations

Learn how to work with IF Variations.

Working with Order of Operations

Learn how to work with Order of Operations in Excel.

Absolute References vs. Relative Addressing

Understand Absolute vs. Relative Addressing in Excel.

Using LEFT and RIGHT Functions

Learn how to use LEFT and RIGHT Functions in Excel.

Array Formulas

Learn how to work with Array Formulas.

Create Mixed References

Learn how to Create Mixed References.

Using Concatenate

Learn how to use CONCATENATE.

Naming Cells and Ranges

Learn how to name Cells and Ranges

Using Functions to Control Case

Learn how to use Functions to control Case

Responding to Excel Warnings

Learn how to respond to Excel warnings.

Creating a Subtotal Report

Learn how to create a subtotal report in Excel, a tool that allows you to sort and group your data, apply functions like summing and averaging, and then...

Filter Lists in Excel

Learn how to Filter Lists in Excel

Finding Data with XLOOKUP

Discover the powerful, versatile XLOOKUP function in Excel, which has replaced and improved upon the older VLOOKUP and HLOOKUP functions, enabling both...

Sort Lists in Excel

Learn how to Sort Lists in Excel

Advanced Filtering

Learn how to use Advanced Filters in Excel.

Storing Lists in Excel

Learn how to Store Lists in Excel.

Create a Quick PivotTable

Learn how to create a Quick Pivot Table in Excel.

Edit PivotTable

Learn how to edit a Pivot Table

Format PivotTable

Learn how to format a Pivot Table.

Understand PivotTable Structure

Understand Pivot Table Structure.

Work with Slicers in Excel

Learn how to work with Slicers in Excel.

IF Statements

In this section, we’ll cover IF statements. IF statements allow you to check to see if something is true or false and then take different actions depending on...

Create Charts in Excel

Learn how to create a Chart in Excel.

Create SmartArt Diagrams in Excel

Learn how to create SmartArt Diagrams in Excel.

Editing and Formatting Charts

Learn how to Edit and Format Charts.

Using Shapes, Lines, Icons, and Text Boxes in Excel

Discover how to enhance your Excel worksheets by adding and formatting shapes, lines, icons, and text boxes to create visually striking data presentations.

Working with Sparklines

Learn how to work with Sparklines in Excel.