Course Content
Microsoft Excel 101 Course Introduction
0/3
Ask Questions
01:42
Course Exercise Files
01:29
Certificate of Completion
01:19
Microsoft Excel Fundamentals
0/10
Launching Excel
01:42
Microsoft Excel Startup Screen
03:16
Introduction to the Excel Interface
07:11
Customizing the Excel Quick Access Toolbar
02:57
More on the Excel Interface
03:35
Understanding the Structure of an Excel Workbook
03:59
Saving an Excel Document
04:01
Opening an Existing Excel Document
01:37
Common Excel Shortcut Keys
02:48
Excel Fundamentals Quiz
Entering and Editing Text and Formulas
0/8
Entering Text to Create Spreadsheet Titles
08:16
Working with Numeric Data in Excel
08:28
Entering Date Values in Excel
08:38
Working with Cell References
06:01
Creating Basic Formulas in Excel
08:34
Relative Versus Absolute Cell References in Formulas
12:34
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
10:37
Entering and Editing Text and Formulas Quiz
Working with Basic Excel Functions
0/10
The structure of an Excel Function
10:17
Working with the SUM() Function
07:01
Working with the MIN() and MAX() Functions
06:19
Working with the AVERAGE() Function
02:53
Working with the COUNT() Function
02:52
Adjacent Cells Error in Excel Calculations
03:40
Using the AutoSum Command
06:49
Excel’s AutoSum Shortcut Key
02:13
Using the AutoFill Command to Copy Formulas
04:25
Basic Excel Functions Quiz
Modifying an Excel Worksheet
0/8
Moving and Copying Data in an Excel Worksheet
06:34
Inserting and Deleting Rows and Columns
07:14
Changing the Width and Height of Cells
05:18
Hiding and Unhiding Excel Rows and Columns
05:09
Renaming an Excel Worksheet
02:52
Deleting an Excel Worksheet
04:34
Moving and Copying an Excel Worksheet
05:12
Modifying Worksheets Quiz
Formatting Data in an Excel Worksheet
0/12
Working with Font Formatting Commands
Changing the Background Color of a Cell
Adding Borders to Cells
Excel Cell Borders Continued
Formatting Data as Currency Values
Formatting Percentages
Using Excel’s Format Painter
Creating Styles to Format Data
Merging and Centering Cells
Using Conditional Formatting
Editing Excel Conditional Formatting
Formatting Data Quiz
Inserting Images and Shapes into an Excel Worksheet
0/4
Inserting Images
Inserting Excel Shapes
Formatting Excel Shapes
Working with Excel SmartArt
Creating Basic Charts in Excel
0/7
Creating an Excel Column Chart
Working with the Excel Chart Ribbon
Adding and Modifying Data on an Excel Chart
Formatting an Excel Chart
Moving a Chart to another Worksheet
Working with Excel Pie Charts
Working with Excel Charts Quiz
Printing an Excel Worksheet
0/7
Viewing your Document in Print Preview
Changing the Margins, Scaling and Orientation
Excel Worksheet Margins
Excel Worksheet Margins
Adding Header and Footer Content
Adding Header and Footer Content
Printing an Excel Worksheet Quiz
Working with Excel Templates
0/4
Intro to Excel Templates
Opening an Existing Template
Creating a Custom Template
Excel Templates Quiz
Excel 101 – Practice What You’ve Learned (DOWNLOAD)
0/1
Excel 101 – Practice What You’ve Learned (DOWNLOAD)
Congratulations! You’ve Built a Solid Microsoft Excel Foundation
0/1
Congratulations!
Microsoft Excel 102 Course Introduction
0/1
Excel 102 Course Exercise Files — DOWNLOAD
Working with an Excel List
0/10
Understanding Excel List Structure
Sorting a List Using Single Level Sort
Sorting a List Using Multi-Level Sorts
Using Custom Sorts in an Excel List
Filter an Excel List Using the AutoFilter Tool
Creating Subtotals in a List
Format a List as a Table
Using Conditional Formatting to Find Duplicates
Removing Duplicates
Excel List Quiz
Excel List Functions
0/8
Introduction to Excels Function: DSUM()
Excel DSUM Function Single Criteria Continued
Excel DSUM Function with OR Criteria
Excel DSUM Function with AND Criteria
Excel Function: DAVERAGE()
Excel Function: DCOUNT()
Excel Function: SUBTOTAL()
List Functions :Quiz
Excel Data Validation
0/6
Understanding the Need for Excel Data Validation
Creating an Excel Data Validation List
Excel Decimal Data Validation
Adding a Custom Excel Data Validation Error
Dynamic Formulas by Using Excel Data Validation Techniques
Data Validation Quiz
Importing and Exporting Data
0/8
Importing Data Into Microsoft Excel
Importing Data from Text Files
Importing Data from Microsoft Access
NEW VERSION — Import Data From Text Files into Excel
NEW VERSION — Import Data From a Database into Excel
Microsoft Excel Legacy Import Options for New Excel Versions
Exporting Data to a Text File
Importing and Exporting Data Quiz
Excel PivotTables
0/10
Understanding Excel PivotTables
Creating an Excel PivotTable
Modifying Excel PivotTable Calculations
Grouping PivotTable Data
Formatting PivotTable Data
Modifying PivotTable Calculations
Drilling Down into PivotTable Data
Creating PivotCharts
Filtering PivotTable Data
Filtering with the Slicer Tool
Working with Excel’s PowerPivot Tools
0/7
Introduction to Excel Power Pivot
Why PowerPivot?
Activating the Excel PowerPivot AddIn
Creating Data Models with PowerPivot
Excel Power Pivot Data Model Relationships
Creating PivotTables based on Data Models
Excel Power Pivot KPIs
Working with Large Sets of Excel Data
0/5
Using the Freeze Panes Tool
Grouping Data (Columns and/or Rows)
Print Options for Large Sets of Data
Linking Worksheets (3D Formulas)
Consolidating Data from Multiple Worksheets
Excel 102 Additional Practice Exercises
0/1
Excel 102 – Practice What You’ve Learned (DOWNLOAD)
Congratulations! You’re an Intermediate Excel User
0/1
Congratulations!
Microsoft Excel 103 Course Introduction
0/1
Excel 103 Course Exercise Files — DOWNLOAD
Working with Excel’s Conditional Functions
Working with Excel’s Lookup Functions
Working with Excel’s Text Based Functions
Auditing an Excel Worksheet
Protecting Excel Worksheets and Workbooks
Mastering Excel’s “What If?” Tools
Automating Repetitive Tasks in Excel with Macros
Excel 103 Additional Practice Exercises
Congratulations!
Microsoft Excel Macros and VBA Course Introduction
Project #1: Using Excel’s Macro Recorder Tool
Excel VBA Concepts
Working with Excel VBA Logic Statements
Project #2: Moving Beyond the Basics and into VBA
Project #3: Preparing and Cleaning Up Data with Excel VBA
Project #4: Using VBA to Automate Excel Formulas
Project #5: Bringing it All Together and a Weekly Report
Project #6: Working with Excel VBA User Forms
Project #7: Importing Data from Text Files
Course Wrap Up
Microsoft Excel – Excel from Beginner to Advanced | Udemy Free Course
Join the conversation
Previous
Next
0% Complete
Copy link
CopyCopied
Powered by Social Snap