Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications 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 Certification Network & Security Hardware Operating Systems 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 Design Thinking 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 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 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 Yoga Mental Health Dieting 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 Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development SwiftUI Kotlin
Digital Marketing Google Ads (Adwords) Social Media Marketing Marketing Strategy Google Ads (AdWords) Certification Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-03-04 11:45:43
30-Day Money-Back Guarantee
Office Productivity Microsoft Microsoft Office

The Ultimate Microsoft Office 2016 Training Bundle

The Most Convenient Way to Boost Your Confidence And Learn MS Office 2016 Inside And Out—Quickly, No Travel or Classes.
Rating: 4.4 out of 54.4 (3,601 ratings)
17,622 students
Created by Simon Sez IT
Last updated 3/2021
English
English [Auto], Italian [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Discover new and improved features in Excel 2016.
  • How to effectively use Excel 2016 on a touchscreen device.
  • How create, save, and open a workbook.
  • Learn how to personalize your use of Excel using Excel Options.
  • How to use and how to customize the Quick Access Toolbar.
  • Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • The basics of entering and editing data in a workbook.
  • Learn practical methods in which you can backup and recover your Excel spreadsheets.
  • Effectively use autofill and flashfill so you are more productive.
  • Discover the essentials of using fomulas and functions.
  • How to rename, insert, move, and reference an Excel 2016 worksheet.
  • Discover how to create charts and graphs
  • Learn practical methods to sort and filter your data
  • How to protect and secure your Excel data
  • Discover new features in PowerPoint 2016
  • Learn presentation tips for an effective presentation
  • Discover how to format text on a PowerPoint slide
  • Learn how to insert shapes, graphics and pictures to add some "zing" to your presentation
  • Add charts, graphs and tables to present information in a non-text format
  • Wow your audience by adding animations, audio and video
  • Discover practical tips to present your presentation to your audience
  • Learn time saving techniques including how to copy slides, and exporting your presentation
  • Customize PowerPoint for greater productivity by customizing the Microsoft Office Ribbon
  • Master the most common uses of Word
  • How to controlling page appearance including using columns, indents, footers, borders and watermarks
  • Learn to create many types of documents
  • How to create a mail merge
  • Printing envelopes and labels
  • Discover different page setup options
  • How to protect your document from changes
  • Learn how to spell check your documents
  • Insert pictures and graphics in your Word document
  • Discover how to insert and edit tables
  • Using "Go To, Find, and Replace"
  • How to create, save and open documents
  • Learn cool tips and tricks in the Ribbon
  • Discover common Excel hotkeys
  • How to use VLOOKUP and HLOOKUP
  • Learn how to use popular functions
  • Discover how to use named ranges
  • Discover the power of Dynamic Formulas and how to use them
  • Get advanced level tips for creating awesome charts and graphs
  • How to work with and analyze your data using data slicers, PivotTables, Power Query and PivotCharts
  • Setting up email accounts
  • Using Outlook on a touch device
  • Creating and sending email messages
  • Organizing email
  • Calendar appointments and attachments
  • Create and manage meetings
  • Adding email signatures
  • How to archive email
  • Spam and junk mail removal
  • Creating and managing tasks and reminders
  • Using the mail merge feature to import contact information to Microsoft Word
  • Adding, managing and searching contacts in the address book
  • Creating filters to automate incoming messages
  • Practice what you learned with included exercise files

Requirements

  • Microsoft Office 2016 desktop version for Windows installed and ready to use on your computer.

Description

** We've crammed 9 courses into this amazing Microsoft Office bundle. Unlock the secrets of Office 2016 or 365 with this 60+ hour mega-course. Practice exercises included**


Master the Ins and Outs of Microsoft Office and Boost Your Productivity   


This 10 COURSE BUNDLE includes:

  • Microsoft Excel 2016 (beginners) - learn the basics of spreadsheets

  • Microsoft Excel 2016 (intermediate) - take those spreadsheet skills to the next level

  • Microsoft Excel 2016 (advanced) - master spreadsheets 

  • Microsoft Word 2016 - master documents

  • Microsoft PowerPoint 2016 - master presentations 

  • Microsoft Access 2016 - master databases 

  • Visual Basic for Applications (VBA)  for Microsoft Excel - master spreadsheet automation

  • Microsoft Outlook 2016 - Master e-mail and calendar management

  • Macros and VBA for Beginners (added March 2021)

  • OneNote Desktop and Windows 10 (added March 2021)


Over 500, 5 Star Reviews:


"Undoubtedly, this course covers a wide range of topics done in an extremely professional manner. This is worthy of every second and penny I invested in it. It helped me understand various contours of Microsoft Office." - Muhammad Bashir

"Very clear and thorough. Super for beginners." - Anna Wyk

"This is what I needed and what I was looking for. Excellent course."  - Roberto Regalado

"My experience with this course was absolutely beneficial to me. The lecturers are so good at explaining the course and not forgetting the exercises they set up for you is amazing it really helps and it gives you experience as you go along with them." - Jennade Ramruthen


Improve Efficiency with Microsoft’s Premier Office Management Software   

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 from these 8 courses in one bundle.

Master Microsoft Excel, start at the beginning if you're brand new to spreadsheets or pick up at Intermediate or Advanced level. For those looking to go beyond normal data analysis, you'll learn how to handle databases using Microsoft Access or automate mundane tasks in Excel using VBA.

If that wasn't enough this bundle will teach you how to utilize PowerPoint to create stunning presentations, use Microsoft Word to create documents that inspire and make administration a breeze through learning about mail merge.


** Recently added - unlock the power of Microsoft Outlook 2016 and dramatically improve your productivity and sanity through a clear inbox.**


Bundle Overview   


This course is designed for individuals and office professionals who need to master the capabilities of the 2016 or 365 editions of Microsoft Office. With more than 60 hours of video lectures across 8 courses, this course will help you master MS Office 2016, reduce your MS Office frustration and help you claw back the precious time you spend getting lost in these powerful business applications.


  • Excel 2016 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses. 

  • Excel 2016 Intermediate: Use complex formulas and perform data analysis on your organization’s revenue and expense patterns. 

  • Excel 2016 Advanced: Take your Excel skills to the ultimate level with advanced charts, graphs, formulas, and data analysis.

  • Word 2016: Create documents, embed videos, and set up online collaboration on joint projects for school or work. 

  • PowerPoint      2016: Make impactful presentations for your next business meeting using animation, audio/video, and collaborative tools. 

  • Access 2016 for Beginners: Become a master of data management, customer tracking, and buying patterns. 

  • Microsoft Essential VBA for Excel: Learn how to automate repetitive and time-consuming Excel procedures and operations for maximum efficiency. 

  • Master Microsoft Outlook 2016 the Easy Way: Introductory course on email efficiencies to help clear the email clutter and gain control of your inbox.

  • Macros and VBA for Beginners (added March 2021): Learn to create your first Macro and perform basic VBA in Excel

  • OneNote Desktop and Windows 10 (added March 2021): Learn all about using OneNote to store your notes and organize your life!

When you complete this course, you’ll be well on your way to becoming a master of workplace efficiency with the tools available in Microsoft Office 2016.

   

Why Take This Course   

  • Optimize your productivity at work or in your own business.

  • Get noticed by your boss and earn the respect of your colleagues. Become the office superstar by being the go-to expert on everything related to MS Office 2016.   

  • Amazing value 9-courses in one bundle. You get professional quality training at a fraction of the normal price.


Why Simon Sez IT for Microsoft Office?

  • We know Microsoft Office. We've been teaching it for over 10 years and your expert instructors have taught thousands of people to learn Microsoft products.

  • We don't rush through content. We take the time to ensure you understand important principles before moving on.

  • Follow along. We provide downloadable practice files so you can practice as you learn.


** Updated May 2018: Outlook 2016 course added**

** Updated March 2021: OneNote and Macros and VBA for Beginners added**

Who this course is for:

  • Those new to using Microsoft Excel, Outlook, Access, PowerPoint, and Word 2016
  • This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel, Outlook, Access, Word and PowerPoint
  • Users of earlier versions of Access, Excel, Outlook, Word and PowerPoint

Featured review

Amaan Hussain
Amaan Hussain
304 courses
1 review
Rating: 5.0 out of 57 months ago
This is the first time I have attended a class in this format and wondered how effective it would be. It was very effective and therefore I would definitely be interested in attending other classes in the same format. The instructor was very knowlegeable and provided a wealth of information about the MS Office

Course content

160 sections • 613 lectures • 72h 3m total length

  • Acquiring Excel 2016 and Information on Installation and Upgrade
    Preview12:02
  • WATCH ME: Essential Information for a Successful Training Experience
    02:11
  • Excel 2016 Course Exercise Files
    00:23
  • Excel 2016 Course Demo Files
    00:23
  • Preview02:28
  • Downloadable Course Transcripts
    00:19

  • Preview02:55

  • Preview05:36

  • Creating and Saving a Workbook
    15:16
  • Opening a Workbook
    10:13

  • Online Help and Contextual Help
    06:27

  • Personalizing your use of Excel
    10:50

  • Preview14:56
  • Quick Access Toolbar
    05:45
  • Tell Me Feature
    06:49
  • Mini Toolbars and Contextual Menus
    03:47
  • Status Bar
    05:02

  • Basics of Entering and Editing Data in a Workbook
    Preview13:29
  • Exercise 01
    01:50
  • Formatting Dates
    12:36
  • Formatting Numbers
    13:48
  • Exercise 02
    01:43

  • AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
    07:35

  • Working with Fill and Series
    09:08
  • Flash Fill
    04:04

Instructor

Simon Sez IT
460,000+ Students | Wordwide Use 180 Countries |150+ Courses
Simon Sez IT
  • 4.4 Instructor Rating
  • 47,708 Reviews
  • 484,533 Students
  • 166 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.