Excel beginners intermediate and advanced

Excel Beginners part 1 out of 3

Section 1 - Excel Beginner

• Beginner 1 - Introduction

Section 2 - Excel Fundamentals

• Beginner 2 - Launching Excel
• Beginner 3 - Start Up Screen
• Beginner 4 - The Excel Interface
• Beginner 5 - The Quick Access Toolbar
• Beginner 6 - The Ribbon
• Beginner 7 - Creating New Excel Workbooks
• Beginner 8 - Saving Excel Files
• Beginner 9 - Opening Excel Files
• Beginner 10 - Beginner Shortcut Keys

Section 3 - Entering and Editing Text

• Beginner 11 - Entering Text
• Beginner 12 - Working with Numbers
• Beginner 13 - An Introduction to Dates
• Beginner 14 - Find and Replace
• Beginner 15 - Sorting Data
• Beginner 16 - Working with Cell References
• Beginner 17 - Relative Versus Absolute Cell Reference in Formulas
• Beginner 18 - Understanding the Order of Operation

Section 4 - Basic Excel Functions

• Beginner 19 - The structure of an Excel Function
• Beginner 20 - Working with the Sum Function
• Beginner 21 - Working with Min and Max
• Beginner 22 - Working with Averages
• Beginner 23 - Working with Count and CountA

Section 5 - Modifying an Excel Worksheet

• Beginner 24 - Moving and Copying Data
• Beginner 25 - Inserting and Deleting Rows and Columns
• Beginner 26 - Changing the Width and Height of Cells
• Beginner 27 - Hiding and Unhiding Rows, Columns and Sheets
• Beginner 28 - Renaming Worksheets
• Beginner 29 - Deleting Worksheets
• Beginner 30 - Moving and Copying Worksheets

Section 6 - Formatting Data

• Beginner 31 - Adding Borders to Cells
• Beginner 32 - Formatting Percentages
• Beginner 33 - Merging and Centering Cells
• Beginner 34 - A Quick look at Styles
• Beginner 35 - Basic Conditional Formatting

Section 7 - Images, Shapes and Smart Art

• Beginner 36 - Inserting Images and Shapes
• Beginner 37 - Working with SmartArt

Section 8 - Printing in Excel

• Beginner 38 - Print Preview
• Beginner 39 - Margins, Scaling and Orientation
• Beginner 40 - Printing

Section 9 - Templates

• Beginner 41 - Intro to Excel Templates
• Beginner 42 - Opening an Existing Template
• Beginner 43 - Creating a Custom Template

Section 10 - Excel Beginner - Conclusion

• Beginner 44 - Conclusion

Excel Intermediate part 2 out of 3

Section 1 - Excel - Intermediate

• Intermediate 1 - Excel Intermediate Introduction
• Intermediate 2 - Intermediate Shortcut Keys

Section 2 - Lists

• Intermediate 3 - What are Lists
• Intermediate 4 - Sorting a List
• Intermediate 5 - Sorting - Multiple Criteria
• Intermediate 6 - Custom Sort
• Intermediate 7 - What are Filters
• Intermediate 8 - Format a List as a Table

Section 3 - DataBase Functions

• Intermediate 9 - Introduction to DataBase Functions
• Intermediate 10 - DSum Function
• Intermediate 11 - DSum Function - Single Criteria
• Intermediate 12 - DSum Function - Multiple Criteria
• Intermediate 13 - DAverage
• Intermediate 14 - DCount Function
• 15 - Subtotal

Section 4 - Data Validation

• Intermediate 16 - Data Validation - List
• Intermediate 17 - Data Validation - Decimal
• Intermediate 18 - Input and Error Messages

Section 5 - Importing and Exporting

• Intermediate 19 - Importing Data from Text Files
• Intermediate 20 - Importing Data from MS Access
• Intermediate 21 - Exporting Data to a Text File

Section 6 - Creating Basic Charts

• Intermediate 22 - Creating Basic Charts
• Intermediate 23 - The Chart Ribbon
• Intermediate 24 - Adding and Modifying Data on a Chart
• Intermediate 25 - Formatting ChartsSection

7 - Pivot Tables

• Intermediate 26 - Understanding Pivot Tables
• Intermediate 27 - Creating Pivot Tables
• Intermediate 28 - Pivot Table Calculations
• Intermediate 29 - Grouping Pivot Table Data
• Intermediate 30 - Formatting Pivot Table Data
• Intermediate 31 - Drilling Down into Pivot Table Data
• Intermediate 32 - Creating Pivot Charts
• Intermediate 33 - Filtering Pivot Table Data
• Intermediate 34 - Filtering using the Slicer

Section 8 - Working with Large Data

• Intermediate 35 - Grouping Data
• Intermediate 36 - Consolidating Data

Section 9 - LookUp Functions

• Intermediate 37 - VLookUp
• Intermediate 38 - HLookUp
• Intermediate 39 - Index and Match

Section 10 - Advanced Functions

• Intermediate 40 - FV Function
• Intermediate 41 - PMT Function
• Intermediate 42 - Hyperlinks
• Intermediate 43 - Text to Columns

Section 11 - Excel Intermediate - Conclusion

• Intermediate 44 - Excel Intermediate - Conclusion

Section 3: Advanced

Awesome, let’s wrap up with some industry nuances! Whether you have little or no experience with Excel. Start with Excel Beginner and start learning how to: Learn To Use Excel Like The Professionals

• VLookUp and Advanced VLookUps.
• Index and Match and Advanced Index and Match
• Track workbooks between teams
• Automate, streamline, and completely revolutionize your workflow with Excel

Section 1 - Excel - Advanced

• Advanced 1 - Excel Advanced Introduction
• Advanced 2 - Advanced Shortcut Keys

Section 2 - Working with Multiple Workbooks

• Advanced 3 - Tracing Precedents
• Advanced 4 - Tracing Dependants
• Advanced 5 - Watch Window
• Advanced 6 - Show Formulas

Section 3 - Protecting Worksheets and Workbooks

• Advanced 7 - Protecting Cells in a Worksheet
• Advanced 8 - Protecting the Workbook Structure
• Advanced 9 - Encryption with Passwords

Section 4 - Conditional Formulas

• Advanced 10 - Name Ranges
• Advanced 11 - Simple IF Function
• Advanced 12 - IF, AND
• Advanced 13 - IF, OR
• Advanced 14 - Nested Formulas
• Advanced 15 - CountIF and CountIFs
• Advanced 16 - SumIF and SumIFs

Section 5 - Advanced Functions

• Advanced 17 - Advanced VLookUp
• Advanced 18 - IF and IS Error - Part 1
• Advanced 19 - IF and IS Error - Part 2
• Advanced 20 - Advanced Index Match
• Advanced 21 - Dates - Part 1
• Advanced 22 - Dates - Part 2
• Advanced 23 - Replace and Substitute - Part 1
• Advanced 24 - Replace and Substitute - Part 2

Section 6 - Text Based Functions

• Advanced 25 - Left, Right and Mid Function
• Advanced 26 - Search Function
• Advanced 27 - Concatenate and Search
• Advanced 28 - Indirect - Static
• Advanced 29 - Indirect - Dynamic

Section 7 - What IF Tools

• Advanced 30 - Goal Seek
• Advanced 31 - Data Tables
• Advanced 32 - Scenarios
• Advanced 33 - Solver

Section 8 - Excel Advanced - Conclusion

• Advanced 34 - Excel Advanced - Conclusion

Section 9 - Bonus # 1 - Advanced Pivot Tables

• Advanced 35 - Building a Mini Dashboard