• Post category:StudyBullet-3
  • Reading time:19 mins read


Get maximum out of Microsoft Office | All in One Microsoft Word, PowerPoint, Excel, Publisher, Outlook, OneNote & Access

What you will learn

Learn Microsoft Word from Entry-Level to Advanced Level

Learn Professional & Advanced Document Formatting & Layout in Microsoft Word

Learn Microsoft PowerPoint from Entry-Level to Advanced Level

Learn How to Create a Eye Catchy Presentation

Learn Microsoft Excel from Beginner to Expert Level

Learn the Mathematical Functions in Excel

Learn the Logical, LOOKUP & Other Functions in Excel

Learn the Use of Tables, Charts, Pivot Tables & Pivot Charts in Excel

Learn About Form Controls & How to Create Dashboards

Learn the VBA & Macros in Excel

Learn Different Text Box options in Publisher

Learn How to Create the Publication Using Building Blocks

Learn How to Create the Web Page of the Publication

Learn How to Design a Custom Business Card

Learn How to Send or Receive Emails in Outlook

Learn How to Create Appointments & Schedule the Meetings in Outlook

Learn How to Create Notes in Microsoft OneNote

Learn How to Create the Notes in Handwriting in OneNote

Learn How to Create Database in Microsoft Access

Learn How to Customize the Tables & Queries in Access

Learn How to Customize the Forms & Reports in Access

Learn the Shortcut Keys for Microsoft Word, PowerPoint & Excel

Description

Get this Microsoft Office Training Course to learn Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Outlook, Microsoft OneNote & Microsoft Access.

Microsoft Office applications are the most used applications across the world. Microsoft Office has many products like Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Publisher, Microsoft Outlook, Microsoft OneNote & Microsoft Access. In this course of MS office, all these seven above-mentioned Microsoft Office products are covered.

Microsoft Word is used for writing books, letters, applications, resumes, reports, or it can be used for any kind of documentation work. Microsoft Powerpoint is used for presentation. In Microsoft Powerpoint, data summary, findings, results, reports, goals, achievements, tasks, or any kind of documentation work can be presented in the form of small points & in fewer slides. Microsoft Excel is used to create spreadsheets for data calculation, data analyzation & data consolidation work. Microsoft Publisher is used for different design work. Microsoft Publisher can be used for advertisements design, certificate design, flyer or brochure design, banner design, business card design, postcard design, or poster design. In Short, Microsoft Publisher can be used for any kind of document designing work.

Microsoft Outlook is used to send or receive emails. Also, Microsoft Outlook is used to create the appointments & schedule the meetings, create the contacts, business cards, or contact groups, creating or managing the different tasks, writing notes & creating the folder to organize the data. This makes Microsoft Outlook a complete package for office work.

Microsoft OneNote is a kind of digital notebook that provides different options which are not possible to use when writing a note on the hard copy of the notebook. As a student or teacher, Microsoft OneNote can be used to create academic notes, assignments, or, lectures. As a working person, Microsoft OneNote lets you create notes for your office meetings like minutes of meetings.

Microsoft Access is used to create a database for a large amount of data. In any institution or in any sector, Microsoft Access can be used to create a database to keep the whole data record. In Microsoft Access, we can create tables, forms, queries, & reports. Microsoft Access is a very optimistic & reliable digital solution to handle the data record so Microsoft Access eliminates the need to always carry the data record stuff.

This Microsoft Office course is a complete guide for all these seven above-mentioned MS office applications & their uses. In this course of Microsoft office, you will be able to learn the all above-mentioned uses of Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Outlook, Microsoft OneNote & Microsoft Access.

This Microsoft office course is All in one complete MS office guide from basic to advanced level. Microsoft office is the need of everyone so If you are studying in any field or working in any sector this Mega Microsoft Office Training Course is must for you. If you never used any of these MS Office products still you can choose this training course because this Microsoft Office course aims to facilitate beginners as well.

