Microsoft Office suite(Latest 2021) | VBA and Macro
What you'll learn
- 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
- Basic computer knowledge
- Microsoft office license
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.
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.
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
Track and Accept/Reject Changes to a Document
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
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.
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
I am a software engineer turned into stock trader. Author of 12+ courses with more than 50K students enrolled. I am very passionate on teaching office productivity, software programming and stock market analysis.
Worked with teaching several corporate on Office productivity and Programming. Running an teaching centre of my own.
Trade in stock market whenever I could see opportunity.