The Ultimate Microsoft Excel 2013 & 2016 Mastery Course

Course details

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