This Microsoft office course has a total of 173 video lectures with a total length of 18.5 hours. As already mentioned that this MS Office training aims to facilitate beginners as well so some entry-level topics are also added but if you already have the basic knowledge about any of these seven Microsoft office applications then you can skip only those basic topics as they are almost the same for all of these seven Microsoft Office applications.

This course is designed in the Microsoft office 2019 version but it can be easily learned in almost any older or latest version of MS office.

The shortcut keys file are attached for Microsoft Word, Microsoft PowerPoint, Microsoft Excel & Microsoft Publisher, and some practice files are also attached for only Microsoft Excel. You can download & practice on all those files.


Get Instant Notification of New Courses on our Telegram channel.


This MS office course is divided into the following sections:

1. Microsoft Word

2. Microsoft PowerPoint

3. Microsoft Excel

4. Microsoft Publisher

5. Microsoft Outlook

6. Microsoft OneNote

7. Microsoft Access

There are plenty of topics presented in each of these seven sections of the MS office course. After covering all these seven sections, you will be the expert of Microsoft Word, Microsoft PowerPoint, Microsoft Excel, Microsoft Publisher, Microsoft Outlook, Microsoft OneNote & Microsoft Access.

So, Just Hit the ‘Enroll Now’ Button & Enjoy the Complete Microsoft Office Package. Happy Learning!

English
language

Content

