Power BI Fundamentals - Create visualizations and dashboards from scratch
Get 20% off all career paths from fullstack to AI
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
Taught by
Teacher's Tech