Completed
- Mastering Pivot Tables for Data Analysis in Excel
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
How to Use Excel - A 3-Hour Path to Confidence and Skills
Automatically move to the next video in the Classroom when playback concludes
- 1 - Introduction to Excel for Beginners
- 2 - Opening Microsoft Excel: A Beginner's Guide
- 3 - How to Create a Blank Workbook in Excel
- 4 - Understanding Basic Excel Terminology and Layout
- 5 - Navigating the Excel Interface: Tabs, Ribbons, and Groups
- 6 - Saving Your Excel Workbook: Best Practices
- 7 - How to Enter Column Headers in Excel
- 8 - Formatting Columns and Rows for Better Readability
- 9 - Enhancing Your Data: Formatting Text and Cells in Excel
- 10 - Utilizing Cell Styles for Professional-Looking Spreadsheets
- 11 - Mastering Text Wrapping and Merging Cells
- 12 - Financial Formatting: Adding Dollar Symbols and Number Formatting
- 13 - Printing Excel Spreadsheets: Tips and Tricks
- 14 - Organizing Your Work: Creating and Naming New Sheets
- 15 - Formula Basics: Creating Formulas with Cell References
- 16 - Absolute Cell Referencing: Locking in Your References
- 17 - Enhancing Your Analysis: Adding Functions in Excel
- 18 - Data Management: Sorting and Filtering Your Data
- 19 - Visualizing Data: Adding Charts in Excel
- 20 - Customizing Your Excel Ribbon for Efficiency
- 21 - Mastering Autofill: A Key Time-Saver in Excel
- 22 - Flash Fill: Automating Data Entry with Ease
- 23 - Combining Cells Efficiently in Excel
- 24 - Essential Keyboard Shortcuts for Column & Row Adjustments
- 25 - Advanced Techniques for Sorting Data in Excel
- 26 - Implementing Filters for Efficient Data Management
- 27 - Advanced Filtering in Excel: A Step-by-Step Guide
- 28 - Simplifying Data Extraction with the FILTER Function
- 29 - Maximizing Efficiency with Excel Tables
- 30 - Interactive Data Filtering: Adding Slicers in Excel
- 31 - Understanding Cell Referencing: Relative vs. Absolute
- 32 - Making Decisions in Excel with the IF Function
- 33 - Enhancing the IF Function with AND Conditions
- 34 - Complex Decision Making: Nested IF and AND Functions
- 35 - Streamlining Data Entry with Dropdown Lists
- 36 - Easy Reference: Building Named Ranges in Excel
- 37 - Unlocking Potential with the INDIRECT Function
- 38 - Crafting a User-Friendly Data Entry Form in Excel
- 39 - Gaining Insights: Conditional Formatting in Excel
- 40 - Analyzing Data with SUMIF and SUMIFS Functions
- 41 - Counting Data Points with COUNTIF and COUNTIFS Functions
- 42 - Working with Dates: Date and Time Functions in Excel
- 43 - Mastering Pivot Tables for Data Analysis in Excel
- 44 - Lookup Techniques: How to Use VLOOKUP in Excel
- 45 - Leveraging the UNIQUE and FILTER Functions for Advanced Data Analysis
