IndiaStudent | indiastudent.com

Section 1

Microsoft Excel 101 Course Introduction

Time 20m

Lectures 3

See all

Ask Questions

Preview 0:06:12

Course Exercise Files

Preview 0:06:54

Certificate of Completion

Preview 0:06:54

Section 2

Microsoft Excel Fundamentals

Time 1h 02m

Lectures 10

See all

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

Entering and Editing Text and Formulas

Time 50m

Lectures 8

See all

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

Section 4

Working with Basic Excel Functions

Time 1h 11m

Lectures 10

See all

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

Section 5

Modifying an Excel Worksheet

Time 55m

Lectures 8

See all

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

Section 6

Formatting Data in an Excel Worksheet

Time 1h 21m

Lectures 12

See all

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

Section 7

Inserting Images and Shapes into an Excel Worksheet

Time 24m

Lectures 4

See all

Inserting Images

0:06:54

Inserting Excel Shapes

0:03:41

Formatting Excel Shapes

0:07:30

Working with Excel SmartArt

0:06:12

Section 8

Creating Basic Charts in Excel

Time 40m

Lectures 7

See all

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

Section 9

Printing an Excel Worksheet

Time 51m

Lectures 7

See all

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

Section 10

Working with Excel Templates

Time 27m

Lectures 4

See all

Section 11

Excel 101 - Practice What You've Learned (DOWNLOAD)

Time 06m

Lectures 1

See all

Section 12

Congratulations! You've Built a Solid Microsoft Excel Foundation

Time 06m

Lectures 1

See all

Section 13

Microsoft Excel 102 Course Introduction

Time 06m

Lectures 1

See all

Section 14

Working with an Excel List

Time 1h 05m

Lectures 10

See all

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

Section 15

Excel List Functions

Time 47m

Lectures 8

See all

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

Section 16

Excel Data Validation

Time 29m

Lectures 6

See all

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

Section 17

Importing and Exporting Data

Time 55m

Lectures 8

See all

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

Section 18

Excel PivotTables

Time 1h 16m

Lectures 10

See all

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

Section 19

Working with Excel's PowerPivot Tools

Time 46m

Lectures 7

See all

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

Section 20

Working with Large Sets of Excel Data

Time 30m

Lectures 5

See all

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

Section 21

Excel 102 Additional Practice Exercises

Time 03m

Lectures 1

See all

Section 22

Congratulations! You're an Intermediate Excel User

Time 07m

Lectures 1

See all

Section 23

Microsoft Excel 103 Course Introduction

Time 03m

Lectures 1

See all

Section 24

Working with Excel's Conditional Functions

Time 58m

Lectures 10

See all

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

Section 25

Working with Excel's Lookup Functions

Time 37m

Lectures 7

See all

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

Section 26

Working with Excel's Text Based Functions

Time 24m

Lectures 4

See all

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

Section 27

Auditing an Excel Worksheet

Time 22m

Lectures 4

See all

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

Section 28

Protecting Excel Worksheets and Workbooks

Time 21m

Lectures 3

See all

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

Section 29

Mastering Excel's "What If?" Tools

Time 24m

Lectures 4

See all

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

Section 30

Automating Repetitive Tasks in Excel with Macros

Time 34m

Lectures 5

See all

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

Section 31

Excel 103 Additional Practice Exercises

Time 07m

Lectures 1

See all

Section 32

Congratulations!

Time 06m

Lectures 1

See all

Section 33

Microsoft Excel Macros and VBA Course Introduction

Time 14m

Lectures 2

See all

Section 34

Project #1: Using Excel's Macro Recorder Tool

Time 1h 11m

Lectures 11

See all

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

Section 35

Excel VBA Concepts

Time 1h 21m

Lectures 13

See all

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

Section 36

Working with Excel VBA Logic Statements

Time 55m

Lectures 9

See all

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

Section 37

Project #2: Moving Beyond the Basics and into VBA

Time 59m

Lectures 10

See all

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

Section 38

Project #3: Preparing and Cleaning Up Data with Excel VBA

Time 51m

Lectures 9

See all

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

Section 39

Project #4: Using VBA to Automate Excel Formulas

Time 51m

Lectures 7

See all

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

Section 40

Project #5: Bringing it All Together and a Weekly Report

Time 52m

Lectures 8

See all

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

Section 41

Project #6: Working with Excel VBA User Forms

Time 1h 29m

Lectures 15

See all

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

Section 42

Project #7: Importing Data from Text Files

Time 1h 01m

Lectures 9

See all

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

Section 43

Course Wrap Up

Time 09m

Lectures 1

See all

Microsoft Excel - Excel from Beginner to Advanced

Excel with this A-Z Microsoft Excel Course

This course includes:

Share this course

Overview

What will students learn in your course?

What are the requirements or prerequisites for taking your course?

Who is the course for?

Description

Course tags

Course content

Microsoft Excel 101 Course Introduction

Microsoft Excel Fundamentals

Entering and Editing Text and Formulas

Working with Basic Excel Functions

Modifying an Excel Worksheet

Formatting Data in an Excel Worksheet

Inserting Images and Shapes into an Excel Worksheet

Creating Basic Charts in Excel

Printing an Excel Worksheet

Working with Excel Templates

Excel 101 - Practice What You've Learned (DOWNLOAD)

Congratulations! You've Built a Solid Microsoft Excel Foundation

Microsoft Excel 102 Course Introduction

Working with an Excel List

Excel List Functions

Excel Data Validation

Importing and Exporting Data

Excel PivotTables

Working with Excel's PowerPivot Tools

Working with Large Sets of Excel Data

Excel 102 Additional Practice Exercises

Congratulations! You're an Intermediate Excel User

Microsoft Excel 103 Course Introduction

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

About tutor

Ezequiel Heaney

Biography

Ratings & reviews