Microsoft excel course for beginner to advanced learners - MODULE 4

0

Microsoft excel course for beginner to advanced learners

MODULE 4 / 6 - DATA ANALYSIS

Microsoft excel course for beginner to advanced learners


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.

Eng Of Post Multiplex Join Us On Telegram

Post a Comment

0Comments
Post a Comment (0)