Database Restore In 00:00:00
Start your marketplace Get a personalized demo
Home
EN - USD
Site Language
Site Currency
Microsoft Excel - Excel from Beginner to Advanced
  • Home
  • Courses
  • Microsoft Excel - Excel from Beginner to Advanced
Microsoft Excel - Excel from Beginner to Advanced
5.00 (1)
Office Productivity / Microsoft

Microsoft Excel - Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course

Ezequiel Heaney
Ezequiel Heaney
6 Students enrolled
Expert
English
This course includes:
  • 28h 23m
  • 266 Lectures
  • 359 Downloadable assets
  • Full lifetime access
  • Access on Mobile and TV
  • Certificate on completion
$856.00

Overview

What will students learn in your course?
  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Access to a Professional Trainer with 10+ years of Excel Training
What are the requirements or prerequisites for taking your course?
  • No Prior Excel Knowledge Required
  • Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended
Who is the course for?
  • This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
Description
Course tags

Course content

  • 43 Sections
  • 266 Lectures
  • 28h 23m Total length
Microsoft Excel 101 Course Introduction
20m
3 Lectures

Microsoft Excel 101 Course Introduction

Ask Questions
Preview 0:06:12
Course Exercise Files
Preview 0:06:54
Certificate of Completion
Preview 0:06:54
Launching Excel
Preview 0:06:12
Microsoft Excel Startup Screen
0:07:30
Introduction to the Excel Interface
Preview 0:09:13
Customizing the Excel Quick Access Toolbar
0:06:12
More on the Excel Interface
0:06:12
Understanding the Structure of an Excel Workbook
0:06:12
Saving an Excel Document
0:03:41
Opening an Existing Excel Document
0:03:41
Common Excel Shortcut Keys
0:06:12
Excel Fundamentals Quiz
0:07:30
Entering Text to Create Spreadsheet Titles
0:03:41
Working with Numeric Data in Excel
0:06:12
Entering Date Values in Excel
0:09:13
Working with Cell References
0:07:30
Creating Basic Formulas in Excel
0:03:41
Relative Versus Absolute Cell References in Formulas
0:07:30
Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
0:06:54
Entering and Editing Text and Formulas Quiz
0:06:12
The structure of an Excel Function
Preview 0:09:13
Working with the SUM() Function
0:07:30
Working with the MIN() and MAX() Functions
0:06:54
Working with the AVERAGE() Function
0:06:54
Working with the COUNT() Function
0:06:12
Adjacent Cells Error in Excel Calculations
0:07:30
Using the AutoSum Command
0:07:30
Excel's AutoSum Shortcut Key
0:06:12
Using the AutoFill Command to Copy Formulas
0:06:54
Basic Excel Functions Quiz
0:06:54
Moving and Copying Data in an Excel Worksheet
0:03:41
Inserting and Deleting Rows and Columns
0:06:54
Changing the Width and Height of Cells
0:07:30
Hiding and Unhiding Excel Rows and Columns
0:03:41
Renaming an Excel Worksheet
0:07:30
Deleting an Excel Worksheet
0:07:30
Moving and Copying an Excel Worksheet
0:09:13
Modifying Worksheets Quiz
0:09:13
Working with Font Formatting Commands
0:06:12
Changing the Background Color of a Cell
0:06:54
Adding Borders to Cells
0:06:12
Excel Cell Borders Continued
0:09:13
Formatting Data as Currency Values
0:06:12
Formatting Percentages
0:03:41
Using Excel's Format Painter
0:07:30
Creating Styles to Format Data
0:09:13
Merging and Centering Cells
0:06:12
Using Conditional Formatting
0:06:54
Editing Excel Conditional Formatting
0:03:41
Formatting Data Quiz
0:09:13
Inserting Images
0:06:54
Inserting Excel Shapes
0:03:41
Formatting Excel Shapes
0:07:30
Working with Excel SmartArt
0:06:12
Creating an Excel Column Chart
0:03:41
Working with the Excel Chart Ribbon
0:07:30
Adding and Modifying Data on an Excel Chart
0:03:41
Formatting an Excel Chart
0:06:54
Moving a Chart to another Worksheet
0:07:30
Working with Excel Pie Charts
0:03:41
Working with Excel Charts Quiz
0:07:30
Viewing your Document in Print Preview
0:06:54
Changing the Margins, Scaling and Orientation
0:07:30
Excel Worksheet Margins
0:07:30
Working with Page Layout View
0:09:13
Adding Header and Footer Content
0:09:13
Printing a Specific Range of Cells
0:07:30
Printing an Excel Worksheet Quiz
0:03:41
Intro to Excel Templates
Preview 0:07:30
Opening an Existing Template
0:09:13
Creating a Custom Template
0:07:30
Excel Templates Quiz
0:03:41
Excel 101 - Practice What You've Learned (DOWNLOAD)
0:06:12
Congratulations!
0:06:12
Excel 102 Course Exercise Files -- DOWNLOAD
0:06:12
Understanding Excel List Structure
Preview 0:03:41
Sorting a List Using Single Level Sort
0:09:13
Sorting a List Using Multi-Level Sorts
0:07:30
Using Custom Sorts in an Excel List
0:06:54
Filter an Excel List Using the AutoFilter Tool
0:07:30
Creating Subtotals in a List
0:03:41
Format a List as a Table
0:07:30
Using Conditional Formatting to Find Duplicates
0:03:41
Removing Duplicates
0:06:12
Excel List Quiz
0:09:13
Introduction to Excels Function: DSUM()
0:03:41
Excel DSUM Function Single Criteria Continued
0:03:41
Excel DSUM Function with OR Criteria
0:06:12
Excel DSUM Function with AND Criteria
0:07:30
Excel Function: DAVERAGE()
0:07:30
Excel Function: DCOUNT()
0:09:13
Excel Function: SUBTOTAL()
0:03:41
List Functions :Quiz
0:06:12
Understanding the Need for Excel Data Validation
Preview 0:06:54
Creating an Excel Data Validation List
0:03:41
Excel Decimal Data Validation
0:03:41
Adding a Custom Excel Data Validation Error
0:03:41
Dynamic Formulas by Using Excel Data Validation Techniques
0:07:30
Data Validation Quiz
0:03:41
Importing Data Into Microsoft Excel
0:09:13
Importing Data from Text Files
0:03:41
Importing Data from Microsoft Access
0:06:12
NEW VERSION -- Import Data From Text Files into Excel
0:07:30
NEW VERSION -- Import Data From a Database into Excel
0:06:12
Microsoft Excel Legacy Import Options for New Excel Versions
0:09:13
Exporting Data to a Text File
0:06:54
Importing and Exporting Data Quiz
0:06:12
Understanding Excel PivotTables
Preview 0:07:30
Creating an Excel PivotTable
0:09:13
Modifying Excel PivotTable Calculations
0:06:54
Grouping PivotTable Data
Preview 0:06:54
Formatting PivotTable Data
0:06:54
Modifying PivotTable Calculations
0:09:13
Drilling Down into PivotTable Data
0:06:54
Creating PivotCharts
0:07:30
Filtering PivotTable Data
0:06:12
Filtering with the Slicer Tool
0:09:13
Introduction to Excel Power Pivot
0:09:13
Why PowerPivot?
0:06:54
Activating the Excel PowerPivot AddIn
0:06:54
Creating Data Models with PowerPivot
0:07:30
Excel Power Pivot Data Model Relationships
0:06:12
Creating PivotTables based on Data Models
0:06:12
Excel Power Pivot KPIs
0:03:41
Using the Freeze Panes Tool
0:07:30
Grouping Data (Columns and/or Rows)
0:03:41
Print Options for Large Sets of Data
0:06:12
Linking Worksheets (3D Formulas)
0:09:13
Consolidating Data from Multiple Worksheets
0:03:41
Excel 102 - Practice What You've Learned (DOWNLOAD)
0:03:41
Congratulations!
0:07:30
Excel 103 Course Exercise Files -- DOWNLOAD
0:03:41
Working with Excel Name Ranges
0:09:13
Advantages and Disadvantages of Excel Name Ranges
0:06:12
Editing an Excel Name Range
0:03:41
Using Excel's IF() Function
0:06:12
Excel's IF() Function with a Name Range
0:06:54
Nesting Functions with Excel
0:03:41
Nesting Excels AND() Function within the IF() Function
0:06:54
Using Excel's COUNTIF() Function
0:06:12
Using Excel's SUMIF() Function
0:06:12
Using Excel's IFERROR() Function
0:03:41
Microsoft Excel VLOOKUP() Function
0:03:41
Microsoft Excel HLOOKUP() Function
0:06:12
Microsoft Excel INDEX() Function
0:03:41
Microsoft Excel MATCH() Function
0:07:30
Microsoft Excel INDEX() and MATCH() Function Combined
0:03:41
Microsoft Excel INDEX() and MATCH() Function Combined Continued
0:09:13
Creating a Dynamic HLOOKUP() with the MATCH() Function
0:03:41
Using Excel's LEFT(), RIGHT() and MID() Functions
0:03:41
Using Excel's LEN() Function
0:06:54
Using Excel's SEARCH() Function
0:06:54
Using Excel's CONCATENATE() Function
0:06:54
Tracing Precedents in Excel Formulas
0:03:41
Tracing Dependents in Excel Formulas
0:07:30
Working with the Watch Window
0:07:30
Showing Formulas
0:03:41
Protecting Specific Cells in a Worksheet
0:07:30
Protecting the Structure of a Workbook
0:07:30
Adding a Workbook Password
0:06:12
Working with Excel's Goal Seek Tool
0:07:30
Working with Excel's Solver Tool
0:06:54
Building Effective Data Tables in Excel
0:06:12
Creating Scenarios in Excel
0:03:41
Understanding Excel Macros
0:06:12
Activating the Developer Tab in Excel
0:06:54
Creating a Macro with the Macro Recorder
0:07:30
Editing a Macro with VBA
0:07:30
Creating Buttons to Run Macros
0:06:12
Excel 103 - Practice What You've Learned (DOWNLOAD)
0:07:30
Congratulations on Completing the Microsoft Excel 103
0:06:12
Welcome to the Course
Preview 0:06:54
Understanding the Why and How Behind Excel Macros
0:07:30
Introduction to Project #1: Inserting and Formatting Text
Preview 0:06:54
Project #1: Section Exercise Files (DOWNLOAD)
0:03:41
Activating the Excel Developer Tab
0:07:30
Project #1: Start Recording!
0:03:41
Running a Microsoft Excel Macro
0:03:41
Project #1: Running an Excel Macro with a Button
0:06:12
BONUS - Create a Custom Button Using Excel Shapes
0:09:13
Adding the Excel Macro to the Quick Access Toolbar
0:07:30
Project #1: Editing the VBA Recorded by the Macro Recorder
0:06:54
Save a Workbook with a Macro/VBA Code
0:07:30
Practical Uses of Excel Macros
0:09:13
Intro to Excel VBA Concepts
0:07:30
Intro to Excel VBA Object Oriented Programming Concepts
0:03:41
Intro to Excel VBA Exercise Files (DOWNLOAD)
0:07:30
The Visual Basic Editor (VBE)
0:06:12
Introduction to the Excel VBA Immediate Window
0:03:41
Excel VBA Modules
0:06:54
Creating an Excel VBA Procedure
0:09:13
Adding Code to a VBA Procedure
0:06:12
Including Excel VBA Comments
0:06:12
Excel VBA MSGBOX Function
0:06:54
Excel VBA MsgBox Microsoft Help Information
0:03:41
Understanding and Working with Excel VBA Variables
0:07:30
REMINDER: Saving an Excel Workbook with VBA Code
0:06:12
Working with Excel VBA Logic Exercise Files (DOWNLOAD)
0:09:13
Building Logic with an Excel VBA IF Statement
0:03:41
Including an Else Statement in the VBA IF Statement
0:06:54
Expanding the IF Logic with Multiple ElseIf Statements
0:03:41
Working with Excel VBA Select Case Statements
0:07:30
Working with an Excel VBA Do While Loop
0:06:12
Excel VBA Do While Loop Dynamic Condition
0:03:41
Working with an Excel VBA For Each Loop
0:07:30
Working with an Excel VBA For Next Loop
0:06:54
Introduction to Project #2: Interacting with the User
0:06:12
Beyond the Basics Sort Project Exercise Files (DOWNLOAD)
0:06:12
Project #2: Introduction to the Excel VBA Range.Sort Method
0:03:41
Creating the Excel VBA Sort Procedures for this Project
0:07:30
Project #2: Prompting the User for Information
0:06:12
Continue Excel VBA InputBox
0:06:54
Project #2: Building Logic into Your Macros
0:03:41
Project #2: Alerting the User of Errors
0:07:30
Using Excel VBA Error Control Statements
0:07:30
Create a Button to Run the Sort Procedure and Save
0:03:41
Introduction to Project #3: Cleaning Up and Formatting Data
0:06:12
Project #3: Exercise Files (DOWNLOAD)
0:03:41
Project #3: Preparing to the Use the Macro Recorder
0:09:13
Project #3: Inserting the Headers
0:09:13
Project #3: Formatting the Headers
0:06:12
Project #3: Testing the Macros
0:03:41
Project #3: Using an Excel VBA Loop to Loop through all Worksheets
0:03:41
Project #3: Testing the Excel VBA Loop
0:03:41
Project #3: Adding Logic to an Excel VBA Loop
0:06:12
Introduction to Project #4: Automate Excel Formulas
0:06:54
Project #4: Automate Sum Function Exercise Files (DOWNLOAD)
0:07:30
Project #4: Start the Procedure to Automate the SUM Function
0:07:30
Working with the Range Address Property
0:06:12
Creating the SUM Function in VBA
0:09:13
Run the Excel VBA Procedure to SUM Records
0:07:30
Project #4: Loop the SUM() Function Over Multiple Worksheets
0:06:12
Introduction to Project #5: Creating the Final Report
0:07:30
Project #5: Final Report Loop Exercise Files (DOWNLOAD)
0:03:41
Project #5: Creating the Final Report Excel VBA Loop
0:06:54
Project #5 - Copying Content with Excel VBA
0:06:54
Project #5 - Pasting Content with Excel VBA
0:07:30
Cleaning Up the Final Report VBA Loop Code
0:06:12
Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet
0:06:12
Project #5 - Running the Final Report Procedure
0:07:30
Introduction to Project #6: Working with Excel VBA User Forms
0:06:54
Project #6: Working with Excel VBA User Forms Exercise Files (DOWNLOAD)
0:03:41
Project #6: Creating an Excel User Form
0:06:12
Project #6: Working with Form and Control Properties
0:06:54
Project #6: Formatting Excel VBA User Form Controls
0:06:54
Project #6: Adding VBA Code to the Initialize Event
0:07:30
Project #6: Using the AddItem Method within a Loop
0:06:12
Project #6: Adding VBA Code to the ComboBox Change Event
0:06:54
Project #6: Adding VBA Code to the Add Worksheet Button
0:03:41
Project #6: Change Worksheet Name
0:03:41
Project #6: Catch Errors When Adding a Worksheet
0:06:12
Add Sheet Procedure Catch Errors
0:06:54
Project #6: Additional Conditions on the Loop
0:06:12
Project #6: Running the Final Report Procedure
0:03:41
Project #6: Showing the VBA User Form On Workbook Open
0:07:30
Project #7: Opening a Text File for Import
Preview 0:06:54
Project #7: Opening a Text File for Import
0:03:41
Project #7: Get Data from Text File
0:06:12
Project #7: Importing Multiple Text Files with the GetOpenFilename Method
0:06:12
Project #7: Creating a Loop to Read Each File
0:09:13
Project #7: Adding a New Sheet for Imported Data
0:06:12
Project #7: Clear the Clipboard
0:06:12
Project #7: Working with the ScreenUpdating Property
0:07:30
Project #7: Creating Reusable Code with a VBA Function
0:09:13
Congratulations! You're an Excel Macro/VBA Master
0:09:13

About tutor

Ezequiel Heaney
3.33 (3)

Ezequiel Heaney

Courses 1

In 2013, I started teaching Accounts, Politics, and History in Mauritania. I make every effort to create a welcoming and comfortable environment in which learners want to learn and play with the language. I adopt communicative and task-based teaching strategies to assist students in the learning process, and I link course objectives with my students' needs and expectations. I also love to speak Bambara, Chuvash, Hebrew, Volapük.

View profile

Ratings & reviews

5.00

Overall ratings
  • 5
    0%
  • 4
    0%
  • 3
    0%
  • 2
    0%
  • 1
    0%
The website uses cookies to provide the best user experience while browsing safely. You can read more about cookies in the Privacy Policy. Cookies Policy Accept cookies Choose cookies