Microsoft Word
Introduction to Microsoft Word Interface
Font Formatting Options in Microsoft Word
Paragraph Formatting Options in Microsoft Word
Text Styles in Microsoft Word
Editing & Clipboard Options in Microsoft Word
Page Insert Options in Microsoft Word
Inserting Tables in Microsoft Word
Inserting Pictures in Microsoft Word
Inserting Shapes, Icons & 3D Models in Microsoft Word
SmartArt Graphics in Microsoft Word
Inserting Charts in Microsoft Word
Inserting Hyperlink in Microsoft Word
Header, Footer & Page Number Options in Microsoft Word
Text Insert Options in Microsoft Word
Equations & Symbols in Microsoft Word
Document Designing in Microsoft Word
Page Setup Options in Microsoft Word – 01
Page Setup Options in Microsoft Word – 02
Endnote, Footnote & Table of Contents in Microsoft Word
Mail Merge in Microsoft Word
Proofing & Language Options in Microsoft Word
View & Zoom Options in Microsoft Word
Microsoft PowerPoint
Introduction to PowerPoint Interface
Font & Slide Options in PowerPoint
Paragraph Formatting in PowerPoint
Drawing Tools in PowerPoint
Editing Options in PowerPoint
Inserting Tables in PowerPoint – 01
Inserting Tables in PowerPoint – 02
Inserting Pictures in PowerPoint
Screenshot in PowerPoint
Photo Album in PowerPoint
Icons in PowerPoint
3D Models in PowerPoint
SmartArt in PowerPoint
Inserting Charts in PowerPoint
Other Insert Options in PowerPoint
Inserting Video in PowerPoint
Inserting or Recording Audio & Screen in PowerPoint
Designing Options in PowerPoint
Transitions in PowerPoint
Animations in PowerPoint
Slide Show in PowerPoint
Proofing & Language Options in PowerPoint
View Settings in PowerPoint
Quick Access Toolbar & File Tab in PowerPoint
PowerPoint Presentation Templates
Microsoft Excel
Introduction to Excel Interface
Simple Math Functions
AutoSum Functions
Sum IF Function & Remove Duplicates Option in Excel
Sum IF, Count IF, Sum IFs & Count IFs Functions in Excel
Sub Total Function
Array Function & Sum Product Function
Some More Mathematical Functions
Cell Name or Range Name
Absolute Reference & Relative Reference
Excel Formatting Techniques
Data Types
Roaming in Excel
Go to Option & Replace Option
Auto Fill Options
Flash Fill Options
Copy, Paste & Paste Special
Conditional Formatting in Excel
Sort & Filter
Operators in Excel
Using Equations in Excel
Excel Sheet Errors
Logical Function IF
Logical Function IF Error
Logical Function (IF, Nested IF, OR)
Logical Function AND
VLOOKUP Function
VLOOKUP Function with Data Validation Tool
VLOOKUP with Wildcard
VLOOKUP with Helper Column
Nested VLOOKUP or Multiple VLOOKUP Function
HLOOKUP Function
Audit Using Charts Within Seconds
Formulas Auditing Tools
Selecting the Right Chart
Charts in Excel
Tables in Excel
Pivot Table & Pivot Chart
Sparklines & Slicer Filter Options
Inserting Comments
Hyperlink in Excel
Info Functions
Text Functions
Date, Time & Reference Functions
Print & View Settings for Excel Sheet
Text to Columns Option
Data Consolidation in Excel
Scenario Manager
Goal Seek
Data Table
Queries in Excel | Importing Data
Dashboard in Excel
Form Controls in Excel
Recording & Using Macros
Creating & Using the Macro Button
Visual Basic for Application (VBA) | Coding
Microsoft Publisher
Introduction to Microsoft Publisher Interface
Font Formatting Options in Publisher
Paragraph Formatting Options in Publisher
Scratch Area in Publisher
Text Box Options in Publisher Part – 01
Text Box Options in Publisher Part – 02
Text Box Options in Publisher Part – 03
Text Box Options in Publisher Part – 04
Picture Tools in Publisher Part – 01
Picture Tools in Publisher Part – 02
Shape Tools in Publisher
Table Tools in Publisher
Text Styles in Publisher
Picture Placeholder in Publisher
WordArt in Publisher
Inserting File, Object & Other Items
Header, Footer & Page Number Options in Publisher
Creating Business Information for Templates
Building Blocks in Publisher
Creating Web Page & Inserting the Hyperlink in Publisher
Page Setup & Page Layout Options in Microsoft Publisher
Customizing the Page Background in Microsoft Publisher
Working with Master Pages in Publisher
Printing the Publication & Sending Mail to Multiple Recipients
View Settings in Microsoft Publisher
Checking Design with Design Checker
Saving, Printing & Sharing the Publication
Custom Business Card Design in Publisher
Microsoft Outlook
Automatic Email Configuring Process in Outlook
Manual Email Configuring Process in Outlook
Introduction to Outlook Interface
Sending & Receiving Email in Microsoft Outlook
Email Formatting in Microsoft Outlook
Address Book & Different Tags in Outlook
Including the Outlook Items in Email
Including Table in Email
Including Pictures & Shapes in Email
Including Charts in Email
Including Text Box & Hyperlink in Email
Email Background Customization
Creating Appointments in Outlook
Scheduling Meetings in Outlook
Creating Contacts & Contacts Business Cards
Creating Task in Microsoft Outlook
Creating Contact Groups in Microsoft Outlook
Creating Notes & Organizing Folders in Outlook
Mail Merge in Outlook
Add or Remove Columns
Outlook View Settings
Microsoft OneNote
Introduction to OneNote Interface
Text Formatting in OneNote
Use of Tags in Microsoft OneNote
Including Files, Tables & Excel Spreadsheet in Notes
Including Images, Hyperlink & Audio in Notes
Microsoft OneNote Page Templates & Writing Equations in Notes
Writing Notes in Handwriting
View Settings in Microsoft OneNote
Review Tab Options in OneNote
Checking Assignment in Microsoft OneNote
Microsoft Access
Introduction to Microsoft Access & Creating Fields
Working with Tables & Customizing the Field Properties
Table Layout Customization
Creating Simple Form in Microsoft Access
Customizing Blank Form & Form Wizard in Microsoft Access
Creating Simple Report in Microsoft Access
Creating Report in Report Wizard
Customizing the Query
Creating Report Using Query Table Data
Macro & VBA in Access
Import, Export Options in Microsoft Access