Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Quickly Learn How to Master Microsoft Excel 2013 and 2016 – Beginner
Become Proficient with Excel and Its Powerful Data Functions Using These Training Classes
Effortlessly Bring Important Data Together
If you're new to Excel, then you should take this class, and master all of its frequently used features. From showing you how to do a calculation, to creating useful graphs and tables, all of that is available so that you can understand your data better. There's a lot more to it than that though. This is a tool you just can't be without. In fact, when it comes to making the most of resources, and maximizing return on investment, this is the best thing out there.
Our course was designed for beginners who are familiar with Excel, but would like to improve their skills and see what else they can do with this unique and handy program. One benefit to taking this comprehensive course and using Excel is that it will be a huge time saver.
How, you ask? Excel saves you time by offering an intuitive graphical user interface. When you think of what Excel is good at, you probably first think of data manipulation: filtering, sorting, tabulating and calculating all kinds of information and data. You can use these easy-to-understand classes to reach the next level of database tracking and reporting.
Contents and Overview
Through hours of content, this beginner's course will take you through learning how to use functions for all your work-related issues. Many functions are covered including payments, future value, and depreciation. Learn statistical functions like averages, percentiles, and regression too. Excel's extensive data tools are very impressive as they can also provide the benefit of a shortened workload. In other words, this course shows you how to master this special and versatile spreadsheet program so that you can import and export common and not-so-common data formats, which reduces your need for specialized software.
This new course will easily help improve your efficiency as we cover many of Excel's core concepts. Understanding pivot tables and data analysis, for example, will be important for you moving forward. For help with reporting, you will learn stock charts, surface charts, radar charts, and bubble charts - just to list a few. A very easy to use and well-structured course.
Upon completion of this course, you'll be able to effectively create charts and graphs for personal or company records. You'll also be able to access the ribbon (and other tools), allocate valuable resources, meet tight deadlines, manage extra tasks, manage data, and much more. The material found inside is easily laid out and quite relevant.
So, take this course to possess all the skills necessary to organize and deliver your projects in the most efficient and effective way possible!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Excel 2016: Introduction|
Acquiring Excel 2016 and Information on Installation and UpgradePreview
Course exercise filesPreview
IMPORTANT - Read this to ensure the best video quality!
The course exercise files consist of a single .ZIP file. You will need to download the Excel 2016 Course Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.
Excel 2016 Course Demo Files
Section 1 Quiz
|Section 2: Excel 2016: What's New|
New and Improved Features in Excel 2016Preview
|Section 3: Excel 2016: Using Touch|
Overview of Principles of Using Touchscreen
|Section 4: Excel 2016: Getting Started|
Creating and Saving a WorkbookPreview
Opening a Workbook
|Section 5: Excel 2016: Using Help|
Online Help and Contextual Help
Section 5 Quiz
|Section 6: Excel 2016: Excel Options|
Personalizing Your Use of ExcelPreview
Section 6 Quiz
|Section 7: Excel 2016: The Ribbon and Toolbars|
Basics of using the RibbonPreview
Quick Access Toolbar
Tell Me Feature
Mini Toolbars and Contextual Menus
Section 7 Quiz
|Section 8: Excel 2016: Entering and Editing Data|
Basics of Entering and Editing Data in a WorkbookPreview
Section 8 Quiz
|Section 9: Excel 2016: Backup and Recovery|
AutoSave, Recover Unsaved Workbook, and Create a Backup Copy
Section 9 Quiz
|Section 10: Excel 2016: Fill and Series|
Working with Fill and SeriesPreview
Section 10 Quiz
|Section 11: Excel 2016: Viewing and Printing|
Workbook Views, Zoom, and Freeze
Section 11 Quiz
|Section 12: Excel 2016: Cut, Copy, and Paste|
Methods of Cutting, Copying, and Pasting
Section 12 Quiz
|Section 13: Excel 2016: Formatting a Worksheet|
Delete and Clear
Insert, Hide, Column Width and Row Height, and Merge
Themes and Styles
Section 13 Quiz
|Section 14: Excel 2016: Formulas and Functions|
Basics of Fomulas and FunctionsPreview
Complex Examples of Formulas
Section 14 Quiz
|Section 15: Excel 2016: Managing Worksheets|
Rename, Insert, Move, and Reference a Worksheet
Section 15 Quiz
|Section 16: Excel 2016: Working with Multiple Workbooks|
Working with Multiple Workbooks
Section 16 Quiz
|Section 17: Excel 2016: Saving Workbooks|
Saving in Different File Types
Section 17 Quiz
|Section 18: Excel 2016: Proofing|
The Spell Checker
|Section 19: Excel 2016: Inserting Comments|
|Section 20: Excel 2016: Basic Functions in Excel|
The VLOOKUP FunctionPreview
Date and Time Functions
Section 20 Quiz
|Section 21: Excel 2016: Graphs and Charts|
Creating Graphs and ChartsPreview
Customizing a Cluster Column Chart
Customizing a Pie Chart
New Chart Types in Excel 2016
Section 21 Quiz
|Section 22: Excel 2016: Sorting and Filtering Data|
Managing Data by Sorting
Managing Date by Filtering
Section 22 Quiz
|Section 23: Excel 2016: Shapes and Pictures|
Inserting Shapes and Pictures
Section 23 Quiz
|Section 24: Excel 2016: Formatting Cells Based on Content|
Section 24 Quiz
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,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 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.