Excel Beginners part 1 out of 3 Section 1 – Excel Beginner Beginner 1 – Introduction Section 2 – Excel …
€99.00
Excel Beginners part 1 out of 3

- Beginner 1 - Introduction
- 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
- 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
- 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
- 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
- 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
- Beginner 36 - Inserting Images and Shapes
- Beginner 37 - Working with SmartArt
- Beginner 38 - Print Preview
- Beginner 39 - Margins, Scaling and Orientation
- Beginner 40 - Printing
- Beginner 41 - Intro to Excel Templates
- Beginner 42 - Opening an Existing Template
- Beginner 43 - Creating a Custom Template
- Beginner 44 - Conclusion
Excel Intermediate part 2 out of 3

- Intermediate 1 - Excel Intermediate Introduction
- Intermediate 2 - Intermediate Shortcut Keys
- 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
- 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
- Intermediate 16 - Data Validation - List
- Intermediate 17 - Data Validation - Decimal
- Intermediate 18 - Input and Error Messages
- Intermediate 19 - Importing Data from Text Files
- Intermediate 20 - Importing Data from MS Access
- Intermediate 21 - Exporting Data to a Text File
- Intermediate 22 - Creating Basic Charts
- Intermediate 23 - The Chart Ribbon
- Intermediate 24 - Adding and Modifying Data on a Chart
- Intermediate 25 - Formatting ChartsSection
- 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
- Intermediate 35 - Grouping Data
- Intermediate 36 - Consolidating Data
- Intermediate 37 - VLookUp
- Intermediate 38 - HLookUp
- Intermediate 39 - Index and Match
- Intermediate 40 - FV Function
- Intermediate 41 - PMT Function
- Intermediate 42 - Hyperlinks
- Intermediate 43 - Text to Columns
- 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:
- 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
- Advanced 1 - Excel Advanced Introduction
- Advanced 2 - Advanced Shortcut Keys
- Advanced 3 - Tracing Precedents
- Advanced 4 - Tracing Dependants
- Advanced 5 - Watch Window
- Advanced 6 - Show Formulas
- Advanced 7 - Protecting Cells in a Worksheet
- Advanced 8 - Protecting the Workbook Structure
- Advanced 9 - Encryption with Passwords
- 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
- 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
- Advanced 25 - Left, Right and Mid Function
- Advanced 26 - Search Function
- Advanced 27 - Concatenate and Search
- Advanced 28 - Indirect - Static
- Advanced 29 - Indirect - Dynamic
- Advanced 30 - Goal Seek
- Advanced 31 - Data Tables
- Advanced 32 - Scenarios
- Advanced 33 - Solver
- Advanced 34 - Excel Advanced - Conclusion
- Advanced 35 - Building a Mini Dashboard
Cursus inhoud
-
- Excel Beginners part 1 out of 3 00:00:00
- Excel Intermediate part 2 out of 3 00:00:00
- Excel Advanced part 3 out of 3 00:00:00
-
- Certificaat van Deelname aanvragen 00:00:00