Loading

60% OFF

Microsoft Office

  • Overview
  • Curriculum
  • Instructor
  • Reviews

Microsoft Office  2016

What you'll learn

📌  Discover new and improved features in Excel 2016.

📌  How to effectively use Excel 2016 on a touchscreen device.

📌  How to create, save, and open a workbook.

📌  Learn how to personalize your use of Excel using Excel Options.

📌  How to rename, insert, move, and reference an Excel 2016 worksheet.

📌  Discover how to create charts and graphs

📌  Learn practical methods to sort and filter your data

📌  How to protect and secure your Excel data

📌  Practice what you learned with included exercise files

📌  Discover new features in PowerPoint 2016

📌  Learn presentation tips for an effective presentation

📌  Discover how to format text on a PowerPoint slide

📌 Add charts, graphs, and tables to present information in a non-text format

📌  Master the most common uses of Word.

📌  Learn how to spell-check your documents.

📌  Insert pictures and graphics in your Word document.

📌  Discover how to insert and edit tables.

Requirements

📌 Microsoft Office 2016

Description

 ðŸ“Œ Master the Ins and Outs of Microsoft Office 2016

📌  Spreadsheets with Excel 2016

📌  Documents with Word 2016

📌  Presentations with PowerPoint 2016

The course is designed for individuals and office professionals who need to master the capabilities of the latest edition of Microsoft Office.

📌  Microsoft Excel 2016 for Beginners: Master the Essentials: Create basic spreadsheets and use formulas   for tracking expenses.

📌  Learn Microsoft Word 2016 For Beginners - Basics to Advanced: Create documents, embed videos, and set up for online collaboration for joint projects for school or work.

📌  Master Microsoft PowerPoint 2016 the Easy Way: Make slick presentations for your next business meeting using animation, audio/video, and collaborative tools.

 Why Get Certified?

📌  Multiple Career Opportunities for certified candidates

📌  Career Progression and Management

📌  Industry Preferred Certificate

After successful completion of the course, students will get a "Certificate of Completion"

Why Happy Learnings?

Happy Learnings is the fastest growing online education marketplace on the internet to learn accounts, business, software, technology, and creative skills to achieve personal and professional goals. We partner with companies and individuals to address their unique needs, providing training and coaching that helps working professionals achieve their career goals. In addition to helping individual learners achieve their goals, we offer flexible, cost-effective group memberships for your business, school, or government organization.

MS Word 2016-Contents
1 - Microsoft Office Word 2016
2 min Preview
2 - How to Open the MS Word 2016
4 min Preview
3 - How to Close the Word Program
2 min Preview
4 - Create a New Document
2 min
5 - Word 2016 Interface
7 min
6 - Create a New Document Based on Template
4 min
7 - Different Methods to Save the Workbook
4 min
8-Font Group
6 min
9 - Change Case
2 min
10 - Font Color _ Font Highlighter
5 min
11 - Selection Tips
3 min
12 - Align Left _ Center _ Right
2 min
13 - Line and Paragraph Spacing
3 min
14 - Shading and Boarder
2 min
15 - Bullets and Numbering
3 min
16 - Multilevel Test
3 min
17 - Cut _ Copy _ Paste
2 min
18 - Use of Format Painter
2 min
19 - How to use Cover page and Page Break
3 min
20 - Insert Date and Time
2 min
21 - Use of Work Art and Text Box
4 min
22 - How to use Drop Cap
2 min
23 - How to use Smart Art Graphic
4 min
24 - Insert Header and Footer
3 min
25 - Insert Shape & Picture
4 min
26 - Table Creation Part - 1
5 min
27 - Table Creation Part - 2
3 min
28 - Screen Clipping
3 min
29 - How to insert water mark
4 min
30 - Page Boarder and Page Color
2 min
31 - Page Setup and Printing
3 min
32 - Undo and Redo
2 min
MS Excel 2016 - Contents
1-Launching Microsoft Excel
3 min Preview
2-Excel Startup Screen
2 min Preview
3-Introduction to MS Excel
3 min Preview
4-Customizing Quick Access Toolbar
2 min
5-More on Excel Interface
2 min
6-Structure of an Excel Workbook
5 min
7-How to Save and Save As
5 min
8-Common Excel Shortcuts
5 min
9-Entering Text into MS Excel
4 min
10-Font Groups in MS Excel
4 min
11-Paragraph Options in MS Excel
6 min
12-Number Formats in MS Excel
11 min
13-Clear Options in MS Excel
5 min
14-Creating Basic formulas in MS Excel
4 min
15-Copying formulas in MS Excel
4 min
16-Using Autofill in MS Excel
5 min
17_-Basic Functions in MS Excel
9 min
18-Adjacent Cells error in MS Excel
3 min
19-Inserting & Deleting Rows and Columns
2 min
20-Inserting Images and Shapes
6 min
21-Screenshot and Screen Clipping
3 min
22-Insert Text box and Word Art
2 min
23_Excel Templates
4 min
24-Adding Header and Footer
4 min
25-Printing Excel Sheets
4 min
26- Understanding Excel List Structure
5 min
27-Sorting a List Using Single Level Sort
4 min
28-Using Custom Sorts in an Excel List
5 min
29-Auto Filter Tool in MS Excel
9 min
30-Multilevel Sorting in MS Excel
5 min
31-Sort Left to Right in MS Excel
6 min
32-Case Sensitive Sorting
3 min
33-Conditional Formatting - Introduction
3 min
34-Highlight Cell Rules
11 min
35-Manage Rules
4 min
36-Top or Bottom Rules
4 min
37-Data Bars in Conditional Formatting
6 min
38-Color Scale in Conditional Formatting
5 min
39- Icon set in Conditional Formatting
5 min
40-Sort cell color, Icon Set, Font color
6 min
41-Trace Precedents in Excel
5 min
42-Trace Dependents in Excel
2 min
43-Show Formulas in Excel
2 min
44-Name and Name Manager in Excel
7 min
45-How to Remove Duplicates values in MS Excel
4 min
46-What is Pivot Table in Excel
6 min
47-Different Formulas in Pivot Table
4 min
48-Different Fields in Pivot Table
5 min
49-Filters & Data Updations in Pivot Table
7 min
50-Percentage Calculations in Pivot Table
3 min
51-Number formats in Pivot Table
2 min
52-Monthly_Quarterly_Yearly Reports in Pivot
5 min
53-Subtotals in Pivot Table
2 min
54-Pivot Charts in Excel
3 min
55-Secondary Axis in Pivot Chart
5 min
56-Merge Data's in MS Excel
3 min
57-Text to Columns in MS Excel
8 min
58-Get External Data into Excel
4 min
59-Import Data from Website-1
3 min
60-Freeze pane in Excel
4 min
61-How to Inspect a Workbook
2 min
62-Errors in MS Excel
7 min
63-Data Validation Part 1
5 min
64-Data validation Part 2
6 min
65-Logical Function IF- Part 1
5 min
66-Logical Function IF - Part 2
3 min
67-Multiple IF Conditions Part - 1
5 min
68-Multiple IF Conditions Part - 2
6 min
69-Subtotal & Grand Total
5 min
70-Macro Programming Part-1
5 min
71-Macro Programming Part-2
4 min
72-Macro Programming Part-3
4 min
73-Macro Programming Part-4
6 min
74-Macro Programming Part-5
3 min
75-V-Lookup, H-Lookup
8 min
76- Vertical Lookup
6 min
77- Vertical Lookup Continue
5 min
78- Horizontal Lookup Part 1
4 min
79- Horizontal Lookup Part 2
3 min
80- Tax Calculation
3 min
MS PowerPoint2016 - Contents
1-Introduction to PowerPoint
3 min Preview
2-Common Use of PowerPoint
3 min
3-How to open a PowerPoint
3 min
4-How to Close a PowerPoint
2 min
5-Slide and Slide Layouts
3 min
6-Slide Layouts and Create a New Slide
3 min
7-Create Presentation Based on Templates
2 min
8-Save a Presentation
2 min
9-How to Start a PowerPoint Show
2 min
10-Save a Presentation as pdf
2 min
11-Create a Slide with Design
3 min
12-Move & Duplicate Slide
2 min
13-Different PowerPoint Views
3 min
14-Slide Transition
3 min
15-Slide Transition with Effect
2 min
16-Slide Transition with Timing
2 min
17-Table Creation
5 min
18-Insert an Image
3 min
19-Insert a Shape
3 min
20-Text Box and Word Art
2 min
21-Smart Art Graphic
5 min
22-Insert Header & Footer
3 min
23-Chart Creation -Part 1
4 min
24-Chart Creation -Part 2
4 min
25-What is Slide Master
4 min
26-Insert a Video
3 min
27-Insert a Audio
2 min
28-Create a Photo Album
5 min
MS Office 2016- Notes
Complete Note
No Preview
Microsoft office work file
work file
No Preview
instructor

Happy Learnings

4.7 Instructor Rating

HappyLearnings.com is one of the world’s leading certification training providers. We partner with companies and individuals to address their unique needs, providing training and coaching that helps working professionals achieve their career goals.

Course Rating

5.00 average based on 3 rating

4.67/5.00
Happy-learning-user-review-DOONIYA JOHNSON

DOONIYA JOHNSON

5.00/5.00

Excellent course with many useful functions. The instructor is very professional and has excellent presentation skills and it's a very interesting course. easy tips and tricks explained are helpful to complete my office tasks more quickly.

Happy-learning-user-review-Minju Madhu

Minju Madhu

4.00/5.00

Happy-learning-user-review-Reshma

Reshma

5.00/5.00

awesome classes



Add Your Comments

Your email address will not be published. Required fields are marked *

Add Ratings




  • Overview
  • Curriculum
  • Instructor
  • Reviews
Questions? Let's Chat
Need Help? Chat with us
Click one of our representatives below
happy-learning
Athira
Customer Support
I'm Online