All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Get Unlimited Learning Access
$29
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
$348 $244 a year Save 30%
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
$29
$244
  • 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

Microsoft Office Suite 2016 for beginners and intermediates.

This course (MS Office 2021-2022) 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 & last updated on March 2022

 

Microsoft 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.

 

Microsoft 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

 

Microsoft Powerpoint:

 

  • 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

 

Microsoft 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.

 

Microsoft 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

  • Basic computer knowledge
  • Microsoft office license
  • 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
View More...
  • Section 1 : Microsoft Word 3 Lectures 00:13:18

    • Lecture 1 :
    • Lecture 2 :
    • Options in Typing
    • Lecture 3 :
    • Text Editing in Microsoft Word
  • Section 2 : Formatting document in Word 9 Lectures 00:44:43

    • Lecture 1 :
    • Character formatting - Part1
    • Lecture 2 :
    • Character formatting - Part2
    • Lecture 3 :
    • Paragraph Formatting- Part1
    • Lecture 4 :
    • Paragraph Formatting- Part2
    • Lecture 5 :
    • Page Set up in MS Word
    • Lecture 6 :
    • Page display in Word
    • Lecture 7 :
    • Header, Footer and Themes
    • Lecture 8 :
    • Image Formatting -Part 1
    • Lecture 9 :
    • Image Formatting -Part 2
  • Section 3 : Layout, view and Sharing document 3 Lectures 00:16:37

    • Lecture 1 :
    • Header, Footer and URL
    • Lecture 2 :
    • Mailing in Microsoft Word
    • Lecture 3 :
    • View in Microsoft Word
  • Section 4 : Other Functionalities in Word 6 Lectures 00:32:01

    • Lecture 1 :
    • Table Formatting - Part 1
    • Lecture 2 :
    • Table Formatting - Part 2
    • Lecture 3 :
    • Review Option- Part 1
    • Lecture 4 :
    • Review Option- Part 2
    • Lecture 5 :
    • Table of content and Index
    • Lecture 6 :
    • Permission and Author
  • Section 5 : Microsoft Excel 11 Lectures 01:11:10

    • Lecture 1 :
    • Introduction to Excel
    • Lecture 2 :
    • Cell formatting - Part 1
    • Lecture 3 :
    • Cell formatting - Part 2
    • Lecture 4 :
    • Essential Operation in Excel
    • Lecture 5 :
    • Names and Ranges
    • Lecture 6 :
    • Cell formatting and copy and paste
    • Lecture 7 :
    • Working with Tables
    • Lecture 8 :
    • Fonts in Excel
    • Lecture 9 :
    • Styles and Themes
    • Lecture 10 :
    • File recovery and protection of Excel
    • Lecture 11 :
    • Searching and commenting
  • Section 6 : Formula in Excel 6 Lectures 00:42:03

    • Lecture 1 :
    • Formula in Excel
    • Lecture 2 :
    • How to use Formulas in Excel
    • Lecture 3 :
    • Frequently used Formulas in Excel
    • Lecture 4 :
    • Frequently used formulas in Excel - Part2
    • Lecture 5 :
    • Absolute and relative reference in Excel
    • Lecture 6 :
    • Working with Dates using Formulas
  • Section 7 : Graphics 5 Lectures 00:19:19

    • Lecture 1 :
    • Insertion of Image in Excel
    • Lecture 2 :
    • Chart Introduction
    • Lecture 3 :
    • Pivot Tables
    • Lecture 4 :
    • Conditional Formatting and Sparklines
    • Lecture 5 :
    • Other Graphics Options in Excel
  • Section 8 : Advanced Excel Video 21 Lectures 01:31:07

    • Lecture 1 :
    • Vlookup in Excel
    • Lecture 2 :
    • Hlookup in Excel
    • Lecture 3 :
    • Index and Match in Excel
    • Lecture 4 :
    • Data validation in Excel and creation of list in Excel
    • Lecture 5 :
    • Other data validation options
    • Lecture 6 :
    • Error messages in data validation
    • Lecture 7 :
    • Input messages in data validation
    • Lecture 8 :
    • Dynamic LOV creation using Data validation
    • Lecture 9 :
    • Pivot table Introduction
    • Lecture 10 :
    • Pivot table modification and formatting
    • Lecture 11 :
    • Styles and gathering data in Pivot table
    • Lecture 12 :
    • Pivot chart
    • Lecture 13 :
    • Filter in pivot table and Slicer tool in pivot
    • Lecture 14 :
    • Powerpivot Introduction
    • Lecture 15 :
    • Activation of power pivot
    • Lecture 16 :
    • Customising data model in power pivot
    • Lecture 17 :
    • Creating power pivot
    • Lecture 18 :
    • Power pivot calculated fields
    • Lecture 19 :
    • Power pivot KPI
    • Lecture 20 :
    • Tracing in Formula Auditing
    • Lecture 21 :
    • Watch window and show formula
  • Section 9 : Macros 5 Lectures 00:17:30

    • Lecture 1 :
    • Introduction to Macro
    • Lecture 2 :
    • Creating your first Macro
    • Lecture 3 :
    • Editing and saving Macro
    • Lecture 4 :
    • Running a Macro using Form
    • Lecture 5 :
    • M5. Macro project - Weekly report_Final
  • Section 10 : VBA 14 Lectures 01:21:26

    • Lecture 1 :
    • Introduction to VBA and VBA editor
    • Lecture 2 :
    • Creation of Modules and Procedures in VBA
    • Lecture 3 :
    • First VBA Code and variables
    • Lecture 4 :
    • If Condition in VBA
    • Lecture 5 :
    • Loops in VBA
    • Lecture 6 :
    • Project2 in VBA: Introduction
    • Lecture 7 :
    • Recording Macro for formatting data
    • Lecture 8 :
    • Integrating Macro with VBA code
    • Lecture 9 :
    • Project 3 in VBA: Autosum
    • Lecture 10 :
    • Autosum Creation_Basics
    • Lecture 11 :
    • Autosum_project Completion
    • Lecture 12 :
    • Project 4 in VBA Code: Automation of Data and Formatting in Excel
    • Lecture 13 :
    • Using previous project VBA Code to create automation
    • Lecture 14 :
    • Finalising all the VBA code
  • Section 11 : PowerPoint 5 Lectures 00:26:24

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Effective Presentation - Part 1
    • Lecture 3 :
    • Effective Presentation - Part 2
    • Lecture 4 :
    • Effective Presentation - Part 3
    • Lecture 5 :
    • Creation of first presentation and saving
  • Section 12 : Basic text formatting 5 Lectures 00:24:32

    • Lecture 1 :
    • Creating Slides and text boxes
    • Lecture 2 :
    • Formatting - Part 1
    • Lecture 3 :
    • Formatting - Part 2
    • Lecture 4 :
    • Formatting - Part 3
    • Lecture 5 :
    • Working with Layout Themes
  • Section 13 : Graphics and multimedia 6 Lectures 00:30:29

    • Lecture 1 :
    • Drawing Shapes- Part1
    • Lecture 2 :
    • Drawing Shapes- Part2
    • Lecture 3 :
    • Handling Images in PPT
    • Lecture 4 :
    • Smart art in Power point
    • Lecture 5 :
    • Audio/Music in Power point
    • Lecture 6 :
    • Videos in Power point
  • Section 14 : Animation and transition 5 Lectures 00:17:31

    • Lecture 1 :
    • Animation in Power point
    • Lecture 2 :
    • Transition in Power point - Part 1
    • Lecture 3 :
    • Transition in Power point - Part 2
    • Lecture 4 :
    • Custom Slides in Power point
    • Lecture 5 :
    • Slide show in Power point
  • Section 15 : Microsoft Access :Introduction- Getting Started with Microsoft Access 3 Lectures 00:12:25

    • Lecture 1 :
    • Introduction
    • Lecture 2 :
    • Working with Access Interface
    • Lecture 3 :
    • Defining data needs and types
  • Section 16 : Creating Database and tables 2 Lectures 00:06:39

    • Lecture 1 :
    • Creating Database
    • Lecture 2 :
    • Creating Table
  • Section 17 : Working with tables and Database records 5 Lectures 00:20:32

    • Lecture 1 :
    • Navigate among records
    • Lecture 2 :
    • Working with Primary Keys
    • Lecture 3 :
    • Find and Replace
    • Lecture 4 :
    • Sorting and Filtering
    • Lecture 5 :
    • Understanding Table Relation
  • Section 18 : Modifying Tables and Fields 2 Lectures 00:07:48

    • Lecture 1 :
    • Modifying DB table
    • Lecture 2 :
    • Creating field and Modifying field
  • Section 19 : Creating Forms 2 Lectures 00:06:03

    • Lecture 1 :
    • 1. Creating Forms
    • Lecture 2 :
    • Sorting and filter using forms
  • Section 20 : Creating queries 3 Lectures 00:11:00

    • Lecture 1 :
    • Create Query
    • Lecture 2 :
    • Modifying queries
    • Lecture 3 :
    • Sorting and filtering using queries
  • Section 21 : Creating Reports 1 Lectures 00:04:00

    • Lecture 1 :
    • Create Report
  • Section 22 : Microsoft Outlook 2 Lectures 00:06:51

    • Lecture 1 :
    • Introduction of Outlook
    • Lecture 2 :
    • Introduction- Part 2 - Shortcuts in Outlook
  • Section 23 : Managing Outlook environment 5 Lectures 00:16:53

    • Lecture 1 :
    • Introduction to managing outlook environment
    • Lecture 2 :
    • Mail set-up in Outlook
    • Lecture 3 :
    • Appearance of mail
    • Lecture 4 :
    • Navigation of outlook
    • Lecture 5 :
    • Configuration of program option
  • Section 24 : View, Print and save 5 Lectures 00:15:08

    • Lecture 1 :
    • view attachment in Outlook
    • Lecture 2 :
    • Print option in outlook
    • Lecture 3 :
    • Saving option in outlook
    • Lecture 4 :
    • Search messages in Outlook
    • Lecture 5 :
    • Search option- Final
  • Section 25 : Mails Managing 6 Lectures 00:23:38

    • Lecture 1 :
    • Managing mail - Introduction
    • Lecture 2 :
    • Mail signature
    • Lecture 3 :
    • Creating rules in outlook
    • Lecture 4 :
    • Rules within rules in outlook
    • Lecture 5 :
    • Update and delete rules in Outlook
    • Lecture 6 :
    • Junk Email setup in Outlook
  • Section 26 : Messages and formatting messages 3 Lectures 00:10:08

    • Lecture 1 :
    • Create mail in Outlook
    • Lecture 2 :
    • Configuring messages in Outlook
    • Lecture 3 :
    • Recall messages in outlook
  • Section 27 : Format Message 5 Lectures 00:20:17

    • Lecture 1 :
    • Fonts in Outlook messages
    • Lecture 2 :
    • Insert in Outlook messages
    • Lecture 3 :
    • Themes and styles in Outlook
    • Lecture 4 :
    • Hyperlink in Outlook
    • Lecture 5 :
    • Images insert in Outlook
  • Section 28 : Arranging and Managing 2 Lectures 00:07:11

    • Lecture 1 :
    • Managing and arranging mails in outlook
    • Lecture 2 :
    • Managing and arranging mails in outlook- Part 2
  • Section 29 : Calenders 5 Lectures 00:19:55

    • Lecture 1 :
    • Calender in outlook
    • Lecture 2 :
    • Calender in outlook- Part 2
    • Lecture 3 :
    • Appointment in Outlook
    • Lecture 4 :
    • Meetings in Outlook
    • Lecture 5 :
    • Meetings in Outlook- Part 2
  • Section 30 : Task and to do list 2 Lectures 00:07:36

    • Lecture 1 :
    • Task and To-do list
    • Lecture 2 :
    • Task and To-do list- Part 2
  • Section 31 : Contacts and groups 1 Lectures 00:03:12

    • Lecture 1 :
    • Contact and group
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

276103 Course Views

6 Courses

I am a software engineer and stock market analyst with 8+ years of experience. Author of 12+ courses with more than 60,000 students. I am very passionate about teaching office productivity, software programming, and stock market analysis. I have gained experience in a wide range of industries Investment banking, Retail, and Insurance industry. Worked with teaching several corporate on Office productivity and Programming.
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.