MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Microsoft Excel and PowerPoint Training With Certificate

### Course Summary

Learn the most essential and valuable skills for personal and professional success

• +

### Course Syllabus

• Introduction: Microsoft Excel Training With Certificate
• Class Intro - Microsoft Excel
• Before we begin
• Excel Layout: Standard Tool Bar
• Standard Tool Bar
• Standard Tool Bar Quiz
• Excel Layout: Formatting Toolbar
• Formatting Toolbar
• Formatting Toolbar Quiz
• Excel Layout: Home Tab
• Home Tab
• Home Tab Quiz
• Excel Layout: Layout Tab
• Layout Tab
• Layout Tab Quiz
• Excel Layout: Tables Tab
• Tables Tab
• Tables Tab Quiz
• Excel Layout: Charts Tab - Part 1
• Charts Tab - Part 1
• Charts Tab - Part 1 Quiz
• Excel Layout: Charts Tab - Part 2
• Charts Tab - Part 2
• Charts Tab - Part 2 Quiz
• Excel Layout: Smart Art, Formulas, Data and Review
• Smart Art, Formulas, Data and Review
• Smart Art, Formulas, Data and Review Quiz
• Excel Functions: Sum, Average, Max, Min and Count
• Functions: Sum, Average, Max, Min and Count
• Functions: Sum, Average, Max, Min and Count - Quiz
• Functions: Vertical and Horizontal Lookup
• Vertical and Horizontal Lookup
• Vertical and Horizontal Lookup Quiz
• Functions: Vertical and Horizontal Lookup with Index
• Vertical and Horizontal Lookup with Index
• Vertical and Horizontal Lookup with Index Quiz
• Functions: SumIf and AverageIf
• SumIf and AverageIf - Part 1
• SumIf and AverageIf - Part 2
• SumIf and AverageIf Quiz
• Functions: The IF Statement
• The IF Statement
• The IF Statement Quiz
• Functions: Nested IF Statement
• Nested IF Statement
• Nested IF Statement Quiz
• Functions: Vlookup nested inside an if statement
• Vlookup nested inside an if statement
• Vlookup nested inside an if statement Quiz
• Using Microsoft Excel for Personal Finance - Example
• Using Microsoft Excel for Personal Finance - Part 1
• Using Microsoft Excel for Personal Finance - Part 2
• Using Microsoft Excel for Personal Finance - Part 3
• Powerpoint: Making a simple presentation
• Making a simple presentation
• Making a simple presentation Quiz
• Powerpoint: Slide Master
• Slide Master
• Slide Master Quiz
• Powerpoint: Home Tab - Insert Image
• Home Tab - Insert Image
• Home Tab - Insert Image - Quiz
• Powerpoint: Home Tab - Paragraph Options
• Home Tab - Paragraph Options
• Home Tab - Paragraph Options - Quiz
• Powerpoint: Home Tab - Adding Clip Art
• Home Tab - Adding Clip Art - Part 1
• Home Tab - Adding Clip Art - Part 2
• Home Tab - Adding Clip Art - Part 3
• Home Tab - Adding Clip Art - Quiz
• Powerpoint: Home Tab - Insert Options
• Home Tab - Insert Options
• Home Tab - Insert Options - Quiz
• Excel 2013 - Add Subtract Multiply Divide
• Add Subtract Multiply Divide
• 2013 Home Tab Clipboard
• 2013 Home Tab Clipboard
• 2013 Home Tab Clipboard Copy Paste
• Home Tab Clipboard Copy Paste
• 2013 Fonts and related features
• 2013 Fonts and related features
• Excel 2013 Alignment
• Excel 2013 Alignment
• Excel 2013 Currency Feature
• Excel 2013 Currency Feature
• Excel 2013 Conditional Formatting
• Conditional Formatting 1
• Conditional Formatting 2
• Conditional Formatting 3
• Excel 2013 Format Table and Cells Features
• Excel 2013 Format Table and Cells Features
• Excel 2013 Edit Options in Home Tab
• Excel 2013 Edit Options in Home Tab
• Pivot Table
• Pivot Table
• Insert Table and recommended Pivot Table
• Excel 2013 Illustrations
• Excel 2013 Illustrations

Course Fee:
USD 29

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

## Data Analysis

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software