The Ultimate Microsoft Excel 2013 & 2016 Mastery Course
4.4 (47 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
338 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate Microsoft Excel 2013 & 2016 Mastery Course to your Wishlist.

Add to Wishlist

The Ultimate Microsoft Excel 2013 & 2016 Mastery Course

Master Microsoft Excel 2013 and 2016 The Easy Way - On Your Schedule. 4 Courses, 37 Hours of Training.
4.4 (47 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
338 students enrolled
Created by Simon Sez IT
Last updated 7/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 38 hours on-demand video
  • 12 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Discover new and improved features in Excel 2013 and 2016
  • How to effectively use Excel 2013 or 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
  • Discover how to format dates and numbers
  • 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
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface
  • Tips for mouse and touch screen users
  • Graphs and charts using templates or custom designs
  • Pivot tables and slicing
  • Working with flash fill
  • Working with dates and times
  • Averages, percentiles, and LINEST functions
  • Calculating depreciation
  • Inserting and formatting tables
  • Sparklines and data bars
  • How to import and export data to and from Excel
  • Discover practical methods for financial & statistical​ Functions
  • Using financial functions to determine payments
  • Practice what you learned with included exercise files
View Curriculum
Requirements
  • Microsoft Excel 2013 or 2016 desktop version for Windows installed and ready to use on your computer.
Description

Learn Microsoft Excel 2013 & 2016 Inside and Out with This 4 Course Training Bundle

  • Includes 4 Courses: The Excel 2013 & 2016 Beginner Courses & The Excel 2013 & 2016 Advanced Courses
  • Includes 37-Hours of High Quality Training by Your Professional Trainer
  • Taught by a Professional Trainer
  • Practice Along With Included Exercise Files
  • Watch and Learn with Demo Project Files That are Included
  • Progresses Logically from Beginning to Advanced Topics
  • Starts Right at the Beginning with an Easy Intro to the Software
  • Deepen Your Knowledge and Master More Advanced Skills
  • Learn to Create Charts and Graphs
  • Creating Charts and Graphs
  • Effectively Create and Use Functions and Formulas
  • Import and Export Data 
  • Create and Effectively Use Pivot Tables
  • How to Use Excel for Data Analysis
  • Discover Practical Methods for Financial  & Statistical Functions

This bundle includes:

  1. 4 individual courses
  2. 37 hours of video tutorials
  3. Over 200 individual video lectures
  4. Exercise files to practice what you learned
  5. Printable course transcriptions to follow along and take notes
  6. Certificate of completion

Contents and Overview for the 9-Hour Excel 2016 Beginner Course

This course starts with where to find Microsoft Excel and installing the program. Then you learn step-by-step, simple 1-2-3 methods for getting up and running with Excel 2016. Watch just the first few videos to have a basic knowledge of Excel. Then continue through the detailed 32 chapters of video lessons and 9 exercise files to gradually become a proficient user.

It's important to note that we don't assume you know anything about Excel 2016. We start from the basics. After installation we discuss what is new with 2016, using Touchscreen, opening a Workbook, and how to use Help to get additional answers when you need them.

Then we show you how to personalize Excel for your own use with exciting Excel Options. We discuss all the Ribbons and Toolbars, entering and editing data, backup and recovery, fill and series, and printing your projects. We also work with formulas, functions, sorting and filtering data, creating charts and graphs, and much more.

Upon completion of this course you will know the essentials of Microsoft Excel 2016.

Contents and Overview for the 9-Hour Excel 2016 Advanced Course

Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Microsoft Excel 2016 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.

Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you'll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.

Contents and Overview for the 10-Hour Excel 2016 Beginner Course

Impress the people you work with by cultivating advanced spreadsheet skills. During this 10-hour training course, you’ll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you’ll discover how to enter and format data in the quickest manner possible.

Next you’ll be introduced to the power of Excel’s functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you’ll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise.

Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 training course will give you the skills you need to stand out at work.

Contents and Overview for the 9-Hour Excel 2013 Advanced Course

Through 52 lectures and over 12.5 hours of content, this course will take you through learning how to use functions in everyday work environments. Personal and professional financial functions are covered including payments, future value and depreciations. Students will learn statistical functions like averages, percentiles, and regression.

In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.

For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs. Lastly, students will cover important web applications.

Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with strategizing and planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.

** Updated July 2017. English close captions added

** Updated June 2017. Course transcripts now available.


Who is the target audience?
  • Those new to using Microsoft Excel 2013 or 2016.
  • No previous knowledge of Excel required. This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel.
  • Users of earlier versions of Excel looking to update their skills.
  • Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2013 or 2016 knowledge.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
234 Lectures
37:55:06
+
Excel 2013: Introduction to Excel 2013 Beginner Course
5 Lectures 19:21

Essential Information for a Successful Training Experience
01:53

Excel 2013 Exercise Files
00:25

Downloadable Course Transcripts
00:19

+
Excel 2013: Using Touch
1 Lecture 03:39
+
Excel 2013: Help
1 Lecture 08:00
Online, Offline, and Contextual Help
08:00
+
Excel 2013: Settings and Preferences
1 Lecture 11:22
Excel Options
11:22
+
Excel 2013: The Ribbon and Toolbars
3 Lectures 26:01
Ribbon Interface
15:00

Quick Access Toolbar
08:03

Mini Toolbar
02:58
+
Excel 2013: Backup and Recovery
1 Lecture 06:54
Create Backup Option; Auto-Recover and Autosave
06:54
+
Excel 2013: Entering and Deleting Data
5 Lectures 01:04:26
Entering Text and Numbers
15:15

Date Formats
15:57

Formatting Cells; Editing and Deleting Data
15:15

Fill
12:51

Flash Fill
05:08
+
Excel 2013: Formatting a Worksheet
5 Lectures 01:03:32

Inserting, Deleting, Hiding and Adjusting Rows and Columns
13:28

Wrap Text and Alignment
15:02

Merging Cells; Applying Themes and Styles
11:36

Borders
09:25
+
Excel 2013: Copy, Paste and Paste Special
1 Lecture 17:06
Copy, Cut and Paste
17:06
82 More Sections
About the Instructor
Simon Sez IT
4.4 Average rating
11,481 Reviews
303,192 Students
117 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ 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 80+ courses and 4,500+ 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 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.