April 19, 2026
Using Functions to Control Case
Learn how to use Functions to control Case
Learn Excel
Free Excel Resources & Tutorials
181 articles in Excel
April 19, 2026
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...
April 19, 2026
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.
Bob Umlas
April 19, 2026
Understand PivotTable Structure
Understand Pivot Table Structure.
April 19, 2026
Using LEFT and RIGHT Functions
Learn how to use LEFT and RIGHT Functions in Excel.
April 19, 2026
Working with Order of Operations
Learn how to work with Order of Operations in Excel.
April 19, 2026
Nesting Functions
Learn how to Nest Functions.
April 19, 2026
Using Concatenate
Learn how to use CONCATENATE.
April 19, 2026
Inserting and Deleting Cells, Columns, and Rows
Learn how to Insert and Delete Cells, Columns, and Rows.
April 19, 2026
Using AutoFill to create Lists
Learn how to use AutoFill to create Lists.
April 19, 2026
Customize the Excel Quick Access Toolbar
Learn how to customize the Excel Quick Access Toolbar.
April 19, 2026
Excel Macros
Learn to use Macros to help you to automate work in Excel.
April 19, 2026
Naming Cells and Ranges
Learn how to name Cells and Ranges
April 19, 2026
Merging and Centering Tiles
Learn how to Merge and Center Tiles.
April 19, 2026
Creating a new Workbook
Learn how to create a new Workbook
April 19, 2026
Performing a Simple Calculation in Excel
Learn how to perform a Simple Calculation.
April 19, 2026
Using SUM and AVERAGE Functions
Learn how to use SUM and AVERAGE Functions.
April 19, 2026
Alt Hotkeys in Excel: Keyboard Shortcuts
Hotkeys. You're able to use Excel on a Mac and on a PC.
Garfield Stinvil
April 19, 2026
Edit PivotTable
Learn how to edit a Pivot Table
April 19, 2026
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.
Bob Umlas