Microsoft Excel 2016 / 2019 Course Overview
The Microsoft Excel 2016 / 2019 Course Overview equips learners with essential spreadsheet skills for data analysis and management. Ideal for business analysts, financial professionals, and administrative staff, this course enhances productivity, enabling users to efficiently organize, analyze, and visualize data, ultimately driving informed decision-making in various professional settings.
Course outline & what you'll learn
Overview of Excel interface
- Understanding workbooks and worksheets
- Entering and editing data
- Formatting cells and ranges
- Using styles and themes
- Introduction to formulas
- Common functions (SUM, AVERAGE, COUNT, etc.)
- Using IF statements and nested functions
- Sorting and filtering data
- Using tables and structured references
- Introduction to data validation
- Creating different types of charts
- Customizing chart elements
- Adding and formatting data labels
- Lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Introduction to pivot tables
- Using conditional formatting
- Protecting and sharing workbooks
- Using comments and notes
- Saving and exporting options
- Recording macros
- Basic VBA concepts
- Automating repetitive tasks
- Data organization techniques
- Troubleshooting common issues
- Time-saving shortcuts and features
Why train with Traincrest
This Microsoft course is delivered by Traincrest's certified instructors, live online or in the classroom, with hands-on labs and a 98% exam success rate. Trusted by 500+ companies and 50,000+ students worldwide.