course-material

  19 - Working with Excel's PowerPivot Tools

   001 Introduction to Excel Power Pivot.mp4

   002 Why PowerPivot_en.srt

   003 Activating the Excel PowerPivot AddIn_en.srt

   004 Creating Data Models with PowerPivot_en.srt

   005 Excel Power Pivot Data Model Relationships_en.srt

   006 Creating PivotTables based on Data Models_en.srt

   007 Excel Power Pivot KPIs_en.srt

  01 - Microsoft Excel 101 Course Introduction

   001 Ask Questions_en.srt

   002 Course Exercise Files_en.srt

   002 MonthlyBudget-AutoFill-01.xlsx

   002 MonthlyBudget-AverageFunction-01.xlsx

   002 MonthlyBudget-Count-01.xlsx

   002 MonthlyBudget-MIN-MAXFunctions-01.xlsx

   002 MonthlyBudget-SUMFunction-01.xlsx

   003 Certificate of Completion.mp4

  02 - Microsoft Excel Fundamentals

   001 Launching Excel_en.srt

   002 Microsoft Excel Startup Screen_en.srt

   003 Introduction to the Excel Interface_en.srt

   004 Customizing the Excel Quick Access Toolbar_en.srt

   005 More on the Excel Interface_en.srt

   006 Understanding the Structure of an Excel Workbook_en.srt

   007 Saving an Excel Document_en.srt

   008 Opening an Existing Excel Document_en.srt

   009 Common Excel Shortcut Keys_en.srt

  03 - Entering and Editing Text and Formulas

   001 Entering Text to Create Spreadsheet Titles_en.srt

   002 Working with Numeric Data in Excel_en.srt

   003 Entering Date Values in Excel_en.srt

   004 Working with Cell References_en.srt

   005 Creating Basic Formulas in Excel_en.srt

   006 Relative Versus Absolute Cell References in Formulas_en.srt

   007 Understanding the Order of Operation (DOWNLOAD EXERCISE FILE).mp4

  04 - Working with Basic Excel Functions

   001 The structure of an Excel Function.mp4

   002 Working with the SUM() Function.mp4

   003 Working with the MIN() and MAX() Functions.mp4

   004 Working with the AVERAGE() Function.mp4

   005 Working with the COUNT() Function.mp4

   006 Adjacent Cells Error in Excel Calculations.mp4

   007 Using the AutoSum Command.mp4

   008 Excel's AutoSum Shortcut Key.mp4

   009 Using the AutoFill Command to Copy Formulas.mp4

  05 - Modifying an Excel Worksheet

   001 Moving and Copying Data in an Excel Worksheet_en.srt

   002 Inserting and Deleting Rows and Columns_en.srt

   003 Changing the Width and Height of Cells_en.srt

   004 Hiding and Unhiding Excel Rows and Columns_en.srt

   005 Renaming an Excel Worksheet_en.srt

   006 Deleting an Excel Worksheet_en.srt

   007 Moving and Copying an Excel Worksheet_en.srt

  06 - Formatting Data in an Excel Worksheet

   001 Working with Font Formatting Commands_en.srt

   002 Changing the Background Color of a Cell_en.srt

   003 Adding Borders to Cells_en.srt

   004 Excel Cell Borders Continued_en.srt

   005 Formatting Data as Currency Values_en.srt

   006 Formatting Percentages_en.srt

   007 Using Excel's Format Painter_en.srt

   008 Creating Styles to Format Data_en.srt

   009 Merging and Centering Cells_en.srt

   010 Using Conditional Formatting_en.srt

   011 Editing Excel Conditional Formatting_en.srt

  07 - Inserting Images and Shapes into an Excel Worksheet

   001 Inserting Images_en.srt

   002 Inserting Excel Shapes_en.srt

   003 Formatting Excel Shapes_en.srt

   004 Working with Excel SmartArt_en.srt

  08 - Creating Basic Charts in Excel

   001 Creating an Excel Column Chart_en.srt

   002 Working with the Excel Chart Ribbon_en.srt

   003 Adding and Modifying Data on an Excel Chart_en.srt

   004 Formatting an Excel Chart_en.srt

   005 Moving a Chart to another Worksheet_en.srt

   006 Working with Excel Pie Charts_en.srt

   007 PresentingDataEffectivelywithExcelCharts-01.pdf

  09 - Printing an Excel Worksheet

   001 Viewing your Document in Print Preview_en.srt

   002 Changing the Margins, Scaling and Orientation_en.srt

   003 Excel Worksheet Margins_en.srt

   004 Working with Page Layout View_en.srt

   005 Adding Header and Footer Content_en.srt

   006 Printing a Specific Range of Cells_en.srt

  10 - Working with Excel Templates

   001 Intro to Excel Templates_en.srt

   002 Opening an Existing Template_en.srt

   003 Creating a Custom Template_en.srt

  11 - Excel 101 - Practice What You've Learned (DOWNLOAD)

   001 Excel101ExtraPractice-01.xlsx

  12 - Congratulations! You've Built a Solid Microsoft Excel Foundation

   001 Congratulations!_en.srt

  13 - Microsoft Excel 102 Course Introduction

   001 Excel 102 Course Exercise Files -- DOWNLOAD_en.srt

   001 SalesData-TEXT-IMPORT.txt

  14 - Working with an Excel List

   001 Understanding Excel List Structure_en.srt

   002 Sorting a List Using Single Level Sort_en.srt

   003 Sorting a List Using Multi-Level Sorts_en.srt

   004 Using Custom Sorts in an Excel List_en.srt

   005 Filter an Excel List Using the AutoFilter Tool_en.srt

   006 Creating Subtotals in a List_en.srt

   007 Format a List as a Table_en.srt

   008 Using Conditional Formatting to Find Duplicates_en.srt

   009 Removing Duplicates_en.srt

  15 - Excel List Functions

   001 Introduction to Excels Function DSUM()_en.srt

   002 Excel DSUM Function Single Criteria Continued_en.srt

   003 Excel DSUM Function with OR Criteria_en.srt

   004 Excel DSUM Function with AND Criteria_en.srt

   005 Excel Function DAVERAGE()_en.srt

   006 Excel Function DCOUNT()_en.srt

   007 Excel Function SUBTOTAL()_en.srt

  16 - Excel Data Validation

   001 Understanding the Need for Excel Data Validation_en.srt

   002 Creating an Excel Data Validation List_en.srt

   003 Excel Decimal Data Validation_en.srt

   004 Adding a Custom Excel Data Validation Error_en.srt

   005 Dynamic Formulas by Using Excel Data Validation Techniques_en.srt

  17 - Importing and Exporting Data

   001 Importing Data Into Microsoft Excel_en.srt

   002 Importing Data from Text Files_en.srt

   003 Importing Data from Microsoft Access_en.srt

   004 NEW VERSION -- Import Data From Text Files into Excel_en.srt

   005 NEW VERSION -- Import Data From a Database into Excel_en.srt

   006 Microsoft Excel Legacy Import Options for New Excel Versions_en.srt

   007 Exporting Data to a Text File_en.srt

  18 - Excel PivotTables

   001 Understanding Excel PivotTables_en.srt

   002 Creating an Excel PivotTable_en.srt

   003 Modifying Excel PivotTable Calculations_en.srt

   004 Grouping PivotTable Data_en.srt

   005 Formatting PivotTable Data_en.srt

   006 Modifying PivotTable Calculations_en.srt

   007 Drilling Down into PivotTable Data_en.srt

   008 Creating PivotCharts_en.srt

   009 Filtering PivotTable Data_en.srt

   010 Filtering with the Slicer Tool_en.srt

  20 - Working with Large Sets of Excel Data

   001 Using the Freeze Panes Tool_en.srt

   002 Grouping Data (Columns andor Rows)_en.srt

   003 Print Options for Large Sets of Data_en.srt

   004 Linking Worksheets (3D Formulas)_en.srt

   005 Consolidating Data from Multiple Worksheets_en.srt

   006 Microsoft Excel Managing Large Excel Datasets Quick Guide (DOWNLOAD).html

  21 - Excel 102 Additional Practice Exercises

   001 Excel 102 - Practice What You've Learned (DOWNLOAD).html

  22 - Congratulations! You're an Intermediate Excel User

   001 Congratulations!_en.srt

  23 - Microsoft Excel 103 Course Introduction

   001 Excel 103 Course Exercise Files -- DOWNLOAD_en.srt

  24 - Working with Excel's Conditional Functions

   001 Working with Excel Name Ranges_en.srt

   002 Advantages and Disadvantages of Excel Name Ranges_en.srt

   003 Editing an Excel Name Range_en.srt

   004 Using Excel's IF() Function_en.srt

   005 Excel's IF() Function with a Name Range_en.srt

   006 Nesting Functions with Excel_en.srt

   007 Nesting Excels AND() Function within the IF() Function_en.srt

   008 Using Excel's COUNTIF() Function_en.srt

   009 Using Excel's SUMIF() Function_en.srt

   010 Using Excel's IFERROR() Function_en.srt

  25 - Working with Excel's Lookup Functions

   001 Microsoft Excel VLOOKUP() Function_en.srt

   002 Microsoft Excel HLOOKUP() Function_en.srt

   003 Microsoft Excel INDEX() Function_en.srt

   004 Microsoft Excel MATCH() Function_en.srt

   005 Microsoft Excel INDEX() and MATCH() Function Combined_en.srt

   006 Microsoft Excel INDEX() and MATCH() Function Combined Continued_en.srt

   007 Creating a Dynamic HLOOKUP() with the MATCH() Function_en.srt

  26 - Working with Excel's Text Based Functions

   001 Using Excel's LEFT(), RIGHT() and MID() Functions_en.srt

   002 Using Excel's LEN() Function_en.srt

   003 Using Excel's SEARCH() Function_en.srt

   004 Using Excel's CONCATENATE() Function_en.srt

   005 Microsoft Excel Adv. Functions and Formulas Quick Guide (DOWNLOAD).html

  27 - Auditing an Excel Worksheet

   001 Tracing Precedents in Excel Formulas_en.srt

   002 Tracing Dependents in Excel Formulas_en.srt

   003 Working with the Watch Window_en.srt

   004 Showing Formulas_en.srt

  28 - Protecting Excel Worksheets and Workbooks

   001 Protecting Specific Cells in a Worksheet_en.srt

   002 Protecting the Structure of a Workbook_en.srt

   003 Adding a Workbook Password_en.srt

  29 - Mastering Excel's What If Tools

   001 Working with Excel's Goal Seek Tool_en.srt

   002 Working with Excel's Solver Tool_en.srt

   003 Building Effective Data Tables in Excel_en.srt

   004 Creating Scenarios in Excel_en.srt

  30 - Automating Repetitive Tasks in Excel with Macros

   001 Understanding Excel Macros_en.srt

   002 Activating the Developer Tab in Excel_en.srt

   003 Creating a Macro with the Macro Recorder_en.srt

   004 Editing a Macro with VBA_en.srt

   005 Creating Buttons to Run Macros_en.srt

  31 - Excel 103 Additional Practice Exercises

   001 Excel 103 - Practice What You've Learned (DOWNLOAD).html

  32 - Congratulations!

   001 Congratulations on Completing the Microsoft Excel 103_en.srt

  33 - Microsoft Excel Macros and VBA Course Introduction

   001 Welcome to the Course_en.srt

   002 Understanding the Why and How Behind Excel Macros_en.srt

  34 - Project #1 Using Excel's Macro Recorder Tool

   001 Introduction to Project #1 Inserting and Formatting Text_en.srt

   002 InsertingAndFormattingText.xlsx

   003 Activating the Excel Developer Tab.mp4

   004 InsertingAndFormattingText.xlsx

   004 Project #1 Start Recording!_en.srt

   005 Running a Microsoft Excel Macro_en.srt

   006 Project #1 Running an Excel Macro with a Button_en.srt

   007 BONUS - Create a Custom Button Using Excel Shapes_en.srt

   008 Adding the Excel Macro to the Quick Access Toolbar_en.srt

   009 Project #1 Editing the VBA Recorded by the Macro Recorder_en.srt

   010 Save a Workbook with a MacroVBA Code_en.srt

   011 Practical Uses of Excel Macros_en.srt

  35 - Excel VBA Concepts

   001 Intro to Excel VBA Concepts_en.srt

   002 Intro to Excel VBA Object Oriented Programming Concepts_en.srt

   003 ExcelMacrosAndVBA-PP.pptx

   004 The Visual Basic Editor (VBE).mp4

   005 Introduction to the Excel VBA Immediate Window.mp4

   006 Excel VBA Modules.mp4

   007 Creating an Excel VBA Procedure.mp4

   008 Adding Code to a VBA Procedure.mp4

   009 Including Excel VBA Comments.mp4

   010 Excel VBA MSGBOX Function.mp4

   011 Excel VBA MsgBox Microsoft Help Information.mp4

   012 Understanding and Working with Excel VBA Variables.mp4

   013 REMINDER Saving an Excel Workbook with VBA Code.mp4

  36 - Working with Excel VBA Logic Statements

   001 ExcelVBALoops.xlsx

   002 Building Logic with an Excel VBA IF Statement.mp4

   003 Including an Else Statement in the VBA IF Statement.mp4

   004 Expanding the IF Logic with Multiple ElseIf Statements.mp4

   005 Working with Excel VBA Select Case Statements.mp4

   006 Working with an Excel VBA Do While Loop.mp4

   007 Excel VBA Do While Loop Dynamic Condition.mp4

   008 Working with an Excel VBA For Each Loop.mp4

   009 Working with an Excel VBA For Next Loop.mp4

  37 - Project #2 Moving Beyond the Basics and into VBA

   001 Introduction to Project #2 Interacting with the User_en.srt

   002 COM-SortingRecords.xlsm

   003 Project #2 Introduction to the Excel VBA Range.Sort Method.mp4

   003 SortingRecords.xlsm

   004 Creating the Excel VBA Sort Procedures for this Project_en.srt

   005 Project #2 Prompting the User for Information_en.srt

   006 Continue Excel VBA InputBox_en.srt

   007 Project #2 Building Logic into Your Macros_en.srt

   008 Project #2 Alerting the User of Errors_en.srt

   009 Using Excel VBA Error Control Statements_en.srt

   010 Create a Button to Run the Sort Procedure and Save_en.srt

  38 - Project #3 Preparing and Cleaning Up Data with Excel VBA

   001 Introduction to Project #3 Cleaning Up and Formatting Data_en.srt

   002 COM-CleaningUpData-01.xlsm

   003 Project #3 Preparing to the Use the Macro Recorder.mp4

   004 Project #3 Inserting the Headers.mp4

   005 Project #3 Formatting the Headers.mp4

   006 Project #3 Testing the Macros.mp4

   007 Project #3 Using an Excel VBA Loop to Loop through all Worksheets.mp4

   008 Project #3 Testing the Excel VBA Loop.mp4

   009 Project #3 Adding Logic to an Excel VBA Loop.mp4

  39 - Project #4 Using VBA to Automate Excel Formulas

   001 Introduction to Project #4 Automate Excel Formulas_en.srt

   002 COM-AutomateSumFunction-01.xlsm

   003 AutomateSumFunction.xlsx

   003 Project #4 Start the Procedure to Automate the SUM Function_en.srt

   004 Working with the Range Address Property_en.srt

   005 Creating the SUM Function in VBA_en.srt

   006 Run the Excel VBA Procedure to SUM Records_en.srt

   007 Project #4 Loop the SUM() Function Over Multiple Worksheets_en.srt

  40 - Project #5 Bringing it All Together and a Weekly Report

   001 Introduction to Project #5 Creating the Final Report_en.srt

   002 Project #5 Final Report Loop Exercise Files (DOWNLOAD).html

   003 Project #5 Creating the Final Report Excel VBA Loop.mp4

   004 Project #5 - Copying Content with Excel VBA.mp4

   005 Project #5 - Pasting Content with Excel VBA.mp4

   006 Cleaning Up the Final Report VBA Loop Code.mp4

   007 Adding Logic to Stop the Loop from Running Multiple Times on a Worksheet.mp4

   008 Project #5 - Running the Final Report Procedure.mp4

  41 - Project #6 Working with Excel VBA User Forms

   001 Introduction to Project #6 Working with Excel VBA User Forms_en.srt

   002 COM-QuarterlyReportForm-01.xlsm

   002 QuarterlyReportForm-01.xlsm

   003 Project #6 Creating an Excel User Form_en.srt

   004 Project #6 Working with Form and Control Properties_en.srt

   005 Project #6 Formatting Excel VBA User Form Controls_en.srt

   006 Project #6 Adding VBA Code to the Initialize Event_en.srt

   007 Project #6 Using the AddItem Method within a Loop_en.srt

   008 Project #6 Adding VBA Code to the ComboBox Change Event_en.srt

   009 Project #6 Adding VBA Code to the Add Worksheet Button_en.srt

   010 Project #6 Change Worksheet Name_en.srt

   011 Project #6 Catch Errors When Adding a Worksheet_en.srt

   012 AddSheetError-Solution-01.txt

   013 Project #6 Additional Conditions on the Loop_en.srt

   014 Project #6 Running the Final Report Procedure_en.srt

   015 Project #6 Showing the VBA User Form On Workbook Open_en.srt

  42 - Project #7 Importing Data from Text Files

   001 Dec2015Sales.txt

   001 Jan2015Sales.txt

   001 May2015Sales.txt

   001 Project #7 Opening a Text File for Import.mp4

   002 Project #7 Opening a Text File for Import.mp4

   003 Project #7 Get Data from Text File.mp4

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

   005 Project #7 Creating a Loop to Read Each File.mp4

   006 Project #7 Adding a New Sheet for Imported Data.mp4

   007 Project #7 Clear the Clipboard.mp4

   008 Project #7 Working with the ScreenUpdating Property.mp4

   009 Project #7 Creating Reusable Code with a VBA Function.mp4

  43 - Course Wrap Up

   001 Congratulations! You're an Excel MacroVBA Master_en.srt

 [TGx]Downloaded from torrentgalaxy.to .txt