1. Introduction to the Microsoft Excel Course

1.1 Excel as the Professional Tool of Microsoft

1.2 What Is a Spreadsheet?

1.3 Purpose and Capabilities of Excel

2 Getting Excel from the Official Microsoft Website

2.1 Installing and Accessing Excel

3. Exploring the Excel Start Screen

3.1 Understanding Templates and Recent Projects

4. Accessing Excel Options and Office Theme Settings

4.1 Customizing Theme and Matching Course Appearance

5. Creating Your First Spreadsheet

6. Navigation Options in the Excel Bottom Bar

6.1 Adjusting Zoom and Viewing Percentages

6.2 Exploring Excel’s Viewing Modes

7 Understanding Cells and the Excel Grid

7.1 Purpose of the Excel Sheet and the Workbook Structure

7.2 Managing Sheets Renaming, Copying, and Deleting

8 Entering Data into Excel Cells

8.1 Adding Sample Information to the Worksheet

8.2 Expanding the Dataset with More Examples

1. Overview of Excel’s Font Tools

2 Understanding Selection in Excel vs. Word and PowerPoint

2.1 How Selection Works in Excel

2.2 Applying Formatting to Selected Cells

3 Selecting and Formatting Rows and Columns

3.1 How to Select an Entire Row or Column

3.2 Adjusting Font Style and Size

4 Formatting Text in Excel

5 Applying Borders to Cells and Selections

5.1 Exploring Advanced Border Options

5.2 Using Draw Border and Draw Border Grid

5.3 Erasing and Customizing Borders

6 Changing the Cell Background Color in Excel

6.1 Changing the Font Color in Excel

1 Intro to Alignment Tools

2 Using the Alignment Section in Excel

2.1 Applying Text Angles and Directions

2.2 Applying Text Angles and Directions

3 Styling Selections for Impact

4 Formatting Data as a Table in Excel

4.1 Understanding Table Addressing in Excel

4.2 Understanding Table Addressing in Excel

1 Formatting and Adjusting Cells in Excel

1.1 Adjusting Row Height and Column Width

2 Deleting Cells in Excel

3 Inserting Cells with Ease

4 Understanding the Clipboard in Excel

4.1 Copying and Pasting Cells in Excel

4.2 Exploring Paste Options and Formats

5 Using Format Painter for Quick Styling

1 Exploring the Insert Tab in Excel

1.1 Inserting Pictures into Cells

1.2 Placing Pictures Over Cells

1.3 Editing Pictures Using the Picture Format Tab

1.4 Applying Color and Transparency Adjustments

1.5 Using Picture Styles and Effects in Excel

2 Inserting Shapes in Excel

2.1 Using the Shape Format Tab

2.2 Adding and Formatting Text Inside Shapes

2.3 Customizing and Moving Shapes in Excel

3 Using Icons for Visual Appeal

4 Inserting 3D Models in Excel

4.1 Using the 3D Model Tab and Rotation Options

5 Inserting SmartArt in Excel

5.1 Editing SmartArt Content and Design

5.2 Formatting SmartArt in Excel

6 Capturing Screenshots

1 Introduction to Chart Creation

1.1 Selecting Data for the Chart

1.2 Preparing the Spreadsheet for Charting

1.3 Exploring the Recommended Charts Feature

1.4 Generating the Chart

2 Choosing Specific Chart Types

2.1 Editing the Chart Title

2.2 Customizing Chart Style and Design

2.3 Personalizing Charts with the Format Tab

2.4 Conclusion Chart Features in Excel

1 Intro to Page Layout Tools

2 Themes and Consistency in Excel

3 Introduction to Page Setup and Margins

3.1 Demonstration of Changing Margins

4 Switching Page Orientation

5 Choosing the Right Page Size

6 Adding Page Backgrounds

7 Printing Your Spreadsheet

1 Getting Started with PivotTables

2 Opening the Sample Data File

2.1 Introducing Recommended Pivot Tables

2.2. Exploring Pivot Table Presetsmp4

2.3 Understanding Row Labels and Fields

2.4 Creating a Pivot Table from Scratch

2.5 Understanding Cell Addressing and Ranges

2.6 Exploring Pivot Table Layout Areas

2.7 Organizing Data by Categories

2.8 Viewing Customer Interests per Category

2.9 Using Filters to Refine Data

2.10 Adding Columns to the Pivot Table

2.11 Understanding the Values Area

2.12 Summarizing Revenue and Quantities

2.13 Interpreting the Pivot Table Results

2.14 Closing and Practice Encouragement

1 Intro to Formulas in Excel

2 Understanding Cell Addressing in Excel

2.1 Reading Cell Names and Examples

2.2 Introducing Ranges in Excel

2.3 Transition to Excel Functions

3 Importing the Sample Data

3.1 Introducing Functions and Formulas

3.2 The Purpose of Functions in Excel

3.3 Using Cell Addresses in Formulas

3.4 Demonstrating Cell Linking

4 Introducing Numeric Formulas

4.1 Writing a Basic Addition Formula

4.2 Explaining How Excel Calculates

5 Introducing Subtraction in Excel

5.1 Writing a Subtraction Formula

5.2 Applying Subtraction to Another Row

6 Introducing Multiplication in Excel

6.1 Writing a Multiplication Formula

6.2 Wrapping Up Multiplication

7 Basic Math Formulas Divide

8 Introducing Combined Formulas in Excel

8.1 Writing a Multi-Step Formula with Parentheses

8.2 Result and Example Calculation

8.3 Applying the Formula to Another Example

1 Introducing Excel Functions

2 More In Excel Functions

2.1 How Excel Functions Are Written

2.2 Providing Values to the SUM Function

2.3 Executing the SUM Function

3 Introducing the MIN Function

3.1 Applying MIN to Sales Data

3.2 Understanding the Result

4 Exploring Excel Functions Max

5 Introducing the COUNT Function

5.1 Demonstration Empty Cells vs Numeric Cells

5.2 Using COUNT with Ranges & What It Ignores

6 Exploring Excel Functions Counta

7 Introducing the AVERAGE Function

7.1 Writing the AVERAGE Formula

7.2 Understanding How Averages Are Calculated

7.3 Manual Check and Confirmation

8 Understanding the Concept of Median

8.1 Calculating the Median in Practice

9. Introducing the CONCAT Function

9.1 Using CONCAT to Combine Text

10 Introducing the IF Function in Excel

10.1 Testing Multiple Conditions with IF

10.2 Applying Logic with the IF Function

11 Understanding the COUNTIF Function in Excel

11.1 Applying COUNTIF with Conditions

11.2 Counting Specific Values with COUNTIF

12 Introduction to VLOOKUP in Excel

12.1 Specifying the Table Array and Column Index

12.2 Understanding Exact and Approximate Match in VLOOKUP

12.3 Understanding Exact and Approximate Match in VLOOKUP

13 Introducing the SUMIF Function in Excel

13.1 Applying the SUMIF Function Step by Step

13.2 Setting Criteria and Sum Range in SUMIF

14 Exploring Excel Functions Now

1 Protecting Sheets in Excel

2 Saving Your Spreadsheet

3 Exporting as XLSX

4 Exporting as CSV

5 Exporting as TXT

6 Exporting as PDF