Vòng 1
Course Introduction
Microsoft Excel Fundamentals
1.Launching Excel
0%
2.Microsoft Excel Startup Screen
0%
3.Introduction to the Excel Interface
0%
4.Customizing the Excel Quick Access Toolbar
0%
5.More on the Excel Interface
0%
6.Understanding the Structure of an Excel Workbook
0%
7.Saving an Excel Document
0%
8.Opening an Existing Excel Document
0%
9.Common Excel Shortcut Keys
0%
Entering and Editing Text and Formulas
1.Entering Text to Create Spreadsheet Titles
0%
2.Working with Numeric Data in Excel
0%
3.Entering Date Values in Excel
0%
4.Working with Cell References
0%
5.Creating Basic Formulas in Excel
0%
6.Relative Versus Absolute Cell References in Formulas
0%
7.Understanding the Order of Operation (DOWNLOAD EXERCISE FILE)
0%
Working with Basic Excel Functions
1.The structure of an Excel Function
0%
2.Working with the SUM() Function
0%
3.Working with the MIN() and MAX() Functions
0%
4.Working with the AVERAGE() Function
0%
5.Working with the COUNT() Function
0%
6.Adjacent Cells Error in Excel Calculations
0%
7.Using the AutoSum Command
0%
8.Excel's AutoSum Shortcut Key
0%
9.Using the AutoFill Command to Copy Formulas
0%
Modifying an Excel Worksheet
Formatting Data in an Excel Worksheet
1.Working with Font Formatting Commands
0%
2.Changing the Background Color of a Cell
0%
3.Adding Borders to Cells
0%
4.Formatting Data as Currency Values
0%
5.Formatting Percentages
0%
6.Using Excel's Format Painter
0%
7.Creating Styles to Format Data
0%
8.Merging and Centering Cells
0%
9.Using Conditional Formatting
0%
Inserting Images and Shapes into an Excel Worksheet
Creating Basic Charts in Excel
Printing an Excel Worksheet
Working with Excel Templates
Congratulations! You've Built a Solid Microsoft Excel Foundation
Microsoft Excel 102 Course Introduction
13. Working with an Excel List
1.Understanding Excel List Structure
0%
2.Sorting a List Using Single Level Sort
0%
3.Sorting a List Using Multi-Level Sorts
0%
4.Using Custom Sorts in an Excel List
0%
5.Filter an Excel List Using the AutoFilter Tool
0%
6.Creating Subtotals in a List
0%
7.Format a List as a Table
0%
8.Using Conditional Formatting to Find Duplicates
0%
9.Removing Duplicates
0%
14. Excel List Functions
15. Excel Data Validation
16. Importing and Exporting Data
1.Importing Data Into Microsoft Excel
0%
2.Importing Data from Text Files
0%
3.Importing Data from Microsoft Access
0%
4.NEW VERSION -- Import Data From Text Files into Excel
0%
5.NEW VERSION -- Import Data From a Database into Excel
0%
6.Microsoft Excel Legacy Import Options for New Excel Versions
0%
7.Exporting Data to a Text File
0%
17. Excel PivotTables
1.Understanding Excel PivotTables
0%
2.Why PowerPivot
0%
3.Creating an Excel PivotTable
0%
4.Activating the Excel PowerPivot AddIn
0%
5.Modifying Excel PivotTable Calculations
0%
6.Creating Data Models with PowerPivot
0%
7.Grouping PivotTable Data
0%
8.Creating PivotTables based on Data Models
0%
9.Formatting PivotTable Data
0%
10.PowerPivot Calculated Fields
0%
11.Drilling Down into PivotTable Data
0%
12.PowerPivot KPIs
0%
13.Creating PivotCharts
0%
14.Filtering PivotTable Data
0%
15.Filtering with the Slicer Tool
0%
18. Working with Excel's PowerPivot Tools
19. Working with Large Sets of Excel Data
20. Congratulations! You're an Intermediate Excel User
21. Microsoft Excel 103 Course Introduction
22. Working with Excel's Conditional Functions
1.Working with Excel Name Ranges
0%
2. Using Excel's IFERROR() Function
0%
3.Advantages and Disadvantages of Excel Name Ranges
0%
4.Editing an Excel Name Range
0%
5.Using Excel's IF() Function
0%
6.Excel's IF() Function with a Name Range
0%
7.Nesting Functions with Excel
0%
8.Nesting Excels AND() Function within the IF() Function
0%
9.Using Excel's COUNTIF() Function
0%
10.Using Excel's SUMIF() Function
0%
23. Working with Excel's Lookup Functions
1.Microsoft Excel VLOOKUP() Function
0%
2.Microsoft Excel HLOOKUP() Function
0%
3.Microsoft Excel INDEX() Function
0%
4.Microsoft Excel MATCH() Function
0%
5.Microsoft Excel INDEX() and MATCH() Function Combined
0%
6.Microsoft Excel INDEX() and MATCH() Function Combined Continued
0%
7.Creating a Dynamic HLOOKUP() with the MATCH() Function
0%
24. Working with Excel's Text Based Functions
25. Auditing an Excel Worksheet
26. Protecting Excel Worksheets and Workbooks
27. Mastering Excel's What If Tools
28. Automating Repetitive Tasks in Excel with Macros
29. Congratulations!
30. Microsoft Excel Macros and VBA Course Introduction
31. Project #1 Using Excel's Macro Recorder Tool
32. Excel VBA Concepts
33. Project #2 Moving Beyond the Basics and into VBA
1.Introduction to Project #2 Interacting with the User
0%
2.Project #2 Breaking Down the VBA Code
0%
3.Project #2 Prompting the User for Information
0%
4.Continue Excel VBA InputBox
0%
5.Project #2 Building Logic into Your Macros
0%
6.Project #2 Alerting the User of Errors
0%
7.Other Practical Uses of Message and Input Boxes
0%
34. Project #3 Preparing and Cleaning Up Data with a Little VBA
35. Project #4 Using VBA to Automate Excel Formulas
36. Project #5 Bringing it All Together and a Weekly Report
37. Project #6 Working with Excel VBA User Forms
1.Introduction to Project #6 Working with Excel VBA User Forms
0%
2.Project #6 Creating an Excel User Form
0%
3.Project #6 Adding Controls to the Form
0%
4.Project #6 Adding VBA Code to the Initialize Event
0%
5.Project #6 Adding VBA Code to the ComboBox Change Event
0%
6.Project #6 Adding VBA Code to the Add Worksheet Button
0%
7.Change Worksheet Name
0%
8.Project #6 Adding VBA Code to the Create Report Button
0%
9.Project #6 Showing the Form
0%
38. Project #7 Importing Data from Text Files
1.Project #7 Opening a Text File for Import
0%
2.Project #7 Opening a Text File for Import
0%
3.Project #7 Get Data from Text File
0%
4.Project #7 Importing Multiple Text Files with the GetOpenFilename Method
0%
5.Project #7 Creating a Loop to Read Each File
0%
6.Project #7 Adding a New Sheet for Imported Data
0%
7.Project #7 Clear the Clipboard
0%
8.Project #7 Working with the ScreenUpdating Property
0%
9.Project #7 Creating Reusable Code with a VBA Function
0%