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 12 : Microsoft Excel 102 Course Introduction

Lecture 64 Excel 102 Course Exercise Files -- DOWNLOAD 1:16

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 21 : Microsoft Excel 103 Course Introduction

Lecture 114 Excel 103 Course Exercise Files -- DOWNLOAD 1:23

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