#### Section 1 : Microsoft Excel 101 Course Introduction

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

#### Section 2 : Microsoft Excel Fundamentals

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

#### Section 3 : Entering and Editing Text and Formulas

 Lecture 13 Entering Text to Create Spreadsheet Titles 8:15 Lecture 14 Working with Numeric Data in Excel 8:27 Lecture 15 Entering Date Values in Excel 8:37 lecture 16 Working with Cell References 6:0 Lecture 17 Creating Basic Formulas in Excel 8:34 Lecture 18 Relative Versus Absolute Cell References in Formu 12:33 Lecture 19 Understanding the Order of Operation (DOWNLOAD EXE 10:36

#### Section 4 : Working with Basic Excel Functions

 Lecture 20 The structure of an Excel Function 8:43 Lecture 21 Working with the SUM() Function 7:0 Lecture 22 Working with the MIN() and MAX() Functions 6:19 Lecture 23 Working with the AVERAGE() Function 2:52 Lecture 24 Working with the AVERAGE() Function 2:51 Lecture 25 Adjacent Cells Error in Excel Calculations 3:40 Lecture 26 Using the AutoSum Command.mp426. Using the AutoS 6:48 Lecture 27 Excel's AutoSum Shortcut Key 2:13 Lecture 28 Using the AutoFill Command to Copy Formulas 4:24

#### Section 5 : Modifying an Excel Worksheet

 Lecture 29 Moving and Copying Data in an Excel Worksheet 6:33 Lecture 30 Inserting and Deleting Rows and Columns 7:13 Lecture 31 Changing the Width and Height of Cells 5:18 Lecture 32 Hiding and Unhiding Excel Rows and Columns 5:8 Lecture 33 Renaming an Excel Worksheet 2:52 Lecture 34 Deleting an Excel Worksheet 4:33 Lecture 35 Moving and Copying an Excel Worksheet 5:12

#### Section 6 : Formatting Data in an Excel Worksheet

 Lecture 36 Working with Font Formatting Commands 3:48 Lecture 37 Changing the Background Color of a Cell 2:44 Lecture 38 Adding Borders to Cells 3:28 Lecture 39 Formatting Data as Currency Values 5:14 Lecture 40 Formatting Percentages 2:10 Lecture 41 Using Excel's Format Painter 2:42 Lecture 42 Creating Styles to Format Data 8:7 Lecture 43 Merging and Centering Cells 2:43 Lecture 44 Using Conditional Formatting 4:28

#### Section 7 : Inserting Images and Shapes into an Excel Worksheet

 Lecture 45 Inserting Images 4:3 Lecture 46 Inserting Excel Shapes 3:50 Lecture 47 Formatting Excel Shapes 4:34 Lecture 48 Working with Excel SmartArt 6:41

#### Section 8 : Creating Basic Charts in Excel

 Lecture 49 Creating an Excel Column Chart 4:47 Lecture 50 Working with the Excel Chart Ribbon 5:18 Lecture 51 Adding and Modifying Data on an Excel Chart 3:3 Lecture 52 Formatting an Excel Chart 4:35 Lecture 53 Moving a Chart to another Worksheet 2:25 Lecture 54 Working with Excel Pie Charts 5:0

#### Section 9 : Printing an Excel Worksheet

 Lecture 55 Viewing your Document in Print Preview 2:6 Lecture 56 Changing the Margins, Scaling and Orientation 8:1 Lecture 57 Working with Page Layout View 3:42 Lecture 58 Adding Header and Footer Content 4:30 Lecture 59 Printing a Specific Range of Cells 2:52

#### Section 10 : Working with Excel Templates

 Lecture 60 Intro to Excel Templates 1:27 Lecture 61 Opening an Existing Template 5:28 Lecture 62 Creating a Custom Template 4:31

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

 Lecture 63 Congratulations 1:55

#### Section 13 : Working with an Excel List

 Lecture 65 Understanding Excel List Structure 5:33 Lecture 66 Sorting a List Using Single Level Sort 3:41 Lecture 67 Sorting a List Using Multi-Level Sorts 3:41 Lecture 68 Using Custom Sorts in an Excel List 4:28 Lecture 69 Filter an Excel List Using the AutoFilter Tool 4:50 Lecture 70 Creating Subtotals in a List 6:31 Lecture 71 Format a List as a Table 7:25 Lecture 72 Using Conditional Formatting to Find Duplicates 3:47 Lecture 73 Removing Duplicates 4:5

#### Section 14 : Excel List Functions

 Lecture 74 Introduction to Excels Function DSUM 5:30 Lecture 75 Excel DSUM Function Single Criteria Continued 4:47 Lecture 76 Excel DSUM Function with OR Criteria 2:33 Lecture 77 Excel DSUM Function with AND Criteria 5:34 Lecture 78 Excel Function DAVERAGE 4:55 Lecture 79 Excel Function DCOUNT 6:29 Lecture 80 Excel Function SUBTOTAL 7:45

#### Section 15 : Excel Data Validation

 Lecture 81 Understanding the Need for Excel Data Validation 5:0 Lecture 82 Creating an Excel Data Validation List 5:24 Lecture 83 Excel Decimal Data Validation 4:15 Lecture 84 Adding a Custom Excel Data Validation Error 4:51 Lecture 85 Dynamic Formulas by Using Excel Data Validation Te 4:43

#### Section 16 : Importing and Exporting Data

 Lecture 86 Importing Data Into Microsoft Excel 1:42 Lecture 87 Importing Data from Text Files 5:28 Lecture 88 Importing Data from Microsoft Access 4:9 Lecture 89 NEW VERSION -- Import Data From Text Files into 7:56 Lecture 90 NEW VERSION -- Import Data From a Database into 6:19 Lecture 91 . Microsoft Excel Legacy Import Options for New Ex 2:0 Lecture 92 Exporting Data to a Text File 6:25

#### Section 17 : Excel PivotTables

 Lecture 93 Understanding Excel PivotTables 3:38 Lecture 94 Creating an Excel PivotTable 6:13 Lecture 95 Modifying Excel PivotTable Calculations 6:32 Lecture 96 Grouping PivotTable Data 4:38 Lecture 97 Formatting PivotTable Data 4:19 Lecture 98 Drilling Down into PivotTable Data 3:26 Lecture 99 Creating PivotCharts 4:35 Lecture 100 Filtering PivotTable Data 3:42 Lecture 101 Filtering with the Slicer Tool 3:39

#### Section 18 : Working with Excel's PowerPivot Tools

 Lecture 102 Why PowerPivot 4:43 Lecture 103 Activating the Excel PowerPivot AddIn 2:21 Lecture 104 Creating Data Models with PowerPivot 6:32 Lecture 105 Creating PivotTables based on Data Models 3:46 Lecture 106 PowerPivot Calculated Fields. 3:45 Lecture 107 PowerPivot KPIs 7:1

#### Section 19 : Working with Large Sets of Excel Data

 Lecture 108 Using the Freeze Panes Tool 3:33 Lecture 109 Grouping Data (Columns andor Rows) 4:12 Lecture 110 Print Options for Large Sets of Data 2 7:27 Lecture 111 Linking Worksheets (3D Formulas) 4:3 Lecture 112 Consolidating Data from Multiple Worksheets 5:25

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

 Lecture 113 Congratulations 1:33

#### Section 22 : Working with Excel's Conditional Functions

 Lecture 115 Working with Excel Name Ranges 4:23 Lecture 116 Advantages and Disadvantages of Excel Name Ranges 5:34 Lecture 117 Editing an Excel Name Range 2:33 Lecture 118 Using Excel's IF() Function 5:10 Lecture 119 Excel's IF() Function with a Name Range 5:23 Lecture 120 Nesting Functions with Excel 8:58 Lecture 121 Nesting Excels AND() Function within the IF Lecture 122 Using Excel's COUNTIF() Function 2:30 Lecture 123 Using Excel's SUMIF() Function 6:44 Lecture 124 Using Excel's IFERROR() Function 5:9

#### Section 23 : Working with Excel's Lookup Functions

 Lecture 125 Microsoft Excel VLOOKUP() Function 9:36 Lecture 126 Microsoft Excel HLOOKUP() Function 5:26 Lecture 127 Microsoft Excel INDEX() Function 4:40 Lecture 128 Microsoft Excel MATCH() Function 9:26 Lecture 129 Microsoft Excel INDEX() and MATCH() Function Comb 6:41 Lecture 130 Microsoft Excel INDEX() and MATCH() Function Combi 8:44 Lecture 131 Creating a Dynamic HLOOKUP() with the MATCH() Func 7:16

#### Section 24 : Working with Excel's Text Based Functions

 Lecture 132 Using Excel's LEFT(), RIGHT() and MID() Functions. 6:13 Lecture 133 Using Excel's LEN() Function 6:9 Lecture 134 Using Excel's SEARCH() Function 12:15 Lecture 135 Using Excel's CONCATENATE() Function 3:4

#### Section 25 : Auditing an Excel Worksheet

 Lecture 136 Tracing Precedents in Excel Formulas 3:56 Lecture 137 Tracing Dependents in Excel Formulas 2:47 Lecture 138 Working with the Watch Window 4:13 Lecture 139 Showing Formulas 2:41

#### Section 26 : Protecting Excel Worksheets and Workbooks

 Lecture 140 Protecting Specific Cells in a Worksheet 8:0 Lecture 141 Protecting the Structure of a Workbook 4:7 Lecture 142 Adding a Workbook Password 3:10

#### Section 27 : Mastering Excel's What If Tools

 Lecture 143 Working with Excel's Goal Seek Tool 7:36 Lecture 144 Working with Excel's Solver Tool Lecture 145 Building Effective Data Tables in Excel 6:14 Lecture 146 Creating Scenarios in Excel 7:46

#### Section 28 : Automating Repetitive Tasks in Excel with Macros

 Lecture 147 Understanding Excel Macros 3:45 Lecture 148 Activating the Developer Tab in Excel 1:37 Lecture 149 Creating a Macro with the Macro Recorder 7:33 Lecture 150 Editing a Macro with VBA 5:11 Lecture 151 Creating Buttons to Run Macros 3:6

#### Section 29 : Congratulations_

 Lecture 152 Congratulations on Completing the Microsoft Excel

#### Section 30 : Microsoft Excel Macros and VBA Course Introduction

 Lecture 153 Welcome to the Course. 4:44 Lecture 154 Understanding the Why and How Behind Excel Macros 5:15 Lecture 155 Course Exercise Files - Download these First Text

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

 Lecture 156 Introduction to Project #1 Inserting and Formattin 2:1 Lecture 157 Project #1 Start Recording 7:41 Lecture 158 Running A Macro 2:43 Lecture 159 Project #1 Running a Macro with a Button 3:36 Lecture 160 Project #1 Oops! I Need to Edit My Macro 4:27 Lecture 161 Practical Uses of Excel Macros 2:10

#### Section 32 : Excel VBA Concepts

 Lecture 162 Excel VBA Concepts 3:32 Lecture 163 The Visual Basic Editor (VBE) 3:26 Lecture 164 Excel VBA Modules 2:1 Lecture 165 Creating an Excel VBA Procedure 8:18 Lecture 166 Adding Code to a VBA Procedure 4:5 Lecture 167 Understanding Excel VBA Variables 7:2 Lecture 168 Building Logic with an IF Statement 6:19 Lecture 169 Working with Excel VBA Loops to Re of Code 9:42

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

 Lecture 170 Introduction to Project #2 Interacting with the U 2:57 Lecture 171 Project #2 Breaking Down the VBA Code 3:35 Lecture 172 Project #2 Prompting the User for Information. 6:54 Lecture 173 Continue Excel VBA InputBox 7:21 Lecture 174 Project #2 Building Logic into Your Macros. 4:32 Lecture 175 Project #2 Alerting the User of Errors 10:30 Lecture 176 Other Practical Uses of Message and Input Boxes 3:11

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

 Lecture 177 Introduction to Project #3 Cleaning Up and Format 3:6 Lecture 178 Project #3 Preparing to the Use the Macro Recorder 2:55 Lecture 179 Project #3 Inserting the Headers 3:27 Lecture 180 Project #3 Formatting the Headers 2:21 Lecture 181 Project #3 Putting it all Together with a Little 10:47 Lecture 182 Running the Loop 2:54

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

 Lecture 183 Introduction to Project #4 Automate Excel Formulas 2:10 Lecture 184 Project #4 Automate the SUM() Function through Co 8:1 Lecture 185 Continue Automate SUM Function 6:28 Lecture 186 Test the SUM Function 3:45 Lecture 187 Project #4 Loop the SUM() Function Over Multiple W 2:59

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

 Lecture 188 Introduction to Project #5 Creating the Final Rep 2:59 Lecture 189 Project #5 Creating the Final Report Loop 7:45 Lecture 190 Project #5 - Copying and Pasting Data with VBA. Lecture 191 Project #5 - Running the Final Report Procedure 3:15

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

 Lecture 192 Introduction to Project #6 Working with Excel VBA 3:1 Lecture 193 Project #6 Creating an Excel User Form 5:5 Lecture 194 Project #6 Adding Controls to the Form 4:1 Lecture 195 Project #6 Adding VBA Code to the Initialize Even 8:49 Lecture 196 Project #6 Adding VBA Code to the ComboBox 4:32 Lecture 197 Project #6 Adding VBA Code to the Add Worksheet B 3:28 Lecture 198 Change Worksheet Name 3:59 Lecture 199 Project #6 Adding VBA Code to the Create Report Bu 8:53 Lecture 200 Project #6 Showing the Form. 4:2

#### Section 38 : Project #7 Importing Data from Text Files

 Lecture 201 Project #7 Opening a Text File for Import 2:37 Lecture 202 Project #7 Opening a Text File for Import 6:41 Lecture 203 Project #7 Get Data from Text File 5:24 Lecture 204 Project #7 Importing Multiple Text Files with the 9:27 Lecture 205 Project #7 Creating a Loop to Read Each File 7:21 Lecture 206 Project #7 Adding a New Sheet for Imported Data 2:30 Lecture 207 Project #7 Clear the Clipboard 3:32 Lecture 208 Project #7 Working with the ScreenUpdating Proper 3:11 Lecture 209 Project #7 Creating Reusable Code with a VBA 7:38

#### Section 39 : Course Wrap Up

 Lecture 210 Congratulations! You're an Excel MacroVBA Master. 0:50