Microsoft Excel Tutorial - Beginners Level 4

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn advanced Microsoft Excel techniques in this 25-minute tutorial for beginners at level 4. Master conditional formatting, data validation, drop-down menus, and slicers to enhance your spreadsheet skills. Explore practical examples and step-by-step instructions on using these powerful features to analyze and present data effectively. Gain hands-on experience with provided practice data and discover how to create dynamic, interactive worksheets that streamline your work processes.

Syllabus

Introduction.
What is Conditional Formatting in Excel?.
How to use Conditional Formatting.
What is Data Validation in Microsoft Excel?.
How to create a drop-down menu in Excel.
Create a drop-down list from a list.
How does a slicer work in Microsoft Excel?.
Add slicers to your worksheet.