Section 1 : Microsoft Excel 101 Course Introduction

Lecture 1 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 2 About Proctor Testing
Lecture 3 About Certification

Section 2 : Microsoft Excel Fundamentals

Lecture 1 Launching Excel copy 00:01:41 Duration
Lecture 2 Microsoft Excel Startup Screen 00:03:16 Duration
Lecture 3 Introduction to the Excel Interface. 00:07:10 Duration
Lecture 4 Customizing the Excel Quick Access Toolbar
Lecture 5 More on the Excel Interface 00:03:35 Duration
Lecture 6 Understanding the Structure of an Excel Workbook 00:03:58 Duration
Lecture 7 Saving an Excel Document 00:04:01 Duration
Lecture 8 Opening an Existing Excel Document 00:01:36 Duration
Lecture 9 Common Excel Shortcut Keys 00:01:10 Duration

Section 3 : Entering and Editing Text and Formulas

Lecture 1 Entering Text to Create Spreadsheet Titles 00:08:15 Duration
Lecture 2 Working with Numeric Data in Excel 00:08:27 Duration
Lecture 3 Entering Date Values in Excel 00:08:37 Duration
Lecture 4 Working with Cell References 00:06:00 Duration
Lecture 5 Creating Basic Formulas in Excel 00:08:34 Duration
Lecture 6 Relative Versus Absolute Cell References in Formu 00:12:33 Duration
Lecture 7 Understanding the Order of Operation (DOWNLOAD EXE 00:10:36 Duration

Section 4 : Working with Basic Excel Functions

Lecture 1 The structure of an Excel Function 00:08:43 Duration
Lecture 2 Working with the SUM() Function 00:07:00 Duration
Lecture 3 Working with the MIN() and MAX() Functions 00:06:19 Duration
Lecture 4 Working with the AVERAGE() Function 00:02:52 Duration
Lecture 5 Working with the AVERAGE() Function 00:02:51 Duration
Lecture 6 Adjacent Cells Error in Excel Calculations 00:03:40 Duration
Lecture 7 Using the AutoSum Command.mp426. Using the AutoS 00:06:48 Duration
Lecture 8 Excel's AutoSum Shortcut Key 00:02:13 Duration
Lecture 9 Using the AutoFill Command to Copy Formulas 00:04:24 Duration

Section 5 : Modifying an Excel Worksheet

Lecture 1 Moving and Copying Data in an Excel Worksheet 00:06:33 Duration
Lecture 2 Inserting and Deleting Rows and Columns 00:07:13 Duration
Lecture 3 Changing the Width and Height of Cells 00:05:18 Duration
Lecture 4 Hiding and Unhiding Excel Rows and Columns 00:05:08 Duration
Lecture 5 Renaming an Excel Worksheet 00:02:52 Duration
Lecture 6 Deleting an Excel Worksheet 00:04:33 Duration
Lecture 7 Moving and Copying an Excel Worksheet 00:05:12 Duration

Section 6 : Formatting Data in an Excel Worksheet

Lecture 1 Working with Font Formatting Commands 00:03:48 Duration
Lecture 2 Changing the Background Color of a Cell 00:02:44 Duration
Lecture 3 Adding Borders to Cells 00:03:28 Duration
Lecture 4 Formatting Data as Currency Values 00:05:14 Duration
Lecture 5 Formatting Percentages 00:02:10 Duration
Lecture 6 Using Excel's Format Painter 00:02:42 Duration
Lecture 7 Creating Styles to Format Data 00:08:07 Duration
Lecture 8 Merging and Centering Cells 00:02:43 Duration
Lecture 9 Using Conditional Formatting 00:04:28 Duration

Section 7 : Inserting Images and Shapes into an Excel Worksheet

Lecture 1 Inserting Images 00:04:03 Duration
Lecture 2 Inserting Excel Shapes 00:03:50 Duration
Lecture 3 Formatting Excel Shapes 00:04:34 Duration
Lecture 4 Working with Excel SmartArt 00:06:41 Duration

Section 8 : Creating Basic Charts in Excel

Lecture 1 Creating an Excel Column Chart 00:04:47 Duration
Lecture 2 Working with the Excel Chart Ribbon 00:05:18 Duration
Lecture 3 Adding and Modifying Data on an Excel Chart 00:03:03 Duration
Lecture 4 Formatting an Excel Chart 00:04:35 Duration
Lecture 5 Moving a Chart to another Worksheet 00:02:25 Duration
Lecture 6 Working with Excel Pie Charts 00:05:00 Duration

Section 9 : Printing an Excel Worksheet

Lecture 1 Viewing your Document in Print Preview 00:02:06 Duration
Lecture 2 Changing the Margins, Scaling and Orientation 00:08:01 Duration
Lecture 3 Working with Page Layout View 00:03:42 Duration
Lecture 4 Adding Header and Footer Content 00:04:30 Duration
Lecture 5 Printing a Specific Range of Cells 00:02:52 Duration

Section 10 : Working with Excel Templates

Lecture 1 Intro to Excel Templates 00:01:27 Duration
Lecture 2 Opening an Existing Template 00:05:28 Duration
Lecture 3 Creating a Custom Template 00:04:31 Duration

Section 11 : Congratulations! You've Built a Solid Microsoft Excel Founda

Lecture 1 Congratulations 00:01:55 Duration

Section 12 : Microsoft Excel 102 Course Introduction

Lecture 1 Excel 102 Course Exercise Files -- DOWNLOAD 00:01:16 Duration

Section 13 : Working with an Excel List

Lecture 1 Understanding Excel List Structure 00:05:33 Duration
Lecture 2 Sorting a List Using Single Level Sort 00:03:41 Duration
Lecture 3 Sorting a List Using Multi-Level Sorts 00:03:41 Duration
Lecture 4 Using Custom Sorts in an Excel List 00:04:28 Duration
Lecture 5 Filter an Excel List Using the AutoFilter Tool 00:04:50 Duration
Lecture 6 Creating Subtotals in a List 00:06:31 Duration
Lecture 7 Format a List as a Table 00:07:25 Duration
Lecture 8 Using Conditional Formatting to Find Duplicates 00:03:47 Duration
Lecture 9 Removing Duplicates 00:04:05 Duration

Section 14 : Excel List Functions

Lecture 1 Introduction to Excels Function DSUM 00:05:30 Duration
Lecture 2 Excel DSUM Function Single Criteria Continued 00:04:47 Duration
Lecture 3 Excel DSUM Function with OR Criteria 00:02:33 Duration
Lecture 4 Excel DSUM Function with AND Criteria 00:05:34 Duration
Lecture 5 Excel Function DAVERAGE 00:04:55 Duration
Lecture 6 Excel Function DCOUNT 00:06:29 Duration
Lecture 7 Excel Function SUBTOTAL 00:07:45 Duration

Section 15 : Excel Data Validation

Lecture 1 Understanding the Need for Excel Data Validation 00:05:00 Duration
Lecture 2 Creating an Excel Data Validation List 00:05:24 Duration
Lecture 3 Excel Decimal Data Validation 00:04:15 Duration
Lecture 4 Adding a Custom Excel Data Validation Error 00:04:51 Duration
Lecture 5 Dynamic Formulas by Using Excel Data Validation Te 00:04:43 Duration

Section 16 : Importing and Exporting Data

Lecture 1 Importing Data Into Microsoft Excel 00:01:42 Duration
Lecture 2 Importing Data from Text Files 00:05:28 Duration
Lecture 3 Importing Data from Microsoft Access 00:04:09 Duration
Lecture 4 NEW VERSION -- Import Data From Text Files into 00:07:56 Duration
Lecture 5 NEW VERSION -- Import Data From a Database into 00:06:19 Duration
Lecture 6 . Microsoft Excel Legacy Import Options for New Ex 00:02:00 Duration
Lecture 7 Exporting Data to a Text File 00:06:25 Duration

Section 17 : Excel PivotTables

Lecture 1 Understanding Excel PivotTables 00:03:38 Duration
Lecture 2 Creating an Excel PivotTable 00:06:13 Duration
Lecture 3 Modifying Excel PivotTable Calculations 00:06:32 Duration
Lecture 4 Grouping PivotTable Data 00:04:38 Duration
Lecture 5 Formatting PivotTable Data 00:04:19 Duration
Lecture 6 Drilling Down into PivotTable Data 00:03:26 Duration
Lecture 7 Creating PivotCharts 00:04:35 Duration
Lecture 8 Filtering PivotTable Data 00:03:42 Duration
Lecture 9 Filtering with the Slicer Tool 00:03:39 Duration

Section 18 : Working with Excel's PowerPivot Tools

Lecture 1 Why PowerPivot 00:04:43 Duration
Lecture 2 Activating the Excel PowerPivot AddIn 00:02:21 Duration
Lecture 3 Creating Data Models with PowerPivot 00:06:32 Duration
Lecture 4 Creating PivotTables based on Data Models 00:03:46 Duration
Lecture 5 PowerPivot Calculated Fields. 00:03:45 Duration
Lecture 6 PowerPivot KPIs 00:07:01 Duration

Section 19 : Working with Large Sets of Excel Data

Lecture 1 Using the Freeze Panes Tool 00:03:33 Duration
Lecture 2 Grouping Data (Columns andor Rows) 00:04:12 Duration
Lecture 3 Print Options for Large Sets of Data 2 00:07:27 Duration
Lecture 4 Linking Worksheets (3D Formulas) 00:04:03 Duration
Lecture 5 Consolidating Data from Multiple Worksheets 00:05:25 Duration

Section 20 : Congratulations! You're an Intermediate Excel User

Lecture 1 Congratulations 00:01:33 Duration

Section 21 : Microsoft Excel 103 Course Introduction

Lecture 1 Excel 103 Course Exercise Files -- DOWNLOAD 00:01:23 Duration

Section 22 : Working with Excel's Conditional Functions

Lecture 1 Working with Excel Name Ranges 00:04:23 Duration
Lecture 2 Advantages and Disadvantages of Excel Name Ranges 00:05:34 Duration
Lecture 3 Editing an Excel Name Range 00:02:33 Duration
Lecture 4 Using Excel's IF() Function 00:05:10 Duration
Lecture 5 Excel's IF() Function with a Name Range 00:05:23 Duration
Lecture 6 Nesting Functions with Excel 00:08:58 Duration
Lecture 7 Nesting Excels AND() Function within the IF
Lecture 8 Using Excel's COUNTIF() Function 00:02:30 Duration
Lecture 9 Using Excel's SUMIF() Function 00:06:44 Duration
Lecture 10 Using Excel's IFERROR() Function 00:05:09 Duration

Section 23 : Working with Excel's Lookup Functions

Lecture 1 Microsoft Excel VLOOKUP() Function 00:09:36 Duration
Lecture 2 Microsoft Excel HLOOKUP() Function 00:05:26 Duration
Lecture 3 Microsoft Excel INDEX() Function 00:04:40 Duration
Lecture 4 Microsoft Excel MATCH() Function 00:09:26 Duration
Lecture 5 Microsoft Excel INDEX() and MATCH() Function Comb 00:06:41 Duration
Lecture 6 Microsoft Excel INDEX() and MATCH() Function Combi 00:08:44 Duration
Lecture 7 Creating a Dynamic HLOOKUP() with the MATCH() Func 00:07:16 Duration

Section 24 : Working with Excel's Text Based Functions

Lecture 1 Using Excel's LEFT(), RIGHT() and MID() Functions. 00:06:13 Duration
Lecture 2 Using Excel's LEN() Function 00:06:09 Duration
Lecture 3 Using Excel's SEARCH() Function 00:12:15 Duration
Lecture 4 Using Excel's CONCATENATE() Function 00:03:04 Duration

Section 25 : Auditing an Excel Worksheet

Lecture 1 Tracing Precedents in Excel Formulas 00:03:56 Duration
Lecture 2 Tracing Dependents in Excel Formulas 00:02:47 Duration
Lecture 3 Working with the Watch Window 00:04:13 Duration
Lecture 4 Showing Formulas 00:02:41 Duration

Section 26 : Protecting Excel Worksheets and Workbooks

Lecture 1 Protecting Specific Cells in a Worksheet 00:08:00 Duration
Lecture 2 Protecting the Structure of a Workbook 00:04:07 Duration
Lecture 3 Adding a Workbook Password 00:03:10 Duration

Section 27 : Mastering Excel's What If Tools

Lecture 1 Working with Excel's Goal Seek Tool 00:07:36 Duration
Lecture 2 Working with Excel's Solver Tool
Lecture 3 Building Effective Data Tables in Excel 00:06:14 Duration
Lecture 4 Creating Scenarios in Excel 00:07:46 Duration

Section 28 : Automating Repetitive Tasks in Excel with Macros

Lecture 1 Understanding Excel Macros 00:03:45 Duration
Lecture 2 Activating the Developer Tab in Excel 00:01:37 Duration
Lecture 3 Creating a Macro with the Macro Recorder 00:07:33 Duration
Lecture 4 Editing a Macro with VBA 00:05:11 Duration
Lecture 5 Creating Buttons to Run Macros 00:03:06 Duration

Section 29 : Congratulations_

Lecture 1 Congratulations on Completing the Microsoft Excel

Section 30 : Microsoft Excel Macros and VBA Course Introduction

Lecture 1 Welcome to the Course. 00:04:44 Duration
Lecture 2 Understanding the Why and How Behind Excel Macros 00:05:15 Duration
Lecture 3 Course Exercise Files - Download these First

Section 31 : Project #1 Using Excel's Macro Recorder Tool

Lecture 1 Introduction to Project #1 Inserting and Formattin 00:02:01 Duration
Lecture 2 Project #1 Start Recording 00:07:41 Duration
Lecture 3 Running A Macro 00:02:43 Duration
Lecture 4 Project #1 Running a Macro with a Button 00:03:36 Duration
Lecture 5 Project #1 Oops! I Need to Edit My Macro 00:04:27 Duration
Lecture 6 Practical Uses of Excel Macros 00:02:10 Duration

Section 32 : Excel VBA Concepts

Lecture 1 Excel VBA Concepts 00:03:32 Duration
Lecture 2 The Visual Basic Editor (VBE) 00:03:26 Duration
Lecture 3 Excel VBA Modules 00:02:01 Duration
Lecture 4 Creating an Excel VBA Procedure 00:08:18 Duration
Lecture 5 Adding Code to a VBA Procedure 00:04:05 Duration
Lecture 6 Understanding Excel VBA Variables 00:07:02 Duration
Lecture 7 Building Logic with an IF Statement 00:06:19 Duration
Lecture 8 Working with Excel VBA Loops to Re of Code 00:09:42 Duration

Section 33 : Project #2 Moving Beyond the Basics and into VBA

Lecture 1 Introduction to Project #2 Interacting with the U 00:02:57 Duration
Lecture 2 Project #2 Breaking Down the VBA Code 00:03:35 Duration
Lecture 3 Project #2 Prompting the User for Information. 00:06:54 Duration
Lecture 4 Continue Excel VBA InputBox 00:07:21 Duration
Lecture 5 Project #2 Building Logic into Your Macros. 00:04:32 Duration
Lecture 6 Project #2 Alerting the User of Errors 00:10:30 Duration
Lecture 7 Other Practical Uses of Message and Input Boxes 00:03:11 Duration

Section 34 : . Project #3 Preparing and Cleaning Up Data with a Little VB

Lecture 1 Introduction to Project #3 Cleaning Up and Format 00:03:06 Duration
Lecture 2 Project #3 Preparing to the Use the Macro Recorder 00:02:55 Duration
Lecture 3 Project #3 Inserting the Headers 00:03:27 Duration
Lecture 4 Project #3 Formatting the Headers 00:02:21 Duration
Lecture 5 Project #3 Putting it all Together with a Little 00:10:47 Duration
Lecture 6 Running the Loop 00:02:54 Duration

Section 35 : Project #4 Using VBA to Automate Excel Formulas

Lecture 1 Introduction to Project #4 Automate Excel Formulas 00:02:10 Duration
Lecture 2 Project #4 Automate the SUM() Function through Co 00:08:01 Duration
Lecture 3 Continue Automate SUM Function 00:06:28 Duration
Lecture 4 Test the SUM Function 00:03:45 Duration
Lecture 5 Project #4 Loop the SUM() Function Over Multiple W 00:02:59 Duration

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

Lecture 1 Introduction to Project #5 Creating the Final Rep 00:02:59 Duration
Lecture 2 Project #5 Creating the Final Report Loop 00:07:45 Duration
Lecture 3 Project #5 - Copying and Pasting Data with VBA.
Lecture 4 Project #5 - Running the Final Report Procedure 00:03:15 Duration

Section 37 : . Project #6 Working with Excel VBA User Forms

Lecture 1 Introduction to Project #6 Working with Excel VBA 00:03:01 Duration
Lecture 2 Project #6 Creating an Excel User Form 00:05:05 Duration
Lecture 3 Project #6 Adding Controls to the Form 00:04:01 Duration
Lecture 4 Project #6 Adding VBA Code to the Initialize Even 00:08:49 Duration
Lecture 5 Project #6 Adding VBA Code to the ComboBox 00:04:32 Duration
Lecture 6 Project #6 Adding VBA Code to the Add Worksheet B 00:03:28 Duration
Lecture 7 Change Worksheet Name 00:03:59 Duration
Lecture 8 Project #6 Adding VBA Code to the Create Report Bu 00:08:53 Duration
Lecture 9 Project #6 Showing the Form. 00:04:02 Duration

Section 38 : Project #7 Importing Data from Text Files

Lecture 1 Project #7 Opening a Text File for Import 00:02:37 Duration
Lecture 2 Project #7 Opening a Text File for Import 00:06:41 Duration
Lecture 3 Project #7 Get Data from Text File 00:05:24 Duration
Lecture 4 Project #7 Importing Multiple Text Files with the 00:09:27 Duration
Lecture 5 Project #7 Creating a Loop to Read Each File 00:07:21 Duration
Lecture 6 Project #7 Adding a New Sheet for Imported Data 00:02:30 Duration
Lecture 7 Project #7 Clear the Clipboard 00:03:32 Duration
Lecture 8 Project #7 Working with the ScreenUpdating Proper 00:03:11 Duration
Lecture 9 Project #7 Creating Reusable Code with a VBA 00:07:38 Duration

Section 39 : Course Wrap Up

Lecture 1 Congratulations! You're an Excel MacroVBA Master. 00:00:50 Duration