Learn AI, Data Science & Business — Earn Certificates That Get You Hired
MIT Sloan: Lead AI Adoption Across Your Organization — Not Just Pilot It
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
Master essential Excel productivity techniques in this comprehensive 49-minute tutorial designed to help professionals work faster and more efficiently. Learn time-saving keyboard shortcuts and navigation methods to move through spreadsheets with ease. Discover formatting essentials for creating clean, professional-looking spreadsheets that enhance readability and presentation. Explore data management through sorting and filtering techniques, and apply conditional formatting to highlight important information automatically. Get introduced to fundamental formulas that automate calculations and streamline your workflow. Finally, learn to create and customize charts that transform raw data into clear, compelling visual presentations. The tutorial includes downloadable course files for hands-on practice and covers eight key areas: course introduction, two-part keyboard shortcuts and navigation training, formatting essentials, sorting and filtering strategies, conditional formatting basics, formula fundamentals, and chart creation and customization techniques.
Syllabus
00:00:00 - Course Introduction
00:01:27 - Keyboard Shortcuts and Efficient Navigation Part 1
00:09:22 - Keyboard Shortcuts and Efficient Navigation Part 2
00:13:14 - Formatting Essentials for Clean Spreadsheets
00:23:15 - Sorting and Filtering Tips
00:29:09 - Conditional Formatting Basics
00:37:47 - Introduction to Formulas
00:41:09 - Creating and Customizing Charts
Taught by
Simon Sez IT