Mega Microsoft Office Course | Covers Seven Office Products

Mega Microsoft Office Course | Covers Seven Office Products

Mega Microsoft Office Course | Covers Seven Office Products

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

Language: english

Note: 4.3/5 (142 notes) 19,344 students

Instructor(s): Usama Hassan

Last update: 2021-10-16

What you’ll 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

 

Requirements

  • Microsoft Office Products in your device
  • Internet

 

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, and reports or it can be used for any kind of documentation work. Microsoft PowerPoint is used for presentations. 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 advertisement 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, create or manage the different tasks, write notes & creating a 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.


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!

 

Who this course is for

  • Students, Teachers or Researchers
  • Content Writers or Proofreaders
  • Working Professionals
  • Engineers or Auditors
  • Freelancers
  • Computer or Data Entry Operators
  • Any one who wants to Master the Microsoft Office

 

Course 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

 

Mega Microsoft Office Course | Covers Seven Office ProductsMega Microsoft Office Course | Covers Seven Office Products

Time remaining or 951 enrolls left

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate