Filename Size 02 Microsoft Excel 101 Course Introduction/002 Course Exercise Files-ja.srt 285 B 03 Microsoft Excel Fundamentals/003 Launching Excel-ja.srt 1.2 KB 03 Microsoft Excel Fundamentals/007 Saving an Excel Document-ja.srt 997 B 03 Microsoft Excel Fundamentals/008 Opening an Existing Excel Document-ja.srt 492 B 04 Entering and Editing Text and Formulas/016 Understanding the Order of Operation-ja.srt 1 KB 05 Working with Basic Excel Functions/020 Working with the AVERAGE() Function-ja.srt 1 KB 05 Working with Basic Excel Functions/021 Working with the COUNT() Function-ja.srt 612 B 05 Working with Basic Excel Functions/023 Using the AutoFill Command to Copy Formulas-ja.srt 990 B 06 Modifying an Excel Worksheet/027 Hiding and Unhiding Excel Rows and Columns-ja.srt 839 B 06 Modifying an Excel Worksheet/028 Deleting an Excel Worksheet-ja.srt 329 B 06 Modifying an Excel Worksheet/029 Renaming an Excel Worksheet-ja.srt 748 B 06 Modifying an Excel Worksheet/030 Moving and Copying and Excel Worksheet-ja.srt 1 KB 07 Formatting Data in an Excel Worksheet/031 Working with Font Formatting Commands-ja.srt 1 KB 07 Formatting Data in an Excel Worksheet/032 Changing the Background Color of a Cell-ja.srt 488 B 07 Formatting Data in an Excel Worksheet/033 Adding Borders to Cells-ja.srt 913 B 07 Formatting Data in an Excel Worksheet/034 Formatting Data as Currency Values-ja.srt 1.1 KB 07 Formatting Data in an Excel Worksheet/035 Formatting Percentages-ja.srt 645 B 07 Formatting Data in an Excel Worksheet/036 Using Excels Format Painter-ja.srt 705 B 07 Formatting Data in an Excel Worksheet/038 Merging and Centering Cells-ja.srt 877 B 08 Inserting Images and Shapes into an Excel Worksheet/041 Inserting Excel Shapes-ja.srt 954 B 08 Inserting Images and Shapes into an Excel Worksheet/042 Formatting Excel Shapes-ja.srt 1.1 KB 09 Creating Basic Charts in Excel/044 Creating an Excel Column Chart-ja.srt 1.2 KB 09 Creating Basic Charts in Excel/046 Adding and Modifying Data on an Excel Chart-ja.srt 807 B 09 Creating Basic Charts in Excel/047 Formatting an Excel Chart-ja.srt 962 B 09 Creating Basic Charts in Excel/048 Moving a Chart to another Worksheet-ja.srt 474 B 09 Creating Basic Charts in Excel/049 Working with Excel Pie Charts-ja.srt 1.3 KB 10 Printing an Excel Worksheet/050 Viewing your Document in Print Preview-ja.srt 873 B 10 Printing an Excel Worksheet/052 Working with Page Layout View-ja.srt 1 KB 10 Printing an Excel Worksheet/053 Adding Header and Footer Content-ja.srt 1.2 KB 10 Printing an Excel Worksheet/054 Printing a Specific Range of Cells-ja.srt 678 B 11 Working with Excel Templates/055 Intro to Excel Templates-ja.srt 627 B 11 Working with Excel Templates/057 Creating a Custom Template-ja.srt 1.2 KB 12 Congratulations Youve Built a Solid Microsoft Excel Foundation/058 Congratulations-it.srt 1.3 KB 12 Congratulations Youve Built a Solid Microsoft Excel Foundation/058 Congratulations-ja.srt 269 B 12 Congratulations Youve Built a Solid Microsoft Excel Foundation/058 Congratulations-pt.srt 1.2 KB 12 Congratulations Youve Built a Solid Microsoft Excel Foundation/058 Congratulations-tr.srt 1.1 KB 14 Working with an Excel List/061 Sorting a List Using Single Level Sort-ja.srt 759 B 14 Working with an Excel List/064 Filter an Excel List Using the AutoFilter Tool-ja.srt 1.2 KB 14 Working with an Excel List/067 Using Conditional Formatting to Find Duplicates-ja.srt 997 B 14 Working with an Excel List/068 Removing Duplicates-ja.srt 1 KB 15 Excel List Functions/070 Excel Function DAVERAGE()-ja.srt 1 KB 15 Excel List Functions/071 Excel Function DCOUNT()-ja.srt 941 B 16 Excel Data Validation/075 Adding a Custom Validation Error-ja.srt 965 B 16 Excel Data Validation/076 Dynamic Formulas by Using Validation Techniques-ja.srt 1.2 KB 18 Excel PivotTables/080 Understanding Excel PivotTables-ja.srt 1.2 KB 18 Excel PivotTables/084 Formatting PivotTable Data-ja.srt 959 B 18 Excel PivotTables/085 Drilling Down into PivotTable Data-ja.srt 1.1 KB 18 Excel PivotTables/086 Creating PivotCharts-ja.srt 1022 B 18 Excel PivotTables/087 Filtering PivotTable Data-ja.srt 1.3 KB 18 Excel PivotTables/088 Filtering with the Slicer Tool-ja.srt 1.1 KB 19 Working with Excels PowerPivot Tools/090 Activating the Excel PowerPivot AddIn-ja.srt 1.1 KB 19 Working with Excels PowerPivot Tools/092 Creating PivotTables based on Data Models-ja.srt 1.2 KB 19 Working with Excels PowerPivot Tools/093 PowerPivot Calculated Fields-ja.srt 1.2 KB 20 Working with Large Sets of Excel Data/095 Using the Freeze Panes Tool-ja.srt 806 B 21 Congratulations Youre an Intermediate Excel User/100 Congratulations-en.srt 912 B 21 Congratulations Youre an Intermediate Excel User/100 Congratulations-it.srt 907 B 21 Congratulations Youre an Intermediate Excel User/100 Congratulations-ja.srt 247 B 21 Congratulations Youre an Intermediate Excel User/100 Congratulations-pt.srt 908 B 21 Congratulations Youre an Intermediate Excel User/100 Congratulations-tr.srt 758 B 22 Microsoft Excel 103 Course Introduction/101 Course Excerise Files - Download this Excel File First.html 1.3 KB 25 Working with Excels Text Based Functions/114 Using Excels CONCATENATE() Function-ja.srt 744 B 26 Auditing an Excel Worksheet/115 Tracing Precendents in Excel Formulas-ja.srt 1.1 KB 26 Auditing an Excel Worksheet/116 Tracing Dependents in Excel Formuals-ja.srt 892 B 26 Auditing an Excel Worksheet/117 Working with the Watch Window-ja.srt 1.3 KB 26 Auditing an Excel Worksheet/118 Showing Formulas-ja.srt 675 B 27 Protecting Excel Worksheets and Workbooks/120 Protecting the Structure of a Workbook-ja.srt 920 B 27 Protecting Excel Worksheets and Workbooks/121 Adding a Workbook Password-ja.srt 976 B 29 Automating Repetitive Tasks in Excel with Macros/126 Understanding Excel Macros-ja.srt 1.1 KB 29 Automating Repetitive Tasks in Excel with Macros/127 Activating the Developer Tab in Excel-ja.srt 627 B 29 Automating Repetitive Tasks in Excel with Macros/130 Creating Buttons to Run Macros-ja.srt 899 B 30 Congratualtions/131 Congratulations on Competing the Microsoft Excel 103-ja.srt 284 B 31 Microsoft Excel Macros and VBA Course Introduction/134 Course Exercise Files - Download these First.html 1.2 KB 32 Project 1 Using Excels Macro Recorder Tool/135 Introduction to Project 1 Inserting and Formatting Text-ja.srt 632 B 32 Project 1 Using Excels Macro Recorder Tool/137 Running A Macro-ja.srt 607 B 32 Project 1 Using Excels Macro Recorder Tool/138 Project 1 Running a Macro with a Button-ja.srt 805 B 32 Project 1 Using Excels Macro Recorder Tool/139 Project 1 Opps I Need to Edit My Macro-ja.srt 1.2 KB 32 Project 1 Using Excels Macro Recorder Tool/140 Practical Uses of Excel Macros-ja.srt 922 B 33 Excel VBA Concepts/143 Excel VBA Modules-ja.srt 664 B 33 Excel VBA Concepts/145 Adding Code to a VBA Procedure-ja.srt 1 KB 34 Project 2 Moving Beyond the Basics and into VBA/149 Introduction to Project 2 Interacting with the User-ja.srt 821 B 34 Project 2 Moving Beyond the Basics and into VBA/155 Other Practical Uses of Message and Input Boxes-ja.srt 966 B 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/157 Project 3 Preparing to the Use the Macro Recorder-ja.srt 666 B 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/158 Project 3 Inserting the Headers-ja.srt 614 B 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/159 Project 3 Formatting the Headers-ja.srt 665 B 35 Project 3 Preparing and Cleaning Up Data with a Little VBA/161 Running the Loop-ja.srt 942 B 36 Project 4 Using VBA to Automate Excel Formulas/162 Introduction to Project 4 Automate Excel Formulas-ja.srt 682 B 36 Project 4 Using VBA to Automate Excel Formulas/165 Test the SUM Function-ja.srt 1.2 KB 37 Project 5 Bringing it All Together and a Weekly Report/167 Introduction to Project 5 Creating the Final Report-ja.srt 850 B 37 Project 5 Bringing it All Together and a Weekly Report/170 Project 5 - Running the Final Report Procedure-ja.srt 750 B 38 Project 6 Working with Excel VBA User Forms/171 Introduction to Project 6 Working with Excel VBA User Forms-ja.srt 711 B 38 Project 6 Working with Excel VBA User Forms/173 Project 6 Adding Controls to the Form-ja.srt 815 B 38 Project 6 Working with Excel VBA User Forms/175 Project 6 Adding VBA Code to the ComboBox Change Event-ja.srt 680 B 38 Project 6 Working with Excel VBA User Forms/176 Project 6 Adding VBA Code to the Add Worksheet Button-ja.srt 612 B 38 Project 6 Working with Excel VBA User Forms/177 Change Worksheet Name-ja.srt 1000 B 38 Project 6 Working with Excel VBA User Forms/179 Project 6 Showing the Form-ja.srt 1 KB 39 Course Wrap Up/180 Congratulations Youre an Excel MacroVBA Master-it.srt 1.2 KB 39 Course Wrap Up/180 Congratulations Youre an Excel MacroVBA Master-ja.srt 198 B 39 Course Wrap Up/180 Congratulations Youre an Excel MacroVBA Master-pt.srt 1.2 KB 39 Course Wrap Up/180 Congratulations Youre an Excel MacroVBA Master-tr.srt 1.1 KB
