Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Supercharge: Mastering Microsoft Excel for Success
Week 1: Excel Essentials: Mastering the Basics
1. Navigating Excel like a Pro
2. Creating and Saving Workbooks
3. Cell Magic: Entering Data and Basic Formatting
4. Formulas Unleashed: Basic Calculations and AutoSum
5. Aesthetic Appeal: Formatting Cells and Numbers
6. Supercharge Your Productivity: Time-Saving Tips and Tricks
Week 2: Mastering Data Management: Unlocking the Power of Excel
1. Sorting and Filtering: Taming Your Data
2. Tables: Organize and Analyze Your Data with Ease
3. Data Validation: Ensure Accurate Input and Control Data
4. Color Your World: Conditional Formatting
5. Count, Sum, Average: Essential Functions for Data Analysis
6. Cell References Decoded: Absolute and Relative
Week 3: Styling Sheets: Advanced Formatting Techniques for Stunning Spreadsheets
1. Formatting Finesse: Fonts, Colors, and Borders
2. Merging Cells: Creating Attention-Grabbing Designs
3. Picture Perfect: Inserting and Formatting Images and Shapes
4. Formulas and Formatting: Conditional Formatting with Formulas
5. Themes and Templates: Professional and Consistent Look
6. From Spreadsheet to Printout: Formatting Worksheets and Printing Options
Week 4: Formula Fundamentals: From Zero to Excel Hero
1. Unveiling the Power of Formulas
2. Math Magic: Mastering Arithmetic Operators and Order of Operations
3. Essential Functions: SUM, AVERAGE, COUNT, MAX, MIN
4. Logical Brilliance: IF, AND, OR Functions
5. Cell References Revealed: Absolute and Mixed References
6. Nested Functions: Advanced Techniques for Complex Calculations
Week 5: Data Analysis and Visualization: Unleashing Insights with Excel
1. Analyzing Data like a Pro
2. Sorting and Filtering: Unlocking Data Insights
3. Conditional Calculations: Advanced Formulas for Data Analysis
4. Charting Success: Creating and Modifying Eye-Catching Charts
5. Formatting Finesse: Customizing and Polishing Your Charts
6. Pivot Power: Unleashing the Power of Pivot Tables
7. Beyond the Basics: Exploring Advanced Data Analysis Add-Ins
4. Formulas and Formatting: Conditional Formatting with Formulas
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock