Learn Backend Development Part-Time, Online
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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