Microsoft Excel Training Courses.
Empower your workforce to enhance their Excel skills with instructor-led Microsoft Excel training courses. Our end user training courses will advance your team’s knowledge and IT skillsets when using the features within the Excel application. Select from beginner and advanced Microsoft Excel training courses to meet different employee usability requirements. 848’s Microsoft training courses can be delivered virtually, at your desired location, or at the 848 Group head office.
Introduction to Microsoft Excel Training Course.
Course Outline.
This introductory course is designed for end users who have limited experience with Microsoft Excel. This course will make you feel more confident using Excel. Learn how to create easy-to-use and professional looking spreadsheets from scratch. You will understand built-in calculation and formula functionality. To help you work faster and more productively in Excel. Learn how to present your data visually using graphs and charts, format your spreadsheets and more.
The estimated course duration is 6 hours. This can be delivered in one 6-hour session (with breaks) or 2 x 3 hours. You will receive a certificate of completion at the end of the course.
Topics Covered.
- Tour the Window
- Enter and Edit Data
- Create Range Names
- AutoFill
- Working with Sheets
- Working with Columns and Rows
- Text and number formatting
- Borders and cell styles
- Functions and Formulas
- Relevant/Absolute Referencing
- BODMAS
- Graphs and Charts
- Spell Check
- Headers and Footers
- Page Setup
- Print Preview
- Printing Options
- Sort a Database
- Multiple Sorting
- AutoFilter
- Conditional Criteria
- Top 10 Filters
- Advanced Filters
Advanced Microsoft Excel Training Course.
Course Outline.
This course is designed for regular users of Microsoft Excel who would like to discover and master further advanced capabilities. Enhance your skills in Excel by learning features and functionality such as pivot tables, logical functions (if, and, or, not), lookup functions (VLOOKUP, HLOOKUP), data validation, and protection.
The estimated course duration is 6 hours. This can be delivered in one 6-hour session (with breaks) or 2 x 3 hours. You will receive a certificate of completion at the end of the course.
Topics Covered.
- Text to columns
- Merge cell data
- Database functions
- Formula and command linking
- Linking workbooks
- Protect sheets
- Protect cells
- Freeze panes
- IF Functions
- IF/OR Functions
- IF/AND Functions
- Nested IF
- AND Function
- OR Function
- NOT Function
- COUNT/IF Function
- SUM/IF Function
- Pivot tables
- HLOOKUP
- VLOOKUP
- Data list
- Conditional formatting
- Data validation