Excel Intermediate and Advanced

By Stephanie Johnson

Learn features and tools in Excel to show manipulation data, automate redundant tasks and generate reports

Course Content

Introduction to tips and time savers in Excel2 lessons

Data files

Excel quick reference sheet

Entering and selecting data shortcuts and time savers5 lessons

Worksheet time savers - Excel auto fill for quick data entry5 min

Using ctrl or shift or ctrl A to select data3 min

Keyboard shortcuts - Copy contents from neighboring cells2 min

Keyboard shortcuts - Enter today's time and date with typing3 min

Enter data on a second line in the same cell - keyboard shortcut3 min

Microsoft suite shortcuts (universal shortcuts)4 lessons

Save and Save as3 min

Copy, cut, and paste3 min

Undo and Redo2 min

Spellcheck2 min

Navigating in Excel worksheets shortcuts6 lessons

Move up, down, left and right4 min

Go to the beginning and end of data2 min

Highlight a range of data shortcuts3 min

Highlight a row or column2 min

Bonus time saver - just move the data quickly2 min

Move rows or columns

Formulas and charts shortcuts7 lessons

Keyboard shortcut - sum all your data at once4 min

Keyboard shortcut - create an embedded chart2 min

Keyboard shortcut - create a chart on a separate worksheet1 min

Create a named range4 min

Time saver - Save time selecting cells by using named ranges in formulas3 min

Keyboard shortcut - using named ranges in formulas2 min

Adjust your formulas to keep a cell constant - Keyboard shortcut5 min

Formatting shortcuts3 lessons

Keyboard shortcuts - Bold, underline, italicize and more2 min

Currency, date, and percentage formats3 min

Format cells dialogue box shortcut3 min

Worksheet time savers3 lessons

Copy a worksheet - quickly make a replica of a worksheet1 min

Group worksheets - update multiple sheets at once3 min

Link cells - save time by linking cells5 min

Data manipulation time savers6 lessons

Text to columns - separate data5 min

Concatenate - join data4 min

Text functions - change the appearance of data3 min

Flash fill - separate or join data or change the appearance of data8 min

Keyboard shortcut - Copy filtered data only to a new location6 min

Intro to Power Query7 min

Reporting data time savers2 lessons

Keyboard shortcuts - create a table and highlight a table1 min

Excel Charting 3D Maps5 min

Automation1 lesson

Data Validation4 min

Data Analysis1 lesson

Goal Seek3 min

Student resources2 lessons

Student One Sheets

Custom Formatting One Sheet

Live Sessions for Excel1 lesson

Live Session May 2025 - Q&A and Time Savers

Your Instructor

👤

Stephanie Johnson

Senior Trainer