Microsoft Excel from Beginner to Advanced | CDA9B48C7FBC9FBF1D8F84C0666ADB07454765F6

Microsoft Excel from Beginner to Advanced

Name	Microsoft Excel- Excel from Beginner to Advanced	DOWNLOAD Copy Link
Total Size	3.7 GB
Total Files	1084
Hash	CDA9B48C7FBC9FBF1D8F84C0666ADB07454765F6

/39 Course Wrap Up/
180 Congratulations Youre an Excel MacroVBA Master-ja.srt	0.2 KB
180 Congratulations Youre an Excel MacroVBA Master-tr.srt	1.2 KB
180 Congratulations Youre an Excel MacroVBA Master-pt.srt	1.2 KB
180 Congratulations Youre an Excel MacroVBA Master-it.srt	1.2 KB
180 Congratulations Youre an Excel MacroVBA Master-en.srt	1.3 KB
181 BONUS - Special Offer Discount on Any of my Courses.html	3.0 KB
180 Congratulations Youre an Excel MacroVBA Master.mp4	38.9 MB
/21 Congratulations Youre an Intermediate Excel User/
100 Congratulations-ja.srt	0.2 KB
100 Congratulations-tr.srt	0.8 KB
100 Congratulations-it.srt	0.9 KB
100 Congratulations-pt.srt	0.9 KB
100 Congratulations-en.srt	0.9 KB
100 Congratulations.mp4	9.1 MB
/12 Congratulations Youve Built a Solid Microsoft Excel Foundation/
058 Congratulations-ja.srt	0.3 KB
058 Congratulations-tr.srt	1.1 KB
058 Congratulations-pt.srt	1.3 KB
058 Congratulations-it.srt	1.3 KB
058 Congratulations-en.srt	1.3 KB
058 Congratulations.mp4	5.8 MB
/30 Congratualtions/
131 Congratulations on Competing the Microsoft Excel 103-ja.srt	0.3 KB
131 Congratulations on Competing the Microsoft Excel 103-tr.srt	1.4 KB
131 Congratulations on Competing the Microsoft Excel 103-pt.srt	1.5 KB
131 Congratulations on Competing the Microsoft Excel 103-it.srt	1.6 KB
131 Congratulations on Competing the Microsoft Excel 103-en.srt	1.6 KB
131 Congratulations on Competing the Microsoft Excel 103.mp4	3.6 MB
/02 Microsoft Excel 101 Course Introduction/
002 Course Exercise Files-ja.srt	0.3 KB
002 Course Exercise Files-tr.srt	1.6 KB
002 Course Exercise Files-pt.srt	1.7 KB
002 Course Exercise Files-it.srt	1.7 KB
002 Course Exercise Files-en.srt	1.7 KB
002 MonthlyBudget-ReferenceTypes-01.xlsx	14.0 KB
002 MonthlyBudget-Headers-01.xlsx	14.0 KB
002 MonthlyBudget-BasicFormulas-01.xlsx	14.0 KB
002 MonthlyBudget-SUMFunction-01.xlsx	14.1 KB
002 MonthlyBudget-AutoFill-01.xlsx	14.2 KB
002 MonthlyBudget-MIN-MAXFunctions-01.xlsx	14.4 KB
002 MonthlyBudget-AverageFunction-01.xlsx	14.4 KB
002 MonthlyBudget-AutoSUM-01.xlsx	14.5 KB
002 MonthlyBudget-01.xlsx	14.6 KB
002 MonthlyBudget-Count-01.xlsx	14.6 KB
002 MonthlyBudget-Template-01.xlsx	14.9 KB
002 Course Exercise Files.mp4	2.4 MB
/06 Modifying an Excel Worksheet/
028 Deleting an Excel Worksheet-ja.srt	0.3 KB
029 Renaming an Excel Worksheet-ja.srt	0.7 KB
027 Hiding and Unhiding Excel Rows and Columns-ja.srt	0.8 KB
030 Moving and Copying and Excel Worksheet-ja.srt	1.1 KB
026 Changing the Width and Height of Cells-ja.srt	1.4 KB
025 Inserting and Deleting Rows and Columns-ja.srt	1.4 KB
024 Moving and Copying Data in an Excel Worksheet-ja.srt	1.4 KB
029 Renaming an Excel Worksheet-tr.srt	3.0 KB
029 Renaming an Excel Worksheet-en.srt	3.2 KB
029 Renaming an Excel Worksheet-pt.srt	3.3 KB
029 Renaming an Excel Worksheet-it.srt	3.4 KB
028 Deleting an Excel Worksheet-tr.srt	4.2 KB
027 Hiding and Unhiding Excel Rows and Columns-tr.srt	4.3 KB
027 Hiding and Unhiding Excel Rows and Columns-en.srt	4.5 KB
028 Deleting an Excel Worksheet-pt.srt	4.6 KB
027 Hiding and Unhiding Excel Rows and Columns-pt.srt	4.6 KB
028 Deleting an Excel Worksheet-en.srt	4.7 KB
027 Hiding and Unhiding Excel Rows and Columns-it.srt	4.8 KB
028 Deleting an Excel Worksheet-it.srt	4.9 KB
030 Moving and Copying and Excel Worksheet-tr.srt	6.2 KB
030 Moving and Copying and Excel Worksheet-en.srt	6.5 KB
024 Moving and Copying Data in an Excel Worksheet-tr.srt	6.6 KB
030 Moving and Copying and Excel Worksheet-pt.srt	6.7 KB
030 Moving and Copying and Excel Worksheet-it.srt	6.9 KB
024 Moving and Copying Data in an Excel Worksheet-en.srt	7.2 KB
024 Moving and Copying Data in an Excel Worksheet-pt.srt	7.3 KB
026 Changing the Width and Height of Cells-tr.srt	7.3 KB
024 Moving and Copying Data in an Excel Worksheet-it.srt	7.6 KB
026 Changing the Width and Height of Cells-pt.srt	8.0 KB
026 Changing the Width and Height of Cells-en.srt	8.1 KB
025 Inserting and Deleting Rows and Columns-tr.srt	8.2 KB
026 Changing the Width and Height of Cells-it.srt	8.3 KB
025 Inserting and Deleting Rows and Columns-en.srt	8.9 KB
025 Inserting and Deleting Rows and Columns-pt.srt	9.0 KB
025 Inserting and Deleting Rows and Columns-it.srt	9.1 KB
029 Renaming an Excel Worksheet.mp4	5.6 MB
028 Deleting an Excel Worksheet.mp4	8.5 MB
027 Hiding and Unhiding Excel Rows and Columns.mp4	8.9 MB
024 Moving and Copying Data in an Excel Worksheet.mp4	11.4 MB
030 Moving and Copying and Excel Worksheet.mp4	13.4 MB
026 Changing the Width and Height of Cells.mp4	17.2 MB
025 Inserting and Deleting Rows and Columns.mp4	18.2 MB
/09 Creating Basic Charts in Excel/
048 Moving a Chart to another Worksheet-ja.srt	0.5 KB
046 Adding and Modifying Data on an Excel Chart-ja.srt	0.8 KB
047 Formatting an Excel Chart-ja.srt	1.0 KB
044 Creating an Excel Column Chart-ja.srt	1.3 KB
049 Working with Excel Pie Charts-ja.srt	1.3 KB
045 Working with the Excel Chart Ribbon-ja.srt	1.4 KB
048 Moving a Chart to another Worksheet-tr.srt	3.6 KB
048 Moving a Chart to another Worksheet-en.srt	3.8 KB
048 Moving a Chart to another Worksheet-pt.srt	3.8 KB
048 Moving a Chart to another Worksheet-it.srt	3.9 KB
046 Adding and Modifying Data on an Excel Chart-tr.srt	4.4 KB
046 Adding and Modifying Data on an Excel Chart-en.srt	5.0 KB
046 Adding and Modifying Data on an Excel Chart-pt.srt	5.0 KB
046 Adding and Modifying Data on an Excel Chart-it.srt	5.1 KB
044 Creating an Excel Column Chart-tr.srt	6.8 KB
047 Formatting an Excel Chart-tr.srt	7.1 KB
045 Working with the Excel Chart Ribbon-tr.srt	7.3 KB
044 Creating an Excel Column Chart-pt.srt	7.5 KB
044 Creating an Excel Column Chart-en.srt	7.5 KB
044 Creating an Excel Column Chart-it.srt	7.6 KB
047 Formatting an Excel Chart-pt.srt	7.6 KB
049 Working with Excel Pie Charts-tr.srt	7.7 KB
047 Formatting an Excel Chart-en.srt	7.7 KB
047 Formatting an Excel Chart-it.srt	7.8 KB
045 Working with the Excel Chart Ribbon-pt.srt	8.0 KB
045 Working with the Excel Chart Ribbon-en.srt	8.1 KB
049 Working with Excel Pie Charts-en.srt	8.1 KB
045 Working with the Excel Chart Ribbon-it.srt	8.2 KB
049 Working with Excel Pie Charts-it.srt	8.3 KB
049 Working with Excel Pie Charts-pt.srt	8.4 KB
048 Moving a Chart to another Worksheet.mp4	7.8 MB
046 Adding and Modifying Data on an Excel Chart.mp4	12.9 MB
047 Formatting an Excel Chart.mp4	14.5 MB
045 Working with the Excel Chart Ribbon.mp4	16.4 MB
049 Working with Excel Pie Charts.mp4	17.7 MB
044 Creating an Excel Column Chart.mp4	17.8 MB
/07 Formatting Data in an Excel Worksheet/
032 Changing the Background Color of a Cell-ja.srt	0.5 KB
035 Formatting Percentages-ja.srt	0.6 KB
036 Using Excels Format Painter-ja.srt	0.7 KB
038 Merging and Centering Cells-ja.srt	0.9 KB
033 Adding Borders to Cells-ja.srt	0.9 KB
031 Working with Font Formatting Commands-ja.srt	1.1 KB
034 Formatting Data as Currency Values-ja.srt	1.1 KB
039 Using Conditional Formatting-ja.srt	1.3 KB
037 Creating Styles to Format Data-ja.srt	1.7 KB
035 Formatting Percentages-tr.srt	3.1 KB
035 Formatting Percentages-en.srt	3.4 KB
038 Merging and Centering Cells-tr.srt	3.5 KB
035 Formatting Percentages-pt.srt	3.5 KB
035 Formatting Percentages-it.srt	3.5 KB
038 Merging and Centering Cells-pt.srt	3.7 KB
038 Merging and Centering Cells-en.srt	3.8 KB
038 Merging and Centering Cells-it.srt	3.9 KB
036 Using Excels Format Painter-tr.srt	4.0 KB
032 Changing the Background Color of a Cell-tr.srt	4.2 KB
036 Using Excels Format Painter-pt.srt	4.3 KB
036 Using Excels Format Painter-en.srt	4.4 KB
036 Using Excels Format Painter-it.srt	4.4 KB
032 Changing the Background Color of a Cell-pt.srt	4.5 KB
032 Changing the Background Color of a Cell-it.srt	4.7 KB
032 Changing the Background Color of a Cell-en.srt	4.7 KB
033 Adding Borders to Cells-tr.srt	4.8 KB
033 Adding Borders to Cells-en.srt	5.4 KB
033 Adding Borders to Cells-it.srt	5.5 KB
033 Adding Borders to Cells-pt.srt	5.5 KB
031 Working with Font Formatting Commands-tr.srt	5.7 KB
039 Using Conditional Formatting-tr.srt	6.1 KB
031 Working with Font Formatting Commands-en.srt	6.3 KB
031 Working with Font Formatting Commands-pt.srt	6.3 KB
031 Working with Font Formatting Commands-it.srt	6.5 KB
039 Using Conditional Formatting-pt.srt	6.5 KB
039 Using Conditional Formatting-it.srt	6.7 KB
039 Using Conditional Formatting-en.srt	6.7 KB
034 Formatting Data as Currency Values-tr.srt	7.5 KB
034 Formatting Data as Currency Values-pt.srt	8.0 KB
034 Formatting Data as Currency Values-en.srt	8.1 KB
034 Formatting Data as Currency Values-it.srt	8.1 KB
037 Creating Styles to Format Data-tr.srt	11.6 KB
037 Creating Styles to Format Data-en.srt	12.8 KB
037 Creating Styles to Format Data-pt.srt	12.8 KB
037 Creating Styles to Format Data-it.srt	13.2 KB
035 Formatting Percentages.mp4	7.4 MB
032 Changing the Background Color of a Cell.mp4	9.0 MB
036 Using Excels Format Painter.mp4	9.4 MB
038 Merging and Centering Cells.mp4	10.3 MB
033 Adding Borders to Cells.mp4	11.0 MB
031 Working with Font Formatting Commands.mp4	12.3 MB
039 Using Conditional Formatting.mp4	16.0 MB
034 Formatting Data as Currency Values.mp4	17.3 MB
037 Creating Styles to Format Data.mp4	30.5 MB
/03 Microsoft Excel Fundamentals/
008 Opening an Existing Excel Document-ja.srt	0.5 KB
007 Saving an Excel Document-ja.srt	1.0 KB
003 Launching Excel-ja.srt	1.2 KB
005 Customizing the Excel Quick Access Toolbar-ja.srt	1.4 KB
004 Introduction to the Excel Interface-ja.srt	1.7 KB
006 Understanding the Structure of an Excel Workbook-ja.srt	1.9 KB
008 Opening an Existing Excel Document-tr.srt	2.8 KB
008 Opening an Existing Excel Document-it.srt	3.1 KB
008 Opening an Existing Excel Document-en.srt	3.1 KB
008 Opening an Existing Excel Document-pt.srt	3.1 KB
003 Launching Excel-tr.srt	3.6 KB
003 Launching Excel-en.srt	3.9 KB
007 Saving an Excel Document-tr.srt	3.9 KB
003 Launching Excel-it.srt	4.0 KB
003 Launching Excel-pt.srt	4.0 KB
007 Saving an Excel Document-it.srt	4.2 KB
007 Saving an Excel Document-en.srt	4.2 KB
007 Saving an Excel Document-pt.srt	4.3 KB
005 Customizing the Excel Quick Access Toolbar-tr.srt	5.2 KB
005 Customizing the Excel Quick Access Toolbar-en.srt	5.8 KB
005 Customizing the Excel Quick Access Toolbar-it.srt	6.0 KB
005 Customizing the Excel Quick Access Toolbar-pt.srt	6.0 KB
004 Introduction to the Excel Interface-tr.srt	6.1 KB
006 Understanding the Structure of an Excel Workbook-tr.srt	6.2 KB
006 Understanding the Structure of an Excel Workbook-en.srt	6.8 KB
006 Understanding the Structure of an Excel Workbook-pt.srt	7.0 KB
004 Introduction to the Excel Interface-en.srt	7.1 KB
006 Understanding the Structure of an Excel Workbook-it.srt	7.2 KB
004 Introduction to the Excel Interface-pt.srt	7.3 KB
004 Introduction to the Excel Interface-it.srt	7.3 KB
009 Common Excel Shortcut Keys.html	9.4 KB
008 Opening an Existing Excel Document.mp4	6.5 MB
007 Saving an Excel Document.mp4	7.6 MB
005 Customizing the Excel Quick Access Toolbar.mp4	10.4 MB
003 Launching Excel.mp4	11.9 MB
004 Introduction to the Excel Interface.mp4	12.9 MB
006 Understanding the Structure of an Excel Workbook.mp4	14.4 MB
/32 Project 1 Using Excels Macro Recorder Tool/
137 Running A Macro-ja.srt	0.6 KB
135 Introduction to Project 1 Inserting and Formatting Text-ja.srt	0.6 KB
138 Project 1 Running a Macro with a Button-ja.srt	0.8 KB
140 Practical Uses of Excel Macros-ja.srt	0.9 KB
139 Project 1 Opps I Need to Edit My Macro-ja.srt	1.2 KB
136 Project 1 Start Recording-ja.srt	2.6 KB
135 Introduction to Project 1 Inserting and Formatting Text-tr.srt	2.7 KB
135 Introduction to Project 1 Inserting and Formatting Text-en.srt	2.9 KB
135 Introduction to Project 1 Inserting and Formatting Text-it.srt	2.9 KB
135 Introduction to Project 1 Inserting and Formatting Text-pt.srt	2.9 KB
140 Practical Uses of Excel Macros-tr.srt	3.2 KB
140 Practical Uses of Excel Macros-en.srt	3.4 KB
140 Practical Uses of Excel Macros-pt.srt	3.5 KB
140 Practical Uses of Excel Macros-it.srt	3.5 KB
137 Running A Macro-tr.srt	4.0 KB
137 Running A Macro-en.srt	4.3 KB
137 Running A Macro-pt.srt	4.4 KB
137 Running A Macro-it.srt	4.5 KB
138 Project 1 Running a Macro with a Button-tr.srt	5.1 KB
138 Project 1 Running a Macro with a Button-en.srt	5.7 KB
138 Project 1 Running a Macro with a Button-pt.srt	5.7 KB
139 Project 1 Opps I Need to Edit My Macro-tr.srt	6.0 KB
138 Project 1 Running a Macro with a Button-it.srt	6.1 KB
139 Project 1 Opps I Need to Edit My Macro-pt.srt	6.5 KB
139 Project 1 Opps I Need to Edit My Macro-en.srt	6.5 KB
139 Project 1 Opps I Need to Edit My Macro-it.srt	6.6 KB
136 Project 1 Start Recording-tr.srt	10.6 KB
136 Project 1 Start Recording-en.srt	11.6 KB
136 Project 1 Start Recording-pt.srt	11.8 KB
136 Project 1 Start Recording-it.srt	12.1 KB
136 InsertingAndFormattingText.xlsx	17.8 KB
137 Running A Macro.mp4	9.0 MB
135 Introduction to Project 1 Inserting and Formatting Text.mp4	13.7 MB
140 Practical Uses of Excel Macros.mp4	19.4 MB
138 Project 1 Running a Macro with a Button.mp4	22.8 MB
139 Project 1 Opps I Need to Edit My Macro.mp4	29.2 MB
136 Project 1 Start Recording.mp4	51.6 MB
/05 Working with Basic Excel Functions/
021 Working with the COUNT() Function-ja.srt	0.6 KB
023 Using the AutoFill Command to Copy Formulas-ja.srt	1.0 KB
020 Working with the AVERAGE() Function-ja.srt	1.1 KB
017 The structure of an Excel Function-ja.srt	1.4 KB
019 Working with the MIN() and MAX() Functions-ja.srt	1.5 KB
018 Working with the SUM() Function-ja.srt	1.5 KB
022 Using the AutoSum Command-ja.srt	1.8 KB
021 Working with the COUNT() Function-tr.srt	2.9 KB
021 Working with the COUNT() Function-pt.srt	3.2 KB
021 Working with the COUNT() Function-en.srt	3.3 KB
021 Working with the COUNT() Function-it.srt	3.3 KB
020 Working with the AVERAGE() Function-tr.srt	3.6 KB
020 Working with the AVERAGE() Function-pt.srt	3.9 KB
020 Working with the AVERAGE() Function-it.srt	4.1 KB
020 Working with the AVERAGE() Function-en.srt	4.1 KB
023 Using the AutoFill Command to Copy Formulas-tr.srt	4.6 KB
017 The structure of an Excel Function-tr.srt	4.7 KB
017 The structure of an Excel Function-pt.srt	5.0 KB
023 Using the AutoFill Command to Copy Formulas-en.srt	5.0 KB
017 The structure of an Excel Function-it.srt	5.1 KB
019 Working with the MIN() and MAX() Functions-tr.srt	5.1 KB
023 Using the AutoFill Command to Copy Formulas-pt.srt	5.1 KB
017 The structure of an Excel Function-en.srt	5.2 KB
023 Using the AutoFill Command to Copy Formulas-it.srt	5.3 KB
019 Working with the MIN() and MAX() Functions-pt.srt	5.5 KB
019 Working with the MIN() and MAX() Functions-en.srt	5.6 KB
019 Working with the MIN() and MAX() Functions-it.srt	5.8 KB
018 Working with the SUM() Function-tr.srt	6.8 KB
022 Using the AutoSum Command-tr.srt	7.2 KB
018 Working with the SUM() Function-pt.srt	7.5 KB
018 Working with the SUM() Function-en.srt	7.6 KB
022 Using the AutoSum Command-en.srt	7.7 KB
022 Using the AutoSum Command-pt.srt	7.7 KB
018 Working with the SUM() Function-it.srt	7.8 KB
022 Using the AutoSum Command-it.srt	7.9 KB
021 Working with the COUNT() Function.mp4	7.0 MB
020 Working with the AVERAGE() Function.mp4	8.2 MB
017 The structure of an Excel Function.mp4	8.5 MB
023 Using the AutoFill Command to Copy Formulas.mp4	10.0 MB
019 Working with the MIN() and MAX() Functions.mp4	12.2 MB
018 Working with the SUM() Function.mp4	14.6 MB
022 Using the AutoSum Command.mp4	15.7 MB
/38 Project 6 Working with Excel VBA User Forms/
176 Project 6 Adding VBA Code to the Add Worksheet Button-ja.srt	0.6 KB
175 Project 6 Adding VBA Code to the ComboBox Change Event-ja.srt	0.7 KB
171 Introduction to Project 6 Working with Excel VBA User Forms-ja.srt	0.7 KB
173 Project 6 Adding Controls to the Form-ja.srt	0.8 KB
177 Change Worksheet Name-ja.srt	1.0 KB
179 Project 6 Showing the Form-ja.srt	1.1 KB
172 Project 6 Creating an Excel User Form-ja.srt	1.8 KB
178 Project 6 Adding VBA Code to the Create Report Button-ja.srt	1.9 KB
174 Project 6 Adding VBA Code to the Initialize Event-ja.srt	2.3 KB
171 Introduction to Project 6 Working with Excel VBA User Forms-tr.srt	4.1 KB
171 Introduction to Project 6 Working with Excel VBA User Forms-en.srt	4.5 KB
171 Introduction to Project 6 Working with Excel VBA User Forms-pt.srt	4.6 KB
171 Introduction to Project 6 Working with Excel VBA User Forms-it.srt	4.7 KB
176 Project 6 Adding VBA Code to the Add Worksheet Button-tr.srt	4.9 KB
173 Project 6 Adding Controls to the Form-tr.srt	5.2 KB
179 Project 6 Showing the Form-tr.srt	5.2 KB
176 Project 6 Adding VBA Code to the Add Worksheet Button-en.srt	5.3 KB
176 Project 6 Adding VBA Code to the Add Worksheet Button-pt.srt	5.3 KB
177 Change Worksheet Name-tr.srt	5.6 KB
179 Project 6 Showing the Form-en.srt	5.6 KB
173 Project 6 Adding Controls to the Form-en.srt	5.7 KB
176 Project 6 Adding VBA Code to the Add Worksheet Button-it.srt	5.7 KB
179 Project 6 Showing the Form-pt.srt	5.8 KB
173 Project 6 Adding Controls to the Form-pt.srt	5.8 KB
173 Project 6 Adding Controls to the Form-it.srt	5.8 KB
179 Project 6 Showing the Form-it.srt	5.9 KB
175 Project 6 Adding VBA Code to the ComboBox Change Event-tr.srt	6.1 KB
177 Change Worksheet Name-en.srt	6.1 KB
177 Change Worksheet Name-pt.srt	6.2 KB
177 Change Worksheet Name-it.srt	6.5 KB
175 Project 6 Adding VBA Code to the ComboBox Change Event-en.srt	6.6 KB
175 Project 6 Adding VBA Code to the ComboBox Change Event-pt.srt	6.7 KB
175 Project 6 Adding VBA Code to the ComboBox Change Event-it.srt	7.0 KB
172 Project 6 Creating an Excel User Form-tr.srt	7.4 KB
172 Project 6 Creating an Excel User Form-en.srt	8.1 KB
172 Project 6 Creating an Excel User Form-pt.srt	8.5 KB
172 Project 6 Creating an Excel User Form-it.srt	8.7 KB
174 Project 6 Adding VBA Code to the Initialize Event-tr.srt	11.0 KB
178 Project 6 Adding VBA Code to the Create Report Button-tr.srt	12.1 KB
174 Project 6 Adding VBA Code to the Initialize Event-en.srt	12.3 KB
174 Project 6 Adding VBA Code to the Initialize Event-pt.srt	12.4 KB
174 Project 6 Adding VBA Code to the Initialize Event-it.srt	12.6 KB
178 Project 6 Adding VBA Code to the Create Report Button-en.srt	13.3 KB
178 Project 6 Adding VBA Code to the Create Report Button-pt.srt	13.4 KB
178 Project 6 Adding VBA Code to the Create Report Button-it.srt	13.8 KB
171 QuarterlyReportForm-01.xlsm	25.1 KB
171 Introduction to Project 6 Working with Excel VBA User Forms.mp4	9.2 MB
176 Project 6 Adding VBA Code to the Add Worksheet Button.mp4	10.6 MB
173 Project 6 Adding Controls to the Form.mp4	12.2 MB
177 Change Worksheet Name.mp4	12.3 MB
179 Project 6 Showing the Form.mp4	13.0 MB
172 Project 6 Creating an Excel User Form.mp4	15.8 MB
175 Project 6 Adding VBA Code to the ComboBox Change Event.mp4	25.4 MB
174 Project 6 Adding VBA Code to the Initialize Event.mp4	25.5 MB
178 Project 6 Adding VBA Code to the Create Report Button.mp4	28.8 MB
/35 Project 3 Preparing and Cleaning Up Data with a Little VBA/
158 Project 3 Inserting the Headers-ja.srt	0.6 KB
159 Project 3 Formatting the Headers-ja.srt	0.7 KB
157 Project 3 Preparing to the Use the Macro Recorder-ja.srt	0.7 KB
161 Running the Loop-ja.srt	0.9 KB
156 Introduction to Project 3 Cleaning Up and Formatting Data-ja.srt	1.3 KB
159 Project 3 Formatting the Headers-tr.srt	3.4 KB
160 Project 3 Putting it all Together with a Little VBA-ja.srt	3.6 KB
159 Project 3 Formatting the Headers-en.srt	3.6 KB
159 Project 3 Formatting the Headers-pt.srt	3.7 KB
159 Project 3 Formatting the Headers-it.srt	3.8 KB
157 Project 3 Preparing to the Use the Macro Recorder-tr.srt	4.0 KB
157 Project 3 Preparing to the Use the Macro Recorder-pt.srt	4.3 KB
157 Project 3 Preparing to the Use the Macro Recorder-it.srt	4.3 KB
157 Project 3 Preparing to the Use the Macro Recorder-en.srt	4.4 KB
161 Running the Loop-tr.srt	4.4 KB
156 Introduction to Project 3 Cleaning Up and Formatting Data-tr.srt	4.5 KB
161 Running the Loop-en.srt	4.7 KB
161 Running the Loop-pt.srt	4.8 KB
161 Running the Loop-it.srt	4.9 KB
156 Introduction to Project 3 Cleaning Up and Formatting Data-pt.srt	4.9 KB
156 Introduction to Project 3 Cleaning Up and Formatting Data-it.srt	4.9 KB
156 Introduction to Project 3 Cleaning Up and Formatting Data-en.srt	5.0 KB
158 Project 3 Inserting the Headers-tr.srt	5.5 KB
158 Project 3 Inserting the Headers-en.srt	5.9 KB
158 Project 3 Inserting the Headers-pt.srt	5.9 KB
158 Project 3 Inserting the Headers-it.srt	6.2 KB
160 Project 3 Putting it all Together with a Little VBA-tr.srt	14.2 KB
160 Project 3 Putting it all Together with a Little VBA-en.srt	15.5 KB
160 Project 3 Putting it all Together with a Little VBA-pt.srt	15.7 KB
160 Project 3 Putting it all Together with a Little VBA-it.srt	16.1 KB
159 Project 3 Formatting the Headers.mp4	7.8 MB
157 Project 3 Preparing to the Use the Macro Recorder.mp4	10.0 MB
156 Introduction to Project 3 Cleaning Up and Formatting Data.mp4	11.2 MB
161 Running the Loop.mp4	19.9 MB
158 Project 3 Inserting the Headers.mp4	23.2 MB
160 Project 3 Putting it all Together with a Little VBA.mp4	37.6 MB
/11 Working with Excel Templates/
055 Intro to Excel Templates-ja.srt	0.6 KB
057 Creating a Custom Template-ja.srt	1.2 KB
056 Opening an Existing Template-ja.srt	1.6 KB
055 Intro to Excel Templates-tr.srt	1.9 KB
055 Intro to Excel Templates-it.srt	2.1 KB
055 Intro to Excel Templates-pt.srt	2.1 KB
055 Intro to Excel Templates-en.srt	2.2 KB
057 Creating a Custom Template-tr.srt	6.5 KB
057 Creating a Custom Template-en.srt	7.2 KB
057 Creating a Custom Template-pt.srt	7.2 KB
057 Creating a Custom Template-it.srt	7.3 KB
056 Opening an Existing Template-tr.srt	8.0 KB
056 Opening an Existing Template-pt.srt	8.7 KB
056 Opening an Existing Template-it.srt	8.7 KB
056 Opening an Existing Template-en.srt	8.8 KB
055 Intro to Excel Templates.mp4	5.6 MB
057 Creating a Custom Template.mp4	17.1 MB
056 Opening an Existing Template.mp4	23.4 MB
/29 Automating Repetitive Tasks in Excel with Macros/
127 Activating the Developer Tab in Excel-ja.srt	0.6 KB
130 Creating Buttons to Run Macros-ja.srt	0.9 KB
126 Understanding Excel Macros-ja.srt	1.1 KB
128 Creating a Macro with the Macro Recorder-ja.srt	1.9 KB
129 Editing a Macro with VBA-ja.srt	2.0 KB
127 Activating the Developer Tab in Excel-tr.srt	2.2 KB
127 Activating the Developer Tab in Excel-en.srt	2.2 KB
127 Activating the Developer Tab in Excel-pt.srt	2.4 KB
127 Activating the Developer Tab in Excel-it.srt	2.4 KB
130 Creating Buttons to Run Macros-tr.srt	4.4 KB
130 Creating Buttons to Run Macros-en.srt	4.7 KB
130 Creating Buttons to Run Macros-pt.srt	4.8 KB
130 Creating Buttons to Run Macros-it.srt	4.9 KB
126 Understanding Excel Macros-tr.srt	5.1 KB
126 Understanding Excel Macros-en.srt	5.5 KB
126 Understanding Excel Macros-pt.srt	5.5 KB
126 Understanding Excel Macros-it.srt	5.5 KB
129 Editing a Macro with VBA-tr.srt	7.3 KB
129 Editing a Macro with VBA-pt.srt	7.9 KB
129 Editing a Macro with VBA-en.srt	8.0 KB
129 Editing a Macro with VBA-it.srt	8.3 KB
128 Creating a Macro with the Macro Recorder-tr.srt	10.9 KB
128 Creating a Macro with the Macro Recorder-pt.srt	11.8 KB
128 Creating a Macro with the Macro Recorder-en.srt	11.9 KB
128 Creating a Macro with the Macro Recorder-it.srt	12.1 KB
127 Activating the Developer Tab in Excel.mp4	10.8 MB
130 Creating Buttons to Run Macros.mp4	20.7 MB
126 Understanding Excel Macros.mp4	24.1 MB
129 Editing a Macro with VBA.mp4	26.6 MB
128 Creating a Macro with the Macro Recorder.mp4	48.6 MB
/33 Excel VBA Concepts/
143 Excel VBA Modules-ja.srt	0.7 KB
145 Adding Code to a VBA Procedure-ja.srt	1.1 KB
141 Excel VBA Concepts-ja.srt	1.3 KB
142 The Visual Basic Editor (VBE)-ja.srt	1.5 KB
146 Understanding Excel VBA Variables-ja.srt	1.9 KB
147 Building Logic with an IF Statement-ja.srt	1.9 KB
144 Creating an Excel VBA Procedure-ja.srt	2.4 KB
143 Excel VBA Modules-tr.srt	2.5 KB
143 Excel VBA Modules-en.srt	2.7 KB
143 Excel VBA Modules-pt.srt	2.7 KB
143 Excel VBA Modules-it.srt	2.9 KB
148 Working with Excel VBA Loops to Repeat Blocks of Code-ja.srt	3.7 KB
141 Excel VBA Concepts-tr.srt	4.6 KB
142 The Visual Basic Editor (VBE)-tr.srt	4.7 KB
141 Excel VBA Concepts-en.srt	4.9 KB
141 Excel VBA Concepts-pt.srt	5.0 KB
145 Adding Code to a VBA Procedure-tr.srt	5.1 KB
141 Excel VBA Concepts-it.srt	5.2 KB
142 The Visual Basic Editor (VBE)-en.srt	5.2 KB
142 The Visual Basic Editor (VBE)-pt.srt	5.2 KB
142 The Visual Basic Editor (VBE)-it.srt	5.4 KB
145 Adding Code to a VBA Procedure-en.srt	5.4 KB
145 Adding Code to a VBA Procedure-pt.srt	5.6 KB
145 Adding Code to a VBA Procedure-it.srt	5.7 KB
147 Building Logic with an IF Statement-tr.srt	7.7 KB
147 Building Logic with an IF Statement-pt.srt	8.4 KB
147 Building Logic with an IF Statement-en.srt	8.4 KB
147 Building Logic with an IF Statement-it.srt	8.5 KB
146 Understanding Excel VBA Variables-tr.srt	8.6 KB
146 Understanding Excel VBA Variables-en.srt	9.3 KB
146 Understanding Excel VBA Variables-pt.srt	9.4 KB
146 Understanding Excel VBA Variables-it.srt	9.7 KB
144 Creating an Excel VBA Procedure-tr.srt	10.2 KB
144 Creating an Excel VBA Procedure-en.srt	11.2 KB
144 Creating an Excel VBA Procedure-pt.srt	11.4 KB
144 Creating an Excel VBA Procedure-it.srt	11.5 KB
148 Working with Excel VBA Loops to Repeat Blocks of Code-tr.srt	12.8 KB
148 Working with Excel VBA Loops to Repeat Blocks of Code-pt.srt	13.9 KB
148 Working with Excel VBA Loops to Repeat Blocks of Code-en.srt	14.1 KB
148 Working with Excel VBA Loops to Repeat Blocks of Code-it.srt	14.1 KB
143 Excel VBA Modules.mp4	5.6 MB
142 The Visual Basic Editor (VBE).mp4	9.9 MB
141 Excel VBA Concepts.mp4	23.2 MB
145 Adding Code to a VBA Procedure.mp4	24.3 MB
148 Working with Excel VBA Loops to Repeat Blocks of Code.mp4	29.0 MB
147 Building Logic with an IF Statement.mp4	37.1 MB
146 Understanding Excel VBA Variables.mp4	39.2 MB
144 Creating an Excel VBA Procedure.mp4	45.1 MB
/26 Auditing an Excel Worksheet/
118 Showing Formulas-ja.srt	0.7 KB
116 Tracing Dependents in Excel Formuals-ja.srt	0.9 KB
115 Tracing Precendents in Excel Formulas-ja.srt	1.2 KB
117 Working with the Watch Window-ja.srt	1.3 KB
116 Tracing Dependents in Excel Formuals-tr.srt	3.5 KB
118 Showing Formulas-tr.srt	3.9 KB
116 Tracing Dependents in Excel Formuals-pt.srt	4.0 KB
116 Tracing Dependents in Excel Formuals-en.srt	4.0 KB
116 Tracing Dependents in Excel Formuals-it.srt	4.2 KB
118 Showing Formulas-en.srt	4.4 KB
118 Showing Formulas-pt.srt	4.5 KB
118 Showing Formulas-it.srt	4.6 KB
115 Tracing Precendents in Excel Formulas-tr.srt	5.3 KB
117 Working with the Watch Window-tr.srt	5.6 KB
115 Tracing Precendents in Excel Formulas-pt.srt	5.9 KB
115 Tracing Precendents in Excel Formulas-en.srt	6.0 KB
115 Tracing Precendents in Excel Formulas-it.srt	6.0 KB
117 Working with the Watch Window-en.srt	6.0 KB
117 Working with the Watch Window-pt.srt	6.1 KB
117 Working with the Watch Window-it.srt	6.3 KB
118 Showing Formulas.mp4	13.5 MB
116 Tracing Dependents in Excel Formuals.mp4	14.8 MB
117 Working with the Watch Window.mp4	16.0 MB
115 Tracing Precendents in Excel Formulas.mp4	20.6 MB
/10 Printing an Excel Worksheet/
054 Printing a Specific Range of Cells-ja.srt	0.7 KB
050 Viewing your Document in Print Preview-ja.srt	0.9 KB
052 Working with Page Layout View-ja.srt	1.0 KB
053 Adding Header and Footer Content-ja.srt	1.2 KB
051 Changing the Margins Scaling and Orientation-ja.srt	2.2 KB
050 Viewing your Document in Print Preview-tr.srt	3.2 KB
050 Viewing your Document in Print Preview-en.srt	3.4 KB
050 Viewing your Document in Print Preview-pt.srt	3.4 KB
050 Viewing your Document in Print Preview-it.srt	3.6 KB
054 Printing a Specific Range of Cells-tr.srt	4.2 KB
054 Printing a Specific Range of Cells-en.srt	4.6 KB
054 Printing a Specific Range of Cells-pt.srt	4.7 KB
054 Printing a Specific Range of Cells-it.srt	4.8 KB
052 Working with Page Layout View-tr.srt	5.9 KB
053 Adding Header and Footer Content-tr.srt	6.4 KB
052 Working with Page Layout View-pt.srt	6.4 KB
052 Working with Page Layout View-en.srt	6.5 KB
052 Working with Page Layout View-it.srt	6.6 KB
053 Adding Header and Footer Content-pt.srt	7.2 KB
053 Adding Header and Footer Content-en.srt	7.2 KB
053 Adding Header and Footer Content-it.srt	7.5 KB
051 Changing the Margins Scaling and Orientation-tr.srt	12.8 KB
051 Changing the Margins Scaling and Orientation-pt.srt	14.2 KB
051 Changing the Margins Scaling and Orientation-en.srt	14.3 KB
051 Changing the Margins Scaling and Orientation-it.srt	14.7 KB
050 Viewing your Document in Print Preview.mp4	6.2 MB
054 Printing a Specific Range of Cells.mp4	11.0 MB
052 Working with Page Layout View.mp4	14.6 MB
053 Adding Header and Footer Content.mp4	15.1 MB
051 Changing the Margins Scaling and Orientation.mp4	22.0 MB
/36 Project 4 Using VBA to Automate Excel Formulas/
162 Introduction to Project 4 Automate Excel Formulas-ja.srt	0.7 KB
165 Test the SUM Function-ja.srt	1.2 KB
164 Continue Automate SUM Function-ja.srt	1.5 KB
166 Project 4 Loop the SUM() Function Over Multiple Worksheets-ja.srt	2.1 KB
163 Project 4 Automate the SUM() Function through Code-ja.srt	2.4 KB
162 Introduction to Project 4 Automate Excel Formulas-tr.srt	3.0 KB
162 Introduction to Project 4 Automate Excel Formulas-pt.srt	3.2 KB
162 Introduction to Project 4 Automate Excel Formulas-en.srt	3.3 KB
162 Introduction to Project 4 Automate Excel Formulas-it.srt	3.4 KB
165 Test the SUM Function-tr.srt	5.1 KB
165 Test the SUM Function-en.srt	5.6 KB
165 Test the SUM Function-pt.srt	5.7 KB
165 Test the SUM Function-it.srt	5.9 KB
164 Continue Automate SUM Function-tr.srt	7.7 KB
164 Continue Automate SUM Function-pt.srt	8.3 KB
166 Project 4 Loop the SUM() Function Over Multiple Worksheets-tr.srt	8.3 KB
164 Continue Automate SUM Function-en.srt	8.4 KB
164 Continue Automate SUM Function-it.srt	8.5 KB
166 Project 4 Loop the SUM() Function Over Multiple Worksheets-en.srt	9.1 KB
166 Project 4 Loop the SUM() Function Over Multiple Worksheets-pt.srt	9.1 KB
166 Project 4 Loop the SUM() Function Over Multiple Worksheets-it.srt	9.4 KB
163 Project 4 Automate the SUM() Function through Code-tr.srt	10.5 KB
163 Project 4 Automate the SUM() Function through Code-en.srt	11.3 KB
163 Project 4 Automate the SUM() Function through Code-pt.srt	11.4 KB
163 Project 4 Automate the SUM() Function through Code-it.srt	11.7 KB
163 AutomateSumFunction.xlsx	20.3 KB
162 Introduction to Project 4 Automate Excel Formulas.mp4	7.8 MB
165 Test the SUM Function.mp4	13.0 MB
164 Continue Automate SUM Function.mp4	18.4 MB
166 Project 4 Loop the SUM() Function Over Multiple Worksheets.mp4	21.0 MB
163 Project 4 Automate the SUM() Function through Code.mp4	26.8 MB
/25 Working with Excels Text Based Functions/
114 Using Excels CONCATENATE() Function-ja.srt	0.7 KB
111 Using Excels LEFT() RIGHT() and MID() Functions-ja.srt	2.1 KB
112 Using Excels LEN() Function-ja.srt	2.6 KB
114 Using Excels CONCATENATE() Function-tr.srt	4.0 KB
114 Using Excels CONCATENATE() Function-it.srt	4.3 KB
114 Using Excels CONCATENATE() Function-pt.srt	4.3 KB
113 Using Excels SEARCH() Function-ja.srt	4.3 KB
114 Using Excels CONCATENATE() Function-en.srt	4.4 KB
112 Using Excels LEN() Function-tr.srt	8.1 KB
111 Using Excels LEFT() RIGHT() and MID() Functions-tr.srt	8.2 KB
112 Using Excels LEN() Function-pt.srt	8.9 KB
112 Using Excels LEN() Function-en.srt	9.1 KB
112 Using Excels LEN() Function-it.srt	9.1 KB
111 Using Excels LEFT() RIGHT() and MID() Functions-pt.srt	9.3 KB
111 Using Excels LEFT() RIGHT() and MID() Functions-en.srt	9.3 KB
111 Using Excels LEFT() RIGHT() and MID() Functions-it.srt	9.3 KB
113 Using Excels SEARCH() Function-tr.srt	16.5 KB
113 Using Excels SEARCH() Function-pt.srt	18.2 KB
113 Using Excels SEARCH() Function-it.srt	18.3 KB
113 Using Excels SEARCH() Function-en.srt	18.3 KB
114 Using Excels CONCATENATE() Function.mp4	12.4 MB
111 Using Excels LEFT() RIGHT() and MID() Functions.mp4	31.8 MB
112 Using Excels LEN() Function.mp4	39.0 MB
113 Using Excels SEARCH() Function.mp4	43.9 MB
/37 Project 5 Bringing it All Together and a Weekly Report/
170 Project 5 - Running the Final Report Procedure-ja.srt	0.8 KB
167 Introduction to Project 5 Creating the Final Report-ja.srt	0.9 KB
169 Project 5 - Copying and Pasting Data with VBA-ja.srt	2.3 KB
168 Project 5 Creating the Final Report Loop-ja.srt	2.6 KB
170 Project 5 - Running the Final Report Procedure-tr.srt	4.1 KB
170 Project 5 - Running the Final Report Procedure-en.srt	4.6 KB
167 Introduction to Project 5 Creating the Final Report-tr.srt	4.6 KB
170 Project 5 - Running the Final Report Procedure-pt.srt	4.7 KB
170 Project 5 - Running the Final Report Procedure-it.srt	4.8 KB
167 Introduction to Project 5 Creating the Final Report-pt.srt	5.0 KB
167 Introduction to Project 5 Creating the Final Report-it.srt	5.2 KB
167 Introduction to Project 5 Creating the Final Report-en.srt	5.2 KB
168 Project 5 Creating the Final Report Loop-tr.srt	11.4 KB
168 Project 5 Creating the Final Report Loop-pt.srt	12.5 KB
169 Project 5 - Copying and Pasting Data with VBA-tr.srt	12.6 KB
168 Project 5 Creating the Final Report Loop-en.srt	12.7 KB
168 Project 5 Creating the Final Report Loop-it.srt	12.9 KB
169 Project 5 - Copying and Pasting Data with VBA-pt.srt	13.6 KB
169 Project 5 - Copying and Pasting Data with VBA-en.srt	13.8 KB
169 Project 5 - Copying and Pasting Data with VBA-it.srt	14.0 KB
167 Introduction to Project 5 Creating the Final Report.mp4	11.5 MB
170 Project 5 - Running the Final Report Procedure.mp4	20.9 MB
168 Project 5 Creating the Final Report Loop.mp4	49.6 MB
169 Project 5 - Copying and Pasting Data with VBA.mp4	57.4 MB
/14 Working with an Excel List/
061 Sorting a List Using Single Level Sort-ja.srt	0.8 KB
067 Using Conditional Formatting to Find Duplicates-ja.srt	1.0 KB
068 Removing Duplicates-ja.srt	1.0 KB
064 Filter an Excel List Using the AutoFilter Tool-ja.srt	1.2 KB
063 Using Custom Sorts in an Excel List-ja.srt	1.4 KB
062 Sorting a List Using Multi-Level Sorts-ja.srt	1.4 KB
065 Creating Subtotals in a List-ja.srt	1.5 KB
060 Understanding Excel List Structure-ja.srt	1.7 KB
066 Format a List as a Table-ja.srt	1.9 KB
062 Sorting a List Using Multi-Level Sorts-tr.srt	5.0 KB
067 Using Conditional Formatting to Find Duplicates-tr.srt	5.0 KB
061 Sorting a List Using Single Level Sort-tr.srt	5.2 KB
062 Sorting a List Using Multi-Level Sorts-en.srt	5.4 KB
062 Sorting a List Using Multi-Level Sorts-it.srt	5.5 KB
068 Removing Duplicates-tr.srt	5.5 KB
062 Sorting a List Using Multi-Level Sorts-pt.srt	5.5 KB
067 Using Conditional Formatting to Find Duplicates-it.srt	5.6 KB
067 Using Conditional Formatting to Find Duplicates-en.srt	5.6 KB
067 Using Conditional Formatting to Find Duplicates-pt.srt	5.7 KB
061 Sorting a List Using Single Level Sort-en.srt	5.7 KB
061 Sorting a List Using Single Level Sort-it.srt	5.8 KB
061 Sorting a List Using Single Level Sort-pt.srt	5.9 KB
068 Removing Duplicates-pt.srt	6.1 KB
068 Removing Duplicates-en.srt	6.2 KB
068 Removing Duplicates-it.srt	6.2 KB
063 Using Custom Sorts in an Excel List-tr.srt	6.4 KB
063 Using Custom Sorts in an Excel List-en.srt	6.8 KB
063 Using Custom Sorts in an Excel List-pt.srt	7.0 KB
064 Filter an Excel List Using the AutoFilter Tool-tr.srt	7.0 KB
063 Using Custom Sorts in an Excel List-it.srt	7.1 KB
064 Filter an Excel List Using the AutoFilter Tool-en.srt	7.5 KB
064 Filter an Excel List Using the AutoFilter Tool-pt.srt	7.7 KB
064 Filter an Excel List Using the AutoFilter Tool-it.srt	7.7 KB
060 Understanding Excel List Structure-tr.srt	8.0 KB
060 Understanding Excel List Structure-en.srt	8.7 KB
060 Understanding Excel List Structure-it.srt	8.8 KB
060 Understanding Excel List Structure-pt.srt	8.8 KB
065 Creating Subtotals in a List-tr.srt	9.7 KB
065 Creating Subtotals in a List-pt.srt	10.6 KB
065 Creating Subtotals in a List-en.srt	10.6 KB
065 Creating Subtotals in a List-it.srt	10.7 KB
066 Format a List as a Table-tr.srt	11.0 KB
066 Format a List as a Table-en.srt	11.9 KB
066 Format a List as a Table-pt.srt	12.1 KB
066 Format a List as a Table-it.srt	12.2 KB
061 Sorting a List Using Single Level Sort.mp4	21.3 MB
062 Sorting a List Using Multi-Level Sorts.mp4	21.4 MB
063 Using Custom Sorts in an Excel List.mp4	21.5 MB
064 Filter an Excel List Using the AutoFilter Tool.mp4	21.8 MB
067 Using Conditional Formatting to Find Duplicates.mp4	23.9 MB
068 Removing Duplicates.mp4	24.0 MB
060 Understanding Excel List Structure.mp4	30.8 MB
065 Creating Subtotals in a List.mp4	41.6 MB
066 Format a List as a Table.mp4	44.8 MB
/20 Working with Large Sets of Excel Data/
095 Using the Freeze Panes Tool-ja.srt	0.8 KB
098 Linking Worksheets (3D Formulas)-ja.srt	1.5 KB
096 Grouping Data (Columns andor Rows)-ja.srt	1.5 KB
099 Consolidating Data from Multiple Worksheets-ja.srt	1.8 KB
097 Print Options for Large Sets of Data-ja.srt	2.4 KB
098 Linking Worksheets (3D Formulas)-tr.srt	5.2 KB
095 Using the Freeze Panes Tool-tr.srt	5.2 KB
098 Linking Worksheets (3D Formulas)-pt.srt	5.6 KB
098 Linking Worksheets (3D Formulas)-en.srt	5.6 KB
096 Grouping Data (Columns andor Rows)-tr.srt	5.7 KB
095 Using the Freeze Panes Tool-en.srt	5.7 KB
095 Using the Freeze Panes Tool-pt.srt	5.8 KB
098 Linking Worksheets (3D Formulas)-it.srt	5.8 KB
095 Using the Freeze Panes Tool-it.srt	5.9 KB
096 Grouping Data (Columns andor Rows)-en.srt	6.1 KB
096 Grouping Data (Columns andor Rows)-pt.srt	6.4 KB
096 Grouping Data (Columns andor Rows)-it.srt	6.5 KB
099 Consolidating Data from Multiple Worksheets-tr.srt	7.3 KB
099 Consolidating Data from Multiple Worksheets-en.srt	8.0 KB
099 Consolidating Data from Multiple Worksheets-pt.srt	8.1 KB
099 Consolidating Data from Multiple Worksheets-it.srt	8.2 KB
097 Print Options for Large Sets of Data-tr.srt	10.6 KB
097 Print Options for Large Sets of Data-en.srt	11.7 KB
097 Print Options for Large Sets of Data-pt.srt	11.9 KB
097 Print Options for Large Sets of Data-it.srt	12.1 KB
098 Linking Worksheets (3D Formulas).mp4	12.6 MB
099 Consolidating Data from Multiple Worksheets.mp4	19.0 MB
095 Using the Freeze Panes Tool.mp4	23.5 MB
096 Grouping Data (Columns andor Rows).mp4	28.9 MB
097 Print Options for Large Sets of Data.mp4	43.0 MB
/34 Project 2 Moving Beyond the Basics and into VBA/
149 Introduction to Project 2 Interacting with the User-ja.srt	0.8 KB
155 Other Practical Uses of Message and Input Boxes-ja.srt	1.0 KB
150 Project 2 Breaking Down the VBA Code-ja.srt	1.4 KB
153 Project 2 Building Logic into Your Macros-ja.srt	1.4 KB
151 Project 2 Prompting the User for Information-ja.srt	1.7 KB
152 Continue Excel VBA InputBox-ja.srt	1.9 KB
154 Project 2 Alerting the User of Errors-ja.srt	3.3 KB
149 Introduction to Project 2 Interacting with the User-tr.srt	3.7 KB
149 Introduction to Project 2 Interacting with the User-en.srt	4.1 KB
149 Introduction to Project 2 Interacting with the User-pt.srt	4.1 KB
149 Introduction to Project 2 Interacting with the User-it.srt	4.1 KB
150 Project 2 Breaking Down the VBA Code-tr.srt	4.5 KB
155 Other Practical Uses of Message and Input Boxes-tr.srt	4.6 KB
155 Other Practical Uses of Message and Input Boxes-en.srt	4.9 KB
150 Project 2 Breaking Down the VBA Code-en.srt	5.0 KB
150 Project 2 Breaking Down the VBA Code-pt.srt	5.1 KB
155 Other Practical Uses of Message and Input Boxes-pt.srt	5.1 KB
150 Project 2 Breaking Down the VBA Code-it.srt	5.1 KB
155 Other Practical Uses of Message and Input Boxes-it.srt	5.3 KB
153 Project 2 Building Logic into Your Macros-tr.srt	5.6 KB
153 Project 2 Building Logic into Your Macros-en.srt	6.0 KB
153 Project 2 Building Logic into Your Macros-pt.srt	6.3 KB
153 Project 2 Building Logic into Your Macros-it.srt	6.3 KB
152 Continue Excel VBA InputBox-tr.srt	8.8 KB
151 Project 2 Prompting the User for Information-tr.srt	9.1 KB
152 Continue Excel VBA InputBox-pt.srt	9.4 KB
152 Continue Excel VBA InputBox-en.srt	9.4 KB
152 Continue Excel VBA InputBox-it.srt	9.6 KB
151 Project 2 Prompting the User for Information-en.srt	9.7 KB
151 Project 2 Prompting the User for Information-pt.srt	9.9 KB
151 Project 2 Prompting the User for Information-it.srt	10.0 KB
154 Project 2 Alerting the User of Errors-tr.srt	13.4 KB
154 Project 2 Alerting the User of Errors-en.srt	14.3 KB
154 Project 2 Alerting the User of Errors-pt.srt	14.6 KB
154 Project 2 Alerting the User of Errors-it.srt	14.6 KB
150 SortingRecords.xlsm	17.1 KB
150 Project 2 Breaking Down the VBA Code.mp4	12.6 MB
153 Project 2 Building Logic into Your Macros.mp4	15.5 MB
149 Introduction to Project 2 Interacting with the User.mp4	19.0 MB
151 Project 2 Prompting the User for Information.mp4	21.6 MB
155 Other Practical Uses of Message and Input Boxes.mp4	25.6 MB
154 Project 2 Alerting the User of Errors.mp4	35.4 MB
152 Continue Excel VBA InputBox.mp4	40.8 MB
/27 Protecting Excel Worksheets and Workbooks/
120 Protecting the Structure of a Workbook-ja.srt	0.9 KB
121 Adding a Workbook Password-ja.srt	1.0 KB
119 Protecting Specific Cells in a Worksheet-ja.srt	1.6 KB
121 Adding a Workbook Password-tr.srt	4.1 KB
121 Adding a Workbook Password-pt.srt	4.5 KB
121 Adding a Workbook Password-en.srt	4.6 KB
121 Adding a Workbook Password-it.srt	4.6 KB
120 Protecting the Structure of a Workbook-tr.srt	5.4 KB
120 Protecting the Structure of a Workbook-en.srt	5.9 KB
120 Protecting the Structure of a Workbook-pt.srt	6.0 KB
120 Protecting the Structure of a Workbook-it.srt	6.2 KB
119 Protecting Specific Cells in a Worksheet-tr.srt	10.7 KB
119 Protecting Specific Cells in a Worksheet-pt.srt	11.5 KB
119 Protecting Specific Cells in a Worksheet-it.srt	11.8 KB
119 Protecting Specific Cells in a Worksheet-en.srt	11.8 KB
120 Protecting the Structure of a Workbook.mp4	12.9 MB
121 Adding a Workbook Password.mp4	15.0 MB
119 Protecting Specific Cells in a Worksheet.mp4	41.5 MB
/15 Excel List Functions/
071 Excel Function DCOUNT()-ja.srt	0.9 KB
070 Excel Function DAVERAGE()-ja.srt	1.0 KB
069 Excel Function DSUM()-ja.srt	1.8 KB
072 Excel Function SUBTOTAL()-ja.srt	1.8 KB
070 Excel Function DAVERAGE()-tr.srt	3.8 KB
070 Excel Function DAVERAGE()-en.srt	4.1 KB
070 Excel Function DAVERAGE()-pt.srt	4.1 KB
071 Excel Function DCOUNT()-tr.srt	4.1 KB
070 Excel Function DAVERAGE()-it.srt	4.2 KB
071 Excel Function DCOUNT()-pt.srt	4.5 KB
071 Excel Function DCOUNT()-en.srt	4.6 KB
071 Excel Function DCOUNT()-it.srt	4.8 KB
072 Excel Function SUBTOTAL()-tr.srt	8.7 KB
069 Excel Function DSUM()-tr.srt	8.9 KB
072 Excel Function SUBTOTAL()-pt.srt	9.3 KB
069 Excel Function DSUM()-pt.srt	9.5 KB
072 Excel Function SUBTOTAL()-en.srt	9.5 KB
069 Excel Function DSUM()-en.srt	9.6 KB
072 Excel Function SUBTOTAL()-it.srt	9.6 KB
069 Excel Function DSUM()-it.srt	9.7 KB
070 Excel Function DAVERAGE().mp4	18.4 MB
071 Excel Function DCOUNT().mp4	20.2 MB
069 Excel Function DSUM().mp4	41.5 MB
072 Excel Function SUBTOTAL().mp4	42.6 MB
/08 Inserting Images and Shapes into an Excel Worksheet/
041 Inserting Excel Shapes-ja.srt	1.0 KB
042 Formatting Excel Shapes-ja.srt	1.1 KB
040 Inserting Images-ja.srt	1.6 KB
043 Working with Excel SmartArt-ja.srt	1.9 KB
041 Inserting Excel Shapes-tr.srt	5.3 KB
041 Inserting Excel Shapes-en.srt	5.9 KB
041 Inserting Excel Shapes-pt.srt	6.0 KB
041 Inserting Excel Shapes-it.srt	6.2 KB
040 Inserting Images-tr.srt	6.3 KB
040 Inserting Images-pt.srt	6.8 KB
040 Inserting Images-en.srt	6.8 KB
040 Inserting Images-it.srt	6.9 KB
042 Formatting Excel Shapes-tr.srt	7.0 KB
042 Formatting Excel Shapes-en.srt	7.8 KB
042 Formatting Excel Shapes-pt.srt	7.9 KB
042 Formatting Excel Shapes-it.srt	8.0 KB
043 Working with Excel SmartArt-tr.srt	8.6 KB
043 Working with Excel SmartArt-en.srt	9.8 KB
043 Working with Excel SmartArt-pt.srt	9.8 KB
043 Working with Excel SmartArt-it.srt	10.0 KB
041 Inserting Excel Shapes.mp4	13.9 MB
040 Inserting Images.mp4	14.9 MB
042 Formatting Excel Shapes.mp4	16.1 MB
043 Working with Excel SmartArt.mp4	20.2 MB
/18 Excel PivotTables/
084 Formatting PivotTable Data-ja.srt	1.0 KB
086 Creating PivotCharts-ja.srt	1.0 KB
088 Filtering with the Slicer Tool-ja.srt	1.1 KB
085 Drilling Down into PivotTable Data-ja.srt	1.1 KB
080 Understanding Excel PivotTables-ja.srt	1.2 KB
087 Filtering PivotTable Data-ja.srt	1.3 KB
081 Creating an Excel PivotTable-ja.srt	1.6 KB
082 Modifying Excel PivotTable Calculations-ja.srt	1.7 KB
083 Grouping PivotTable Data-ja.srt	1.9 KB
085 Drilling Down into PivotTable Data-tr.srt	4.6 KB
088 Filtering with the Slicer Tool-tr.srt	4.8 KB
080 Understanding Excel PivotTables-tr.srt	4.9 KB
085 Drilling Down into PivotTable Data-pt.srt	5.0 KB
085 Drilling Down into PivotTable Data-it.srt	5.0 KB
085 Drilling Down into PivotTable Data-en.srt	5.0 KB
088 Filtering with the Slicer Tool-en.srt	5.1 KB
088 Filtering with the Slicer Tool-pt.srt	5.1 KB
088 Filtering with the Slicer Tool-it.srt	5.3 KB
087 Filtering PivotTable Data-tr.srt	5.4 KB
080 Understanding Excel PivotTables-pt.srt	5.4 KB
080 Understanding Excel PivotTables-en.srt	5.5 KB
080 Understanding Excel PivotTables-it.srt	5.6 KB
087 Filtering PivotTable Data-en.srt	5.9 KB
087 Filtering PivotTable Data-pt.srt	6.0 KB
087 Filtering PivotTable Data-it.srt	6.1 KB
086 Creating PivotCharts-tr.srt	6.2 KB
084 Formatting PivotTable Data-tr.srt	6.5 KB
083 Grouping PivotTable Data-tr.srt	6.6 KB
086 Creating PivotCharts-pt.srt	6.9 KB
086 Creating PivotCharts-en.srt	6.9 KB
086 Creating PivotCharts-it.srt	7.0 KB
084 Formatting PivotTable Data-en.srt	7.2 KB
084 Formatting PivotTable Data-pt.srt	7.2 KB
083 Grouping PivotTable Data-pt.srt	7.3 KB
083 Grouping PivotTable Data-en.srt	7.3 KB
083 Grouping PivotTable Data-it.srt	7.3 KB
084 Formatting PivotTable Data-it.srt	7.5 KB
081 Creating an Excel PivotTable-tr.srt	8.7 KB
082 Modifying Excel PivotTable Calculations-tr.srt	9.4 KB
081 Creating an Excel PivotTable-pt.srt	9.5 KB
081 Creating an Excel PivotTable-en.srt	9.5 KB
081 Creating an Excel PivotTable-it.srt	9.7 KB
082 Modifying Excel PivotTable Calculations-pt.srt	10.2 KB
082 Modifying Excel PivotTable Calculations-en.srt	10.4 KB
082 Modifying Excel PivotTable Calculations-it.srt	10.6 KB
083 Grouping PivotTable Data.mp4	18.0 MB
087 Filtering PivotTable Data.mp4	18.0 MB
088 Filtering with the Slicer Tool.mp4	18.9 MB
084 Formatting PivotTable Data.mp4	20.5 MB
085 Drilling Down into PivotTable Data.mp4	22.1 MB
086 Creating PivotCharts.mp4	23.6 MB
080 Understanding Excel PivotTables.mp4	24.4 MB
082 Modifying Excel PivotTable Calculations.mp4	27.8 MB
081 Creating an Excel PivotTable.mp4	31.5 MB
/16 Excel Data Validation/
075 Adding a Custom Validation Error-ja.srt	1.0 KB
076 Dynamic Formulas by Using Validation Techniques-ja.srt	1.2 KB
073 Understanding the Need for Data Validation-ja.srt	1.3 KB
074 Creating a Validation List-ja.srt	1.7 KB
076 Dynamic Formulas by Using Validation Techniques-tr.srt	5.4 KB
076 Dynamic Formulas by Using Validation Techniques-pt.srt	5.9 KB
075 Adding a Custom Validation Error-tr.srt	6.0 KB
076 Dynamic Formulas by Using Validation Techniques-en.srt	6.1 KB
076 Dynamic Formulas by Using Validation Techniques-it.srt	6.2 KB
075 Adding a Custom Validation Error-en.srt	6.5 KB
075 Adding a Custom Validation Error-pt.srt	6.7 KB
075 Adding a Custom Validation Error-it.srt	6.8 KB
073 Understanding the Need for Data Validation-tr.srt	6.9 KB
073 Understanding the Need for Data Validation-en.srt	7.6 KB
074 Creating a Validation List-tr.srt	7.6 KB
073 Understanding the Need for Data Validation-pt.srt	7.6 KB
073 Understanding the Need for Data Validation-it.srt	7.8 KB
074 Creating a Validation List-en.srt	8.3 KB
074 Creating a Validation List-pt.srt	8.4 KB
074 Creating a Validation List-it.srt	8.4 KB
075 Adding a Custom Validation Error.mp4	21.6 MB
076 Dynamic Formulas by Using Validation Techniques.mp4	23.6 MB
073 Understanding the Need for Data Validation.mp4	23.8 MB
074 Creating a Validation List.mp4	27.2 MB
/04 Entering and Editing Text and Formulas/
016 Understanding the Order of Operation-ja.srt	1.0 KB
013 Working with Cell References-ja.srt	1.3 KB
011 Working with Numeric Data in Excel-ja.srt	1.4 KB
010 Entering Text to Create Spreadsheet Titles-ja.srt	2.0 KB
012 Entering Date Values in Excel-ja.srt	2.2 KB
014 Creating Basic Formulas in Excel-ja.srt	2.5 KB
015 Relative Versus Absolute Cell References in Formulas-ja.srt	3.8 KB
016 Understanding the Order of Operation-tr.srt	4.4 KB
011 Working with Numeric Data in Excel-tr.srt	4.6 KB
016 Understanding the Order of Operation-pt.srt	4.9 KB
016 Understanding the Order of Operation-en.srt	4.9 KB
013 Working with Cell References-tr.srt	5.1 KB
011 Working with Numeric Data in Excel-pt.srt	5.1 KB
016 Understanding the Order of Operation-it.srt	5.1 KB
011 Working with Numeric Data in Excel-en.srt	5.2 KB
011 Working with Numeric Data in Excel-it.srt	5.2 KB
013 Working with Cell References-pt.srt	5.6 KB
013 Working with Cell References-en.srt	5.6 KB
013 Working with Cell References-it.srt	5.7 KB
012 Entering Date Values in Excel-tr.srt	6.4 KB
012 Entering Date Values in Excel-pt.srt	7.0 KB
012 Entering Date Values in Excel-en.srt	7.0 KB
012 Entering Date Values in Excel-it.srt	7.2 KB
010 Entering Text to Create Spreadsheet Titles-tr.srt	7.7 KB
010 Entering Text to Create Spreadsheet Titles-en.srt	8.5 KB
010 Entering Text to Create Spreadsheet Titles-pt.srt	8.5 KB
010 Entering Text to Create Spreadsheet Titles-it.srt	8.6 KB
014 Creating Basic Formulas in Excel-tr.srt	9.0 KB
014 Creating Basic Formulas in Excel-pt.srt	9.9 KB
014 Creating Basic Formulas in Excel-en.srt	10.0 KB
014 Creating Basic Formulas in Excel-it.srt	10.1 KB
015 Relative Versus Absolute Cell References in Formulas-tr.srt	13.4 KB
015 Relative Versus Absolute Cell References in Formulas-en.srt	14.7 KB
015 Relative Versus Absolute Cell References in Formulas-pt.srt	14.7 KB
015 Relative Versus Absolute Cell References in Formulas-it.srt	15.2 KB
016 Understanding the Order of Operation.mp4	6.8 MB
011 Working with Numeric Data in Excel.mp4	8.6 MB
013 Working with Cell References.mp4	10.1 MB
010 Entering Text to Create Spreadsheet Titles.mp4	12.3 MB
012 Entering Date Values in Excel.mp4	12.3 MB
014 Creating Basic Formulas in Excel.mp4	18.4 MB
015 Relative Versus Absolute Cell References in Formulas.mp4	30.4 MB
/19 Working with Excels PowerPivot Tools/
090 Activating the Excel PowerPivot AddIn-ja.srt	1.1 KB
092 Creating PivotTables based on Data Models-ja.srt	1.2 KB
093 PowerPivot Calculated Fields-ja.srt	1.3 KB
089 Why PowerPivot-ja.srt	1.9 KB
091 Creating Data Models with PowerPivot-ja.srt	2.3 KB
094 PowerPivot KPIs-ja.srt	2.7 KB
090 Activating the Excel PowerPivot AddIn-tr.srt	3.2 KB
090 Activating the Excel PowerPivot AddIn-pt.srt	3.4 KB
090 Activating the Excel PowerPivot AddIn-en.srt	3.5 KB
090 Activating the Excel PowerPivot AddIn-it.srt	3.6 KB
093 PowerPivot Calculated Fields-tr.srt	4.9 KB
092 Creating PivotTables based on Data Models-tr.srt	5.1 KB
093 PowerPivot Calculated Fields-pt.srt	5.4 KB
093 PowerPivot Calculated Fields-en.srt	5.5 KB
093 PowerPivot Calculated Fields-it.srt	5.6 KB
092 Creating PivotTables based on Data Models-en.srt	5.8 KB
092 Creating PivotTables based on Data Models-pt.srt	5.8 KB
092 Creating PivotTables based on Data Models-it.srt	5.8 KB
089 Why PowerPivot-tr.srt	6.2 KB
089 Why PowerPivot-en.srt	6.7 KB
089 Why PowerPivot-pt.srt	6.8 KB
089 Why PowerPivot-it.srt	6.8 KB
091 Creating Data Models with PowerPivot-tr.srt	8.8 KB
094 PowerPivot KPIs-tr.srt	9.3 KB
091 Creating Data Models with PowerPivot-en.srt	9.7 KB
091 Creating Data Models with PowerPivot-pt.srt	10.0 KB
091 Creating Data Models with PowerPivot-it.srt	10.1 KB
094 PowerPivot KPIs-pt.srt	10.3 KB
094 PowerPivot KPIs-en.srt	10.4 KB
094 PowerPivot KPIs-it.srt	10.6 KB
090 Activating the Excel PowerPivot AddIn.mp4	8.5 MB
092 Creating PivotTables based on Data Models.mp4	21.4 MB
093 PowerPivot Calculated Fields.mp4	25.2 MB
089 Why PowerPivot.mp4	34.2 MB
094 PowerPivot KPIs.mp4	37.6 MB
091 Creating Data Models with PowerPivot.mp4	48.1 MB
/31 Microsoft Excel Macros and VBA Course Introduction/
134 Course Exercise Files - Download these First.html	1.3 KB
133 Understanding the Why and How Behind Excel Macros-ja.srt	1.8 KB
132 Welcome to the Course-ja.srt	2.9 KB
133 Understanding the Why and How Behind Excel Macros-tr.srt	7.5 KB
133 Understanding the Why and How Behind Excel Macros-en.srt	7.8 KB
133 Understanding the Why and How Behind Excel Macros-it.srt	8.0 KB
133 Understanding the Why and How Behind Excel Macros-pt.srt	8.0 KB
132 Welcome to the Course-tr.srt	8.1 KB
132 Welcome to the Course-pt.srt	8.8 KB
132 Welcome to the Course-en.srt	8.8 KB
132 Welcome to the Course-it.srt	8.9 KB
134 SortingRecords.xlsx	16.9 KB
134 InsertingAndFormattingText.xlsx	17.8 KB
134 AutomateFormulas.xlsx	19.3 KB
134 AutomateSumFunction.xlsx	20.3 KB
134 CleaningUpData.xlsx	21.3 KB
134 SortingRecords.xlsm	22.3 KB
134 QuarterlyReport.xlsm	27.1 KB
134 QuarterlyReportForm-01.xlsm	30.4 KB
133 Understanding the Why and How Behind Excel Macros.mp4	15.6 MB
132 Welcome to the Course.mp4	33.8 MB
/22 Microsoft Excel 103 Course Introduction/
101 Course Excerise Files - Download this Excel File First.html	1.3 KB
101 Excel103-AdvancedExercises.xlsx	64.5 KB
/17 Importing and Exporting Data/
079 Exporting Data to a Text File-ja.srt	1.4 KB
077 Importing Data from Text Files-ja.srt	1.8 KB
078 Importing Data from Microsoft Access-ja.srt	1.9 KB
078 Importing Data from Microsoft Access-tr.srt	5.7 KB
079 Exporting Data to a Text File-tr.srt	5.8 KB
078 Importing Data from Microsoft Access-en.srt	6.3 KB
079 Exporting Data to a Text File-en.srt	6.3 KB
078 Importing Data from Microsoft Access-it.srt	6.4 KB
078 Importing Data from Microsoft Access-pt.srt	6.5 KB
079 Exporting Data to a Text File-pt.srt	6.5 KB
079 Exporting Data to a Text File-it.srt	6.7 KB
077 Importing Data from Text Files-tr.srt	7.8 KB
077 Importing Data from Text Files-en.srt	8.4 KB
077 Importing Data from Text Files-pt.srt	8.6 KB
077 Importing Data from Text Files-it.srt	8.7 KB
078 Importing Data from Microsoft Access.mp4	17.7 MB
077 Importing Data from Text Files.mp4	20.0 MB
079 Exporting Data to a Text File.mp4	23.6 MB
/23 Working with Excels Conditional Functions/
105 Using Excels COUNTIF() Function-ja.srt	1.4 KB
102 Working with Excel Name Ranges-ja.srt	1.6 KB
106 Using Excels SUMIF() Function-ja.srt	1.7 KB
103 Using Excels IF() Function-ja.srt	2.2 KB
107 Using Excels IFERROR() Function-ja.srt	2.6 KB
104 Nesting Functions-ja.srt	2.8 KB
105 Using Excels COUNTIF() Function-tr.srt	5.0 KB
105 Using Excels COUNTIF() Function-pt.srt	5.6 KB
105 Using Excels COUNTIF() Function-en.srt	5.6 KB
105 Using Excels COUNTIF() Function-it.srt	5.7 KB
102 Working with Excel Name Ranges-tr.srt	6.9 KB
102 Working with Excel Name Ranges-en.srt	7.5 KB
106 Using Excels SUMIF() Function-tr.srt	7.5 KB
102 Working with Excel Name Ranges-pt.srt	7.6 KB
107 Using Excels IFERROR() Function-tr.srt	7.7 KB
102 Working with Excel Name Ranges-it.srt	7.8 KB
106 Using Excels SUMIF() Function-pt.srt	8.3 KB
103 Using Excels IF() Function-tr.srt	8.3 KB
106 Using Excels SUMIF() Function-it.srt	8.5 KB
106 Using Excels SUMIF() Function-en.srt	8.5 KB
107 Using Excels IFERROR() Function-pt.srt	8.6 KB
107 Using Excels IFERROR() Function-en.srt	8.7 KB
107 Using Excels IFERROR() Function-it.srt	8.8 KB
103 Using Excels IF() Function-pt.srt	9.1 KB
103 Using Excels IF() Function-it.srt	9.2 KB
103 Using Excels IF() Function-en.srt	9.2 KB
104 Nesting Functions-tr.srt	9.9 KB
104 Nesting Functions-pt.srt	10.4 KB
104 Nesting Functions-it.srt	10.8 KB
104 Nesting Functions-en.srt	10.8 KB
105 Using Excels COUNTIF() Function.mp4	20.0 MB
102 Working with Excel Name Ranges.mp4	23.4 MB
107 Using Excels IFERROR() Function.mp4	24.1 MB
103 Using Excels IF() Function.mp4	28.2 MB
106 Using Excels SUMIF() Function.mp4	30.6 MB
104 Nesting Functions.mp4	36.6 MB
/24 Working with Excels Lookup Functions/
109 Using Excels HLOOKUP() Function-ja.srt	1.7 KB
108 Using Excels VLOOKUP() Function-ja.srt	2.8 KB
110 Using Excels INDEX() and MATCH() Functions-ja.srt	4.6 KB
109 Using Excels HLOOKUP() Function-tr.srt	5.5 KB
109 Using Excels HLOOKUP() Function-pt.srt	6.0 KB
109 Using Excels HLOOKUP() Function-en.srt	6.1 KB
109 Using Excels HLOOKUP() Function-it.srt	6.2 KB
108 Using Excels VLOOKUP() Function-tr.srt	10.1 KB
108 Using Excels VLOOKUP() Function-en.srt	11.5 KB
108 Using Excels VLOOKUP() Function-pt.srt	11.5 KB
108 Using Excels VLOOKUP() Function-it.srt	11.6 KB
110 Using Excels INDEX() and MATCH() Functions-tr.srt	17.5 KB
110 Using Excels INDEX() and MATCH() Functions-en.srt	19.7 KB
110 Using Excels INDEX() and MATCH() Functions-pt.srt	19.8 KB
110 Using Excels INDEX() and MATCH() Functions-it.srt	19.9 KB
109 Using Excels HLOOKUP() Function.mp4	18.6 MB
108 Using Excels VLOOKUP() Function.mp4	37.5 MB
110 Using Excels INDEX() and MATCH() Functions.mp4	67.1 MB
/28 Mastering Excels What If Tools/
124 Building Effective Data Tables in Excel-ja.srt	2.2 KB
125 Creating Scenarios in Excel-ja.srt	2.7 KB
123 Working with Excels Solver Tool-ja.srt	3.2 KB
124 Building Effective Data Tables in Excel-tr.srt	7.2 KB
124 Building Effective Data Tables in Excel-pt.srt	8.1 KB
124 Building Effective Data Tables in Excel-en.srt	8.2 KB
124 Building Effective Data Tables in Excel-it.srt	8.2 KB
125 Creating Scenarios in Excel-tr.srt	10.6 KB
125 Creating Scenarios in Excel-en.srt	11.5 KB
125 Creating Scenarios in Excel-pt.srt	11.5 KB
125 Creating Scenarios in Excel-it.srt	11.6 KB
122 Working with Excels Goal Seek Tool-en.srt	11.7 KB
123 Working with Excels Solver Tool-tr.srt	12.7 KB
123 Working with Excels Solver Tool-pt.srt	13.8 KB
123 Working with Excels Solver Tool-en.srt	14.1 KB
123 Working with Excels Solver Tool-it.srt	14.1 KB
124 Building Effective Data Tables in Excel.mp4	20.3 MB
122 Working with Excels Goal Seek Tool.mp4	25.1 MB
125 Creating Scenarios in Excel.mp4	37.3 MB
123 Working with Excels Solver Tool.mp4	46.9 MB
/01 Microsoft Excel Course Introduction/
001 Welcome to the Ultimate Microsoft Excel Course-ja.srt	2.8 KB
001 Welcome to the Ultimate Microsoft Excel Course-tr.srt	10.0 KB
001 Welcome to the Ultimate Microsoft Excel Course-en.srt	10.1 KB
001 Welcome to the Ultimate Microsoft Excel Course-pt.srt	10.7 KB
001 Welcome to the Ultimate Microsoft Excel Course-it.srt	11.0 KB
001 Welcome to the Ultimate Microsoft Excel Course.mp4	24.5 MB
/13 Microsoft Excel 102 Course Introduction/
059 Course Exercise Files - Download these First.html	3.5 KB
059 Excel102Exercises.txt	26.5 KB
059 Excel102Exercises.xlsx	139.3 KB
059 NorthwindDB.zip	401.7 KB
Total files 1084