Microsoft Excel ONLINE Training in Taglish
✓ Self-paced Videos in Taglish!
Short videos for better understanding.✓ Certificate of Completion ✓ Lifetime Access Pa! ✓ For the Filipinos Worldwide!
Pay Via:
✓ Bank Deposit: BDO, UNIONBANK
✓ E-wallet: Paymaya, GCash
Microsoft Excel Basic Course Outline
01 - Getting Started
1.1 - Spreadsheet Terminology
1.2 - The Excel Environment
1.3 - Navigating a Worksheet
1.4 - Using a Template
02- Entering & Editing Data
2.1 - Entering & Editing Text & Values
2.2 - Entering & Editing Formulas
2.3 - Saving & Updating Workbooks
2.4 - Lesson Exercise
03 - Modifying a Worksheet
3.1 - Moving & Copying Data
3.2 - Moving, Copying, & Viewing Formulas
3.3 - Absolute & Relative References
3.4 - Inserting & Deleting Ranges, Rows, Columns
3.5 - Lesson Exercise
04 - Functions
4.1 - Entering functions
4.2 - AutoSum
4.3 - Other Common Functions
4.4 - Lesson Exercise
05 - Formatting
5.1 - Text Formatting
5.2 - Row and column formatting
5.3 - Number formatting
5.4 - Conditional formatting
5.5 - Additional formatting options
5.6 - Lesson Exercise
06 - Charts
6.1 - Chart Basics
6.2 - Formatting Charts
6.3 - Lesson Exercise
07 - Graphics
7.1 - Working with Pictures
7.2 - Conditional Formatting w/ Graphics
7.3 - SmartArt Graphics
7.4 - Lesson Exercise
08 - Printing
8.1 - Preparing to Print
8.2 - Page Setup Options
8.3 - Printing Worksheets
8.4 - Lesson Exercise
Sample Video Lesson (Basic)
Your browser does not support the video tag.
Pay Via:
✓ Bank Deposit: BDO, UNIONBANK
✓ E-wallet: Paymaya, GCash
00 - Getting Started
01 - Managing Workbooks And Worksheets
1.1 - Viewing Large Worksheets
1.2 - Printing Large Worksheets
1.3 - Working With Multiple Worksheets
1.4 - Linking Worksheets With 3-D Formulas
1.5 - Using Multiple Workbooks
1.6 - Linking Workbooks
1.7 - Lesson Exercise
02- Advanced Formatting
2.1 - Using Special Number Formats
2.2 - Other Advanced Formatting
2.3 - Lesson Exercise
03 - Outlining And Subtotals
3.1 - Outlining And Consolidating Data
3.2 - Creating Subtotals
3.3 - Lesson Exercise
04 - Cell And Range Names
4.1 - Creating And Using Names
4.2 - Managing Names
4.3 - Lesson Exercise
05 - Data Structure And Tables
5.1 - Sorting And Filtering Data
5.2 - Working With Tables
5.3 - Lesson Exercise
06 - Web And Sharing Features
6.1 - Saving workbooks as Web Pages
6.2 - Using Hyperlinks
6.3 - Sharing workbooks
6.4 - Lesson Exercise
07 - Documenting And Auditing
7.1 - Auditing Features
7.2 - Comments In Cells And Workbooks
7.3 - Protection
7.4 - Lesson Exercise
08 - Template and Settings
8.1 - Changing Application Settings
8.2 - Working with Templates
8.3 - Lesson Exercise
Sample Video Lesson (Intermediate)
Your browser does not support the video tag.
Pay Via:
✓ Bank Deposit: BDO, UNIONBANK
✓ E-wallet: Paymaya, GCash
Microsoft EXCEL - Advanced Course Outline
00 - Getting Started
01 - Advanced Functions and Formulas
1.1 - Logical functions
1.2 - Conditional Functions
1.3 - Financial Function
1.4 - Text Functions
1.5 - Date Functions
1.6 - Array Formulas
1.7 - Lesson Exercise
02- Lookups and Data Tables
2.1 - Using Lookup Functions
2.2 - Using MATCH and INDEX
2.3 - Creating Data Tables
2.4 - Lesson Exercise
03 - Advanced Data Management
3.1 - Validating Cell Entries
3.2 - Advanced Filtering
3.3 - Lesson Exercise
04 - Advanced Charting
4.1 - Chart Formatting Options
4.2 - Combination Charts
4.3 - Graphical Objects
4.4 - Lesson Exercise
05 - PivotTables and PivotCharts
5.1 - Working with PivotTables
5.2 - Modifying PivotTable Data
5.3 - Formatting PivotTables
5.4 - Using PivotCharts
5.5 - Lesson Exercise
06 - Exporting and Importing Data
6.1 - Exporting and Importing Text Files
6.2 - Getting External Data
6.3 - Lesson Exercise
07 - Analytical Tools
7.1 - Goal Seek
7.2 - Scenarios
7.3 - Lesson Exercise
08 - Macros and Visual Basic
8.1 - Running and Recording a Macro
8.2 - Working with VBA Code
8.3 - Lesson Exercise
Sample Video Lesson (Intermediate)
Your browser does not support the video tag.
Pay Via:
✓ Bank Deposit: BDO, UNIONBANK
✓ E-wallet: Paymaya, GCash
