Your Excel journey starts here!

Duration.

  1. Beginners 2.45 hours
  2. Intermediate 2.32 hours
  3. Advanced 2.26 hours

Whether you have little or no experience with Excel. Start with Excel Beginner and start learning how to:

  • From the fundamentals, to the most advanced features, this training covers everything you need to know about Excel
  • Create spreadsheets
  • Master all the basics of Excel, even if you’ve never seen a spreadsheet before!

 

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

Course Curriculum

No curriculum found !

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • 99.00
  • 1 year
393 STUDENTS ENROLLED
Select your currency
EUR Euro