Register on our Website or Android Mobile App and get 500/- in your Wallet.
Sales Closes in
D
H
M
S

WHY THIS COURSE?

Student can learn complete Microsoft Suite 2016 package in a single course

Excel, Word, Power point , Access, Outlook in a single course

Develop from Beginner to Pro in using Microsoft Suite

Improve your analytical Ability

Usage of VBA and Macro to automate the daily manual tasks

DESCRIPTION

Microsoft Office Suite 2016 for beginners and intermediates.

This course(MS Office 2021) covers wide range of topics such as Microsoft Word, Excel, Powerpoint , Access, Outlook Using Microsoft Professional 2016 all in one place.

Updated VBA and Macro as promised in Excel. I will update the usage of VBA across all the others as well in 3-6 Months.

This course will be updated every 3 months.

Excel:

Master Microsoft Excel from Beginner to Advanced

Build a solid understanding on the Basics of Microsoft Excel

Learn the most common Excel functions used in the Office

Maintain large sets of Excel data in a list or table

Create dynamic reports by mastering one of the most popular tools, Pivot Tables

Creation of Macro and VBA in Excel.

4 Mini Project in VBA and Macro.

Word:

You will learn how to take full advantage of Microsoft Word

Begin with the basics of creating Microsoft Word documents

Various techniques to create dynamic layouts

Preparing documents for printing and exporting

Format documents effectively using Microsoft Word Styles

Control page formatting and flow with sections and page breaks

Create and Manage Table Layouts

Work with Tab Stops to Align Content Properly

Perform Mail Merges to create Mailing Labels and Form Letters

Build and Deliver Word Forms

Manage Templates

Track and Accept/Reject Changes to a Document

PPT:

Create a fully-animated and transition-filled business presentation

Rapidly improve your workflow and design skills

Minimize text quantity on presentations by using graphs and images

Work comfortably with PowerPoint and many of its advanced features

Become one of the top PowerPoint users in your team

Carrying out regular tasks faster than ever

Create sophisticated and well-organized PowerPoint presentations

Feel more confident when delivering presentations to superiors

Make an impression at work and achieve your professional goals

Access:

Understand how Access is constructed and how to use the major objects within it.

Be confident in moving around within Access and be able to build effective database solutions for their unique data needs.

What you'll learn

Understand the basics of Access tables, queries, forms and reports.

Know how to structure tables being imported from Excel.

Know how to create powerful queries and use them to create and modify tables.

Understand how reports work and how to base them on tables or queries.

Know how to create forms and sub-forms.

Outlook:

Understand the basic usage of Outlook.

How to create rules in Outlook and group the mails.

How to format message and recall of message.

How to manage your calendar.

How to create to meetings and handling the participants.

How to create tasks using Outlook.

How to create contacts and manage groups in Outlook

Who this course is for:

Anyone who want to be successful in their office job

Want to become comfortable handling data

Organise and manage a team at work or at business

COURSE CONTENT

