Beschrijving
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
