Logo
VideoLevel 1

Vòng 1

Course Introduction

1.Ask Questions

0%

2.Course Exercise Files

0%

3.Certificate of Completion

0%

Microsoft Excel Fundamentals

1.Launching Excel

0%

2.Microsoft Excel Startup Screen

0%

3.Introduction to the Excel Interface

0%

4.Customizing the Excel Quick Access Toolbar

0%

5.More on the Excel Interface

0%

6.Understanding the Structure of an Excel Workbook

0%

7.Saving an Excel Document

0%

8.Opening an Existing Excel Document

0%

9.Common Excel Shortcut Keys

0%

Entering and Editing Text and Formulas

1.Entering Text to Create Spreadsheet Titles

0%

2.Working with Numeric Data in Excel

0%

3.Entering Date Values in Excel

0%

4.Working with Cell References

0%

5.Creating Basic Formulas in Excel

0%

6.Relative Versus Absolute Cell References in Formulas

0%

7.Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)

0%

Working with Basic Excel Functions

1.The structure of an Excel Function

0%

2.Working with the SUM() Function

0%

3.Working with the MIN() and MAX() Functions

0%

4.Working with the AVERAGE() Function

0%

5.Working with the COUNT() Function

0%

6.Adjacent Cells Error in Excel Calculations

0%

7.Using the AutoSum Command

0%

8.Excel's AutoSum Shortcut Key

0%

9.Using the AutoFill Command to Copy Formulas

0%

Modifying an Excel Worksheet

1.Moving and Copying Data in an Excel Worksheet

0%

2.Inserting and Deleting Rows and Columns

0%

3.Changing the Width and Height of Cells

0%

4.Hiding and Unhiding Excel Rows and Columns

0%

5.Renaming an Excel Worksheet

0%

6.Deleting an Excel Worksheet

0%

7.Moving and Copying an Excel Worksheet

0%

Formatting Data in an Excel Worksheet

1.Working with Font Formatting Commands

0%

2.Changing the Background Color of a Cell

0%

3.Adding Borders to Cells

0%

4.Formatting Data as Currency Values

0%

5.Formatting Percentages

0%

6.Using Excel's Format Painter

0%

7.Creating Styles to Format Data

0%

8.Merging and Centering Cells

0%

9.Using Conditional Formatting

0%

Inserting Images and Shapes into an Excel Worksheet

1.Inserting Images

0%

2.Inserting Excel Shapes

0%

3.Formatting Excel Shapes

0%

4.Working with Excel SmartArt

0%

Creating Basic Charts in Excel

1.Creating an Excel Column Chart

0%

2.Working with the Excel Chart Ribbon

0%

3.Adding and Modifying Data on an Excel Chart

0%

4.Formatting an Excel Chart

0%

5.Moving a Chart to another Worksheet

0%

6.Working with Excel Pie Charts

0%

Printing an Excel Worksheet

1.Viewing your Document in Print Preview

0%

2.Changing the Margins, Scaling and Orientation

0%

3.Working with Page Layout View

0%

4.Adding Header and Footer Content

0%

5.Printing a Specific Range of Cells

0%

Working with Excel Templates

1.Intro to Excel Templates

0%

2.Opening an Existing Template

0%

3.Creating a Custom Template

0%

Congratulations! You've Built a Solid Microsoft Excel Foundation

1.Congratulations!

0%

Microsoft Excel 102 Course Introduction

1.Excel 102 Course Exercise Files -- DOWNLOAD

0%

13. Working with an Excel List

1.Understanding Excel List Structure

0%

2.Sorting a List Using Single Level Sort

0%

3.Sorting a List Using Multi-Level Sorts

0%

4.Using Custom Sorts in an Excel List

0%

5.Filter an Excel List Using the AutoFilter Tool

0%

6.Creating Subtotals in a List

0%

7.Format a List as a Table

0%

8.Using Conditional Formatting to Find Duplicates

0%

9.Removing Duplicates

0%

14. Excel List Functions

1.Introduction to Excels Function DSUM()

0%

2.Excel DSUM Function Single Criteria Continued

0%

3.Excel DSUM Function with OR Criteria

0%

4.Excel DSUM Function with AND Criteria

0%

5.Excel Function DAVERAGE()

0%

6.Excel Function DCOUNT()

0%

7.Excel Function SUBTOTAL()

0%

15. Excel Data Validation

1.Understanding the Need for Excel Data Validation

0%

2.Creating an Excel Data Validation List

0%

3.Excel Decimal Data Validation

0%

4.Adding a Custom Excel Data Validation Error

0%

5.Dynamic Formulas by Using Excel Data Validation Techniques

0%

16. Importing and Exporting Data

1.Importing Data Into Microsoft Excel

0%

2.Importing Data from Text Files

0%

3.Importing Data from Microsoft Access

0%

4.NEW VERSION -- Import Data From Text Files into Excel

0%

5.NEW VERSION -- Import Data From a Database into Excel

0%

6.Microsoft Excel Legacy Import Options for New Excel Versions

0%

7.Exporting Data to a Text File

0%

17. Excel PivotTables

1.Understanding Excel PivotTables

0%

2.Why PowerPivot

0%

3.Creating an Excel PivotTable

0%

4.Activating the Excel PowerPivot AddIn

0%

5.Modifying Excel PivotTable Calculations

0%

6.Creating Data Models with PowerPivot

0%

7.Grouping PivotTable Data

0%

8.Creating PivotTables based on Data Models

0%

9.Formatting PivotTable Data

0%

10.PowerPivot Calculated Fields

0%

11.Drilling Down into PivotTable Data

0%

12.PowerPivot KPIs

0%

13.Creating PivotCharts

0%

14.Filtering PivotTable Data

0%

15.Filtering with the Slicer Tool

0%

18. Working with Excel's PowerPivot Tools

19. Working with Large Sets of Excel Data

1.Using the Freeze Panes Tool

0%

2.Grouping Data (Columns andor Rows)

0%

3.Print Options for Large Sets of Data

0%

4.Linking Worksheets (3D Formulas)

0%

5.Consolidating Data from Multiple Worksheets

0%

20. Congratulations! You're an Intermediate Excel User

1.Congratulations!

0%

21. Microsoft Excel 103 Course Introduction

1.Excel 103 Course Exercise Files -- DOWNLOAD

0%

22. Working with Excel's Conditional Functions

1.Working with Excel Name Ranges

0%

2. Using Excel's IFERROR() Function

0%

3.Advantages and Disadvantages of Excel Name Ranges

0%

4.Editing an Excel Name Range

0%

5.Using Excel's IF() Function

0%

6.Excel's IF() Function with a Name Range

0%

7.Nesting Functions with Excel

0%

8.Nesting Excels AND() Function within the IF() Function

0%

9.Using Excel's COUNTIF() Function

0%

10.Using Excel's SUMIF() Function

0%

23. Working with Excel's Lookup Functions

1.Microsoft Excel VLOOKUP() Function

0%

2.Microsoft Excel HLOOKUP() Function

0%

3.Microsoft Excel INDEX() Function

0%

4.Microsoft Excel MATCH() Function

0%

5.Microsoft Excel INDEX() and MATCH() Function Combined

0%

6.Microsoft Excel INDEX() and MATCH() Function Combined Continued

0%

7.Creating a Dynamic HLOOKUP() with the MATCH() Function

0%

24. Working with Excel's Text Based Functions

1.sing Excel's LEFT(), RIGHT() and MID() Functions

0%

2.sing Excel's LEN() Function

0%

3.sing Excel's SEARCH() Function

0%

4.sing Excel's CONCATENATE() Function

0%

25. Auditing an Excel Worksheet

1.Tracing Precendents in Excel Formulas

0%

2.Tracing Dependents in Excel Formulas

0%

3.Working with the Watch Window

0%

4.Showing Formulas

0%

26. Protecting Excel Worksheets and Workbooks

1.Protecting Specific Cells in a Worksheet

0%

2.Protecting the Structure of a Workbook

0%

3.Adding a Workbook Password

0%

27. Mastering Excel's What If Tools

1.Working with Excel's Goal Seek Tool

0%

2.Working with Excel's Solver Tool

0%

3.Building Effective Data Tables in Excel

0%

4.Creating Scenarios in Excel

0%

28. Automating Repetitive Tasks in Excel with Macros

1.Understanding Excel Macros

0%

2.Activating the Developer Tab in Excel

0%

3.Creating a Macro with the Macro Recorder

0%

4.Editing a Macro with VBA

0%

5.Creating Buttons to Run Macros

0%

29. Congratulations!

1.Congratulations on Completing the Microsoft Excel 103

0%

30. Microsoft Excel Macros and VBA Course Introduction

1.Welcome to the Course

0%

2.Understanding the Why and How Behind Excel Macros

0%

31. Project #1 Using Excel's Macro Recorder Tool

1.Introduction to Project #1 Inserting and Formatting Text

0%

2.Project #1 Start Recording!

0%

3.Running A Macro

0%

4.Project #1 Running a Macro with a Button

0%

5.Project #1 Oops! I Need to Edit My Macro

0%

6.Practical Uses of Excel Macros

0%

32. Excel VBA Concepts

1.Excel VBA Concepts

0%

2.The Visual Basic Editor (VBE)

0%

3.Excel VBA Modules

0%

4.Creating an Excel VBA Procedure

0%

5.Adding Code to a VBA Procedure

0%

6.Understanding Excel VBA Variables

0%

7.Building Logic with an IF Statement

0%

8.Working with Excel VBA Loops to Repeat Blocks of Code

0%

33. Project #2 Moving Beyond the Basics and into VBA

1.Introduction to Project #2 Interacting with the User

0%

2.Project #2 Breaking Down the VBA Code

0%

3.Project #2 Prompting the User for Information

0%

4.Continue Excel VBA InputBox

0%

5.Project #2 Building Logic into Your Macros

0%

6.Project #2 Alerting the User of Errors

0%

7.Other Practical Uses of Message and Input Boxes

0%

34. Project #3 Preparing and Cleaning Up Data with a Little VBA

1.Introduction to Project #3 Cleaning Up and Formatting Data

0%

2.Project #3 Preparing to the Use the Macro Recorder

0%

3.Project #3 Inserting the Headers

0%

4.Project #3 Formatting the Headers

0%

5.Project #3 Putting it all Together with a Little VBA

0%

6.Running the Loop

0%

35. Project #4 Using VBA to Automate Excel Formulas

1.Introduction to Project #4 Automate Excel Formulas

0%

2.Project #4 Automate the SUM() Function through Code

0%

3.Continue Automate SUM Function

0%

4.Test the SUM Function

0%

5.Project #4 Loop the SUM() Function Over Multiple Worksheets

0%

36. Project #5 Bringing it All Together and a Weekly Report

1.Introduction to Project #5 Creating the Final Report

0%

2.Project #5 Creating the Final Report Loop

0%

3.Project #5 - Copying and Pasting Data with VBA

0%

4.Project #5 - Running the Final Report Procedure

0%

37. Project #6 Working with Excel VBA User Forms

1.Introduction to Project #6 Working with Excel VBA User Forms

0%

2.Project #6 Creating an Excel User Form

0%

3.Project #6 Adding Controls to the Form

0%

4.Project #6 Adding VBA Code to the Initialize Event

0%

5.Project #6 Adding VBA Code to the ComboBox Change Event

0%

6.Project #6 Adding VBA Code to the Add Worksheet Button

0%

7.Change Worksheet Name

0%

8.Project #6 Adding VBA Code to the Create Report Button

0%

9.Project #6 Showing the Form

0%

38. Project #7 Importing Data from Text Files

1.Project #7 Opening a Text File for Import

0%

2.Project #7 Opening a Text File for Import

0%

3.Project #7 Get Data from Text File

0%

4.Project #7 Importing Multiple Text Files with the GetOpenFilename Method

0%

5.Project #7 Creating a Loop to Read Each File

0%

6.Project #7 Adding a New Sheet for Imported Data

0%

7.Project #7 Clear the Clipboard

0%

8.Project #7 Working with the ScreenUpdating Property

0%

9.Project #7 Creating Reusable Code with a VBA Function

0%

39. Course Wrap Up

1.Congratulations! You're an Excel MacroVBA Master

0%