158 Lessons 12:31:54

  Lesson- 1: Introduction to Microsoft word 00:04:21

  Lesson- 2: Options in Typing in Microsoft Word 00:04:02

  Lesson- 3: Text Editing in Microsoft Word 00:08:47

  Lesson- 1: Character formatting - Part1 00:04:50

  Lesson- 2: Character formatting - Part2 00:03:03

  Lesson- 3: Paragraph Formatting- Part1 00:06:52

  Lesson- 4: Paragraph Formatting- Part2 00:02:48

  Lesson- 5: Page Set up in MS Word 00:06:48

  Lesson- 6: Page display in Word 00:03:54

  Lesson- 7: Header, Footer and Themes 00:06:48

  Lesson- 8: Image Formatting -Part 1 00:06:48

  Lesson- 9: Image Formatting -Part 2 00:02:57

  Lesson- 1: Header, Footer and URL 00:05:21

  Lesson- 2: Mailing in Microsoft Word 00:05:02

  Lesson- 3: View in Microsoft Word 00:06:15

  Lesson- 1: Table Formatting - Part 1 00:05:51

  Lesson- 2: Table Formatting - Part 2 00:05:45

  Lesson- 3: Review Option- Part 1 00:07:35

  Lesson- 4: Review Option- Part 2 00:06:35

  Lesson- 5: Table of content and Index 00:06:16

  Lesson- 6: Permission and Author 00:06:36

  Lesson- 1: Excel Introduction 00:07:39

  Lesson- 2: Cell formatting - Part 1 00:05:37

  Lesson- 3: Cell formatting - Part 2 00:06:25

  Lesson- 4: Essential Operation in Excel 00:06:58

  Lesson- 5: Names and Ranges 00:08:54

  Lesson- 6: Cell formatting and copy and paste 00:09:05

  Lesson- 7: Searching and commenting 00:05:40

  Lesson- 8: Working with Tables 00:04:33

  Lesson- 9: Fonts in Excel 00:08:08

  Lesson- 10: Styles and Themes 00:05:26

  Lesson- 11: File recovery and protection of Excel 00:02:51

  Lesson- 1: Formula in Excel 00:07:08

  Lesson- 2: How to use Formulas in Excel 00:05:18

  Lesson- 3: Frequently used Formulas in Excel 00:06:10

  Lesson- 4: Frequently used formulas in Excel - Part2 00:13:49

  Lesson- 5: Absolute and relative reference in Excel 00:05:41

  Lesson- 6: Working with Dates using Formulas 00:03:59

  Lesson- 1: Insertion of Image in Excel 00:05:03

  Lesson- 2: Chart Introduction 00:04:01

  Lesson- 3: Pivot Tables 00:03:50

  Lesson- 4: Conditional Formatting and Sparklines 00:06:48

  Lesson- 5: Other Graphics Options in Excel 00:04:41

  Lesson- 1: Vlookup in Excel 00:08:13

  Lesson- 2: Hlookup in Excel 00:05:26

  Lesson- 3: Index and Match in Excel 00:10:50

  Lesson- 4: Data validation in Excel and creation of list in Excel 00:05:24

  Lesson- 5: Other data validation options 00:03:19

  Lesson- 6: Error messages in data validation 00:03:11

  Lesson- 7: Input messages in data validation 00:03:58

  Lesson- 8: Dynamic LOV creation using Data validation 00:02:31

  Lesson- 9: Pivot table Introduction 00:05:14

  Lesson- 10: Pivot table modification and formatting 00:06:03

  Lesson- 11: Styles and gathering data in Pivot table 00:03:31

  Lesson- 12: Pivot chart 00:02:53

  Lesson- 13: Filter in pivot table and Slicer tool in pivot 00:02:58

  Lesson- 14: Powerpivot Introduction 00:04:00

  Lesson- 15: Activation of power pivot 00:01:37

  Lesson- 16: Customising data model in power pivot 00:03:43

  Lesson- 17: Creating power pivot 00:02:09

  Lesson- 18: Power pivot calculated fields 00:04:00

  Lesson- 19: Power pivot KPI 00:06:04

  Lesson- 20: Tracing in Formula Auditing 00:03:43

  Lesson- 21: Watch window and show formula 00:03:21

  Lesson- 1: Introduction to Macro 00:02:19

  Lesson- 2: Creating your first Macro 00:04:27

  Lesson- 3: Editing and saving Macro 00:02:11

  Lesson- 4: Running a Macro using Form 00:03:22

  Lesson- 5: Macro Mini-Project - Send Weekly report 00:05:12

  Lesson- 1: Introduction to VBA and VBA editor 00:03:41

  Lesson- 2: Creation of Modules and Procedures in VBA 00:03:05

  Lesson- 3: First VBA Code and variables 00:06:58

  Lesson- 4: If Condition in VBA 00:08:21

  Lesson- 5: Loops in VBA 00:07:13

  Lesson- 6: Project2 in VBA: Introduction 00:01:33

  Lesson- 7: Recording Macro for formatting data 00:02:51

  Lesson- 8: Integrating Macro with VBA code 00:07:25

  Lesson- 9: Project 3 in VBA: Autosum 00:01:29

  Lesson- 10: Autosum Creation_Basics 00:13:16

  Lesson- 11: Autosum_project Completion 00:08:06

  Lesson- 12: Project 4 in VBA Code: Automation of Data and Formatting in Excel 00:02:47

  Lesson- 13: Using previous project VBA Code to create automation 00:02:42

  Lesson- 14: Finalising all the VBA code 00:12:07

  Lesson- 1: Introduction 00:04:56

  Lesson- 2: Effective Presentation - Part 1 00:05:05

  Lesson- 3: Effective Presentation - Part 2 00:05:38

  Lesson- 4: Effective Presentation - Part 3 00:03:42

  Lesson- 5: Creation of first presentation and saving 00:07:05

  Lesson- 1: Creating Slides and text boxes 00:06:00

  Lesson- 2: Formatting - Part 1 00:04:52

  Lesson- 3: Formatting - Part 2 00:05:14

  Lesson- 4: Formatting - Part 3 00:05:02

  Lesson- 5: Working with Layout Themes 00:03:26

  Lesson- 1: Drawing Shapes- Part1 00:03:38

  Lesson- 2: Drawing Shapes- Part2 00:04:03

  Lesson- 3: Handling Images in PPT 00:06:06

  Lesson- 4: Smart art in Power point 00:04:56

  Lesson- 5: Audio/Music in Power point 00:05:04

  Lesson- 6: Videos in Power point 00:06:44

  Lesson- 1: Animation in Power point 00:03:36

  Lesson- 2: Transition in Power point - Part 1 00:03:53

  Lesson- 3: Transition in Power point - Part 2 00:03:37

  Lesson- 4: Custom Slides in Power point 00:02:03

  Lesson- 5: Slide show in Power point 00:04:24

  Lesson- 1: Introduction 00:03:33

  Lesson- 2: Working with Access Interface 00:05:16

  Lesson- 3: Defining data needs and types 00:07:11

  Lesson- 1: Creating Database 00:03:34

  Lesson- 2: Creating Table 00:03:07

  Lesson- 1: Navigate among records 00:02:27

  Lesson- 2: Working with Primary Keys 00:04:59

  Lesson- 3: Find and Replace 00:03:52

  Lesson- 4: Sorting and Filtering 00:04:36

  Lesson- 5: Understanding Table Relation 00:04:40

  Lesson- 1: Modifying DB table 00:03:42

  Lesson- 2: Creating field and Modifying field 00:04:07

  Lesson- 1: Creating Forms 00:03:11

  Lesson- 2: Sorting and filter using forms 00:02:53

  Lesson- 1: Create Query 00:05:13

  Lesson- 2: Modifying queries 00:03:31

  Lesson- 3: Sorting and filtering using queries 00:02:19

  Lesson- 1: Create Report 00:04:00

  Lesson- 1: Introduction to Outlook 00:03:39

  Lesson- 2: Introduction- Part 2 - Shortcuts in Outlook 00:03:13

  Lesson- 1: Introduction to managing outlook environment 00:01:10

  Lesson- 2: Mail set-up in Outlook 00:03:54

  Lesson- 3: Appearance of mail 00:04:01

  Lesson- 4: Navigation of outlook 00:04:26

  Lesson- 5: Configuration of program option 00:03:26

  Lesson- 1: View attachment in Outlook 00:03:15

  Lesson- 2: Print option in outlook 00:03:41

  Lesson- 3: Saving option in outlook 00:02:58

  Lesson- 4: Search messages in Outlook 00:03:02

  Lesson- 5: Search option- Final 00:05:30

  Lesson- 1: Managing mail - Introduction 00:02:01

  Lesson- 2: Mail signature 00:06:59

  Lesson- 3: Creating rules in outlook 00:05:18

  Lesson- 4: Rules within rules in outlook 00:03:01

  Lesson- 5: Update and delete rules in Outlook 00:02:42

  Lesson- 6: Junk Email setup in Outlook 00:03:41

  Lesson- 1: Create mail in Outlook 00:04:41

  Lesson- 2: Configuring messages in Outlook 00:03:37

  Lesson- 3: Recall messages in outlook 00:01:52

  Lesson- 1: Fonts in Outlook messages 00:05:02

  Lesson- 2: Insert in Outlook messages 00:05:04

  Lesson- 3: Themes and styles in Outlook 00:04:56

  Lesson- 4: Hyperlink in Outlook 00:02:39

  Lesson- 5: Images insert in Outlook 00:02:39

  Lesson- 1: Managing and arranging mails in outlook 00:03:28

  Lesson- 2: Managing and arranging mails in outlook- Part 2 00:03:43

  Lesson- 1: Calender in outlook 00:02:08

  Lesson- 2: Calender in outlook- Part 2 00:03:42

  Lesson- 3: Appointment in Outlook 00:04:54

  Lesson- 4: Meetings in Outlook 00:04:53

  Lesson- 5: Meetings in Outlook- Part 2 00:04:23

  Lesson- 1: Task and To-do list 00:01:43

  Lesson- 2: Task and To-do list- Part 2 00:05:54

  Lesson- 1: Contact and group 00:03:13

SIMILAR COURSES

COURSE FEATURES
  158 Lessons
  Full Lifetime Access
  Access on Mobile
  Access on Web
  Certificate of Completion
M.R.P.: 2500.00
ISC Price: 335
You Save: 2165 (86.6% off)
DON'T HAVE TIME?

We can send you everything you need to know about this course through email.

We respect your privacy. your information is safe and will never be shared.