Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 CompTIA Security+
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Data Analysis Data Warehouse
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

Office ProductivityMicrosoftMicrosoft Office 365

Microsoft Office 365 | Ultimate Bootcamp 2022

WORD, EXCEL, ACCESS, POWERPOINT, PUBLISHER & TEAMS
Rating: 4.1 out of 54.1 (223 ratings)
16,088 students
Created by Ahad Shalwani
Last updated 11/2020
English
English [Auto]

What you'll learn

  • Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Publisher, Teams and Access
  • Learn the essentials of using formulas and functions in Excel
  • Learn practical methods to sort and filter your data in Excel
  • Learn how to use and how to customize the Quick Access Toolbar.
  • Learn to use autofill and flashfill so you are more productive in Microsoft Excel.
  • Learn data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • Learn how to rename, insert, move, and reference an Excel worksheet.
  • Learn how to insert shapes, graphics and pictures to your PowerPoint
  • Learn how to add charts, graphs and tables to your PowerPoint presentation information in a non-text format
  • Learn practical tips to present your PowerPoint presentation to your audience
  • Learn how to customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon
  • Learn Word tools including using columns, indents, footers, borders and watermarks.
  • Learn how to create a mail merge in Microsoft Word
  • Learn to protect your Word document from changes
  • Learn how to make your Word documents look amazing by inserting and editing tables
  • Learn sorting information and running queries in Access
  • Learn how to into import data from Excel in Access
  • Learn forms, queries, use validations, how to create and print reports in Access
  • Learn how to create a linked table in Access
  • Learn how to create event card in Publisher
  • Learn how to edit different event cards in Publisher
  • Learn how to create or join team in Teams
  • Learn how to add, remove members in Teams

Requirements

  • Basic Computer Knowledge
  • Microsoft Office 365 or 2019 must be installed on your computer

Description

**This course includes 10 hours of on-demand video lectures, practice exercises and LIFETIME access**

Learn Excel, PowerPoint, Access, Word, Teams, and Publisher 365 in one course

The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.

This course is designed to help you accomplish office tasks easily and with greater efficiency, Microsoft Office is the choice of many office professionals. If you're working in an office, you'll likely need to use the Microsoft Office suite and it's likely you're working for it, rather than having it work for you. Turn that around today and finally learn all the deep, dark secrets of Microsoft Office.

Microsoft Word 365

  • How to get started with Word 365

  • Word 365 basics including navigation, editing and saving

  • Character formatting in Word including Format Painter and AutoCorrect

  • How to properly work with bullets and numbering in Microsoft Word

  • All about formatting paragraphs and managing lists

  • Working with Tables in Word including formatting, converting data and formulas

  • Page appearance including page-breaks, watermarks and styles

  • All about Sectioning a document

  • Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)

  • How to work with envelopes and labels

  • All about mail-merge and operating Word at scale

  • How to create an Index or Contents page

  • Reviewing and Printing in Word and Page Setup

  • Protecting a Word document and basic macros in Word

Microsoft Excel 365

  • Creating workbooks

  • Entering text, numbers and working with dates

  • Navigating workbooks

  • Page setup and print options

  • Working with rows, columns, and cells

  • Cut, Copy and Paste

  • Introduction to Functions and Formulas

  • Formatting in Excel, including formatting cells and numbers

  • Creating charts and graphs

  • Sorting and Filtering

  • Introduction to PivotTables

  • Logical and lookup formulas - the basics

  • Advanced charting and graphing in Excel

  • How to use detailed formatting tools

  • Lookup and advanced lookup functions

  • Statistical functions

  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

  • Mastery of PivotTables and Pivot Charts

  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

Microsoft Access 365

  • All about importing data and the datasheet view

  • How tables work in Access and how to create relationships between them

  • Creating forms and sub-forms that feed data into your tables

  • How to run queries in Access

  • Setting up validations and calculations using expressions in Access

  • Printing from Access

  • To start to use macros and Modal Dialog

  • The basics of the Access web app

  • Exporting and reporting in Access

  • About Primary Keys and Indexes in Access

  • About customizing and filtering on the Datasheet View

  • How to link to other databases

  • All about Macros in Access

  • More advanced techniques around creating forms in Access

  • Advanced queries

  • Generating reports

Microsoft PowerPoint 365

  • How to navigate around PowerPoint

  • Presentation dos and don'ts

  • Text and bullet edition options

  • How to use graphics, images, objects and shapes

  • Using SmartArt

  • Working with Charts and Graphs

  • How to utilize Master Slides and just how much time this could save you

  • How to add audio and video to a presentation

  • All about transitions & animations between slides

  • Setting your slideshow options

  • Presentation preparation and delivery

  • The backstage area of PowerPoint including printing a presentation

Microsoft Publisher 365

  • How to create and use event template

  • Customizing template

  • Text and bullet edition options

  • How to use graphics, images, objects and shapes

  • Adding color schemes 

Microsoft Teams

  • How to create your first team and manage members and channels

  • All about posting and receiving public and private messages

  • How to do user announcements, tags, and message extensions

  • How to schedule an audio or video call

  • How to use the audio and video calling options including recording calls

  • How to use the meeting notes function

  • All about using built-in apps

  • How to adjust admin and user settings




Who this course is for:

  • Anyone new to Microsoft Office or upgrading from a previous version
  • Anyone looking to improve their productivity by mastering MS Office

Featured review

Milford Saname
Milford S.
5 courses
2 reviews
Rating: 4.5 out of 5a year ago
The course was quick but informative. You can always review it again and for me understanding the benefits of using templates gives a basic foundation to complete a project. In some parts I was lost because of pronunciation of words, however I feel the instructor is certainly more than qualified. Job well done, the course is worth it especially if you are seeking a position where Microsoft Office skills are needed!

Instructor

Ahad Shalwani
Electrical Engineer
Ahad Shalwani
  • 4.3 Instructor Rating
  • 638 Reviews
  • 36,783 Students
  • 4 Courses

I am an Electrical Engineer by Profession and passionate educator. I have deep interest in automation, designing & drafting and robotics. I love to implement innovative 3D-Learning methods to make education easy & interesting.

I love to meet professors, teachers, educators, instructors to discuss & share Innovative tools of learning technology.

I've also had the pleasure of designing most of the same systems I used to program. My competencies in this area include full design, 3D modeling and drafting of assembly and fabrication drawings in Auto-CAD.

Apart from my professional life I like to play mobile games and I often play outdoor games like Cricket and Soccer.


Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.