Microsoft excel course for beginner to advanced learners
MODULE 4 / 6 - DATA ANALYSIS
Lesson 17 - Named Ranges in Excel
In this free training video, you will get an understanding of using Named Ranges in Excel. This session includes the following topics:
- Creating Named Ranges
- Managing Named Ranges
- Useful Keyboard Shortcuts
- Creating Dynamic Named Ranges using OFFSET and INDEX formulas
Lesson 18 - Data Validation in Excel
The video covers the following topics:
- Data Validation Criteria
- Input Message
- Customizing Error Messages
- Circle Invalid Entries
Advanced Data Validation Tricks such as creating dependent validation, making subheadings in validation, disguising numbers as text, and creating dynamic drop-down lists.
Lesson 19 - Data Sorting and Filtering in Excel
This Free training video covers data sorting and filtering in Excel. The video will teach you the following topics:
- Sorting data
- Multi-level sorting
- Filtering data
- Advanced filtering
- Filtering and sorting in Excel data tables.
Lesson 20 - Using Conditional Formatting in Excel
In this free training video, you will discover the power of conditional formatting in Excel. The topics covered are:
- Understanding Conditional Formatting
- Applying Formulas in Conditional Formatting
- Advanced Examples of Conditional Formatting, such as highlighting every Nth row and creating dynamic searches.