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 |
