Curriculum
4 Sections
78 Lessons
Lifetime
Expand all sections
Collapse all sections
INTRODUCTION
8
1.0
Lesson 1 Microsoft Office Setup and Installation Guide
1.1
Lesson 1.2 Launching Word 2016 & User Interface
1.2
Lesson 1.3 Navigating through the Backstage View
1.3
Lesson 1.4 Going through the Ribbon and How to Customize it
1.4
Lesson 1.5Customizing the Quick Access Toolbar
1.5
lesson 1.6 How to use the Tell Me Feature in Word 2016
1.6
Lesson 1.7 How to use the Getting Help and Smart Lookup in Word 2016
1.7
Lesson 1.8 Using the Mini Toolbar and Status bar in Word 2016
THE BASIC LEVEL
7
2.0
lesson 2 Creating New Doc, Setting Margins, Font & Paragraph
2.1
Lesson 2.1 Adding Styles and Themes in Word 2016
2.2
Lesson 2.2 Editing Document in Word 2016
2.3
Lesson 2.3 Bulleting and Numbering in Word 2016
2.4
lesson 2.4 How to Set Tab Stop in Word 2016
2.5
Lesson 2.5 Adding Page Backgrounds, Borders & Watermarks in Word 2016
2.6
lesson 2.6 Inserting your Letterhead in Word 2016
Microsoft PowerPoint
20
3.0
Introduction(Power Point Interface)
3.1
Format Background
3.2
Content Page Design
3.3
Transition
3.4
Animation
3.5
Insert Object
3.6
SmartArt Graphics
3.7
Charts
3.8
Tables
3.9
Slides with Images (GIF)
3.10
Comparison Slides
3.11
Interactive Animation Explainer
3.12
Needle Animator Design
3.13
Interactive Slider Deck
3.14
Hyperlinks
3.15
Count Down Timer
3.16
Dynamic Quiz Template
3.17
Recordings(Voice over and Video Convert)
3.18
Add-ins in Power Point
3.19
File Security
Microsoft Excel
43
4.0
Excel – Creating and customizing charts 1
4.1
Excel – Creating and customizing charts 2
4.2
Excel – Introduction to Excel
4.3
Excel – Managing workbooks and worksheets
4.4
Excel – Pivottables and Pivotcharts for data analysis 1
4.5
Excel – Pivottables and Pivotcharts for data analysis 2
4.6
Excel – Sorting data in Excel
4.7
Excel – Understanding formula syntax and structure
4.8
Excel – Using data tables for sensitivity analysis 1
4.9
Excel – Using data tables for sensitivity analysis 2
4.10
Excel – Data analysis with what-if scenarios 1
4.11
Excel – Data analysis with what-if scenarios 2
4.12
Excel – Interface and navigation
4.13
Excel – Filtering and using autofilter
4.14
Excel – Goal seek for finding desired results
4.15
Excel – Inserting, deleting and renaming sheets
4.16
Excel – Sparklines and conditional charts
4.17
Excel – Working with basic mathematical functions 1
4.18
Excel – Working with basic mathematical functions 2
4.19
Excel – Advanced charting techniques and tips
4.20
Excel – Advanced filtering techniques 1
4.21
Excel – Advanced filtering techniques 2
4.22
Excel – Basic data entry and cell formatting 1
4.23
Excel – Basic data entry and cell formatting 2
4.24
Excel – Navigating and selecting cells, rows and columns
4.25
Excel – Solver for optimization problems
4.26
Excel – Using conditional formatting for data visualization 2
4.27
Excel – Using logical functions
4.28
Excel – Data consolidation and analysis using power query 1
4.29
Excel – Data consolidation and analysis using power query 2
4.30
Excel – Data consolidation and analysis using power query 3
4.31
Excel – Data validation and error handling
4.32
Excel – Data visualization best practices
4.33
Excel – Exploring lookup and reference functions 1
4.34
Excel – Exploring lookup and reference functions 2
4.35
Excel – Exploring lookup and reference functions 3
4.36
Excel – Scenario manager for multiple scenarios analysis
4.37
Excel – Using templates and pre-built functions
4.38
Excel – Data importing and exporting techniques
4.39
Excel – Practice question
4.40
Excel – Utilizing date and time functions
4.41
Excel – Practice question 2
4.42
Excel – General test project for beginner’s level (2)
Microsoft Office Suite
Search
Lesson 1.5Customizing the Quick Access Toolbar
The lesson content is empty.
WhatsApp us
Modal title
Main Content