• Geen producten in je winkelmand.

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

99.00
Cursus toegang

1 jaar

Aantal studenten

87

Gemaakt door
IMNL & Stichting Gezondheid

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

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

Cursus reviews

© Interplein Academy