4.5  58 reviews on Udemy

Ultimate Excel Beginner to Advanced Bundle

Beginner to Advanced Excel training from Excel experts Simon Sez IT in all recent Excel versions (2013, 2016 or 2019)
Course from Udemy
 301 students enrolled
 en
The new and improved features in Excel 2013, 2016 and 2019
Learn to master data analysis tools like Pivot tables, Slicers, Sparklines and Data Bars in Excel
Learn essential logical functions like IF, SUMIF, COUNTIF
Learn powerful Lookup Functions VLOOKUP, HLOOKUP and INDEX MATCH
Discover how to format dates and numbers in Excel
Learn practical methods in which you can backup and recover your Excel spreadsheets
Effectively use autofill and flashfill so you are more productive in Excel
You'll cover all the basics like how to rename, insert, move, and reference an Excel worksheet
Discover how to create awesome charts and graphs in Excel
Learn practical methods to sort and filter your data using Microsoft Excel
You'll learn financial and statistical functions like calculating depreciation
You'll find out about using Conditional Formatting to tell a story with your data in Excel
How to import and export data to and from Excel

**This course includes practice exercises and LIFETIME access**
**Excel 2019 now included**


Everything you need to become a spreadsheet guru in Microsoft Excel from Beginner to Advanced users by Excel experts Simon Sez IT. Separate lessons for 2013, 2016, and 2019, pick your version!


Excel for Beginners

With this Microsoft Excel beginners course, you’ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2013, 2016, 2019 or Excel 365 editions. This course is perfect if you’re brand new to Excel or are upgrading from an older version.


What You'll Learn

  • What's new in Excel

  • 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 Excel

With this comprehensive, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.


What You'll Learn

  • Advanced charting and graphing in Excel

  • How to use detailed formatting tools

  • Lookup and advanced lookup functions

  • Financial functions including calculating interest and depreciation

  • Statistical functions

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

  • How to create awesome visualizations using sparklines and data bars

  • Mastery of PivotTables and Pivot Charts

  • Scenario Manager, Goal Seek and Solver

  • Advanced charts such as Surface, Radar, Bubble and Stock Charts (version dependent!)

***Exercise files included with all courses***

BONUS: Excel 2016 Intermediate now included!


This 7-course bundle includes:

  1. Excel 2019 Beginners: 95 Videos, 7.5 Hours

  2. Excel 2019 Advanced: 57 Videos, 8 Hours

  3. Excel 2016 Beginners: 65 Videos, 9 Hours

  4. Excel 2016 Intermediate: 39 Videos, 4.5 Hours

  5. Excel 2016 Advanced: 57 Videos, 9 Hours

  6. Excel 2013 Beginners: 54 Videos, 10 Hours

  7. Excel 2013 Advanced: 47 Videos, 9 Hours

And if that wasn't enough. You also get:

  1. Exercise files to practice what you learned

  2. Certificates of completion


Summary

This Excel mega bundle is designed for students of all Excel capabilities. If you are brand new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel developments, then the start at the beginning.

If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level.


Multiple Versions

If you're upgrading from an older version of Excel or know that an upgrade is around the corner, then this package is for you as it includes courses covering 2013, 2016 and 2019.


Outcomes

Upon completion of this course, you'll have a great grounding in Excel formulas and functions. You’ll be confident in navigating, sharing and using spreadsheets in a variety of ways.

You’ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.

You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.



Here’s what our students are saying…

“As an engineering student, i could say that this course covers the whole tutorials about optimization tools for professionals.”
- Uayur Uygun

“The course provided a detailed view of all the new features of excel 2019. The examples and exercises provided a great platform to develop and build on the knowledge I acquired over the course.”
- Peter Marshall

"Well structured easy to follow content. This course helped me pass my college coursework at full distinction. :)"
- Andrew Mcmaster"


Did you know?


Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Ultimate Excel Beginner to Advanced Bundle
$ 94.99
per course
Also check at

FAQs About "Ultimate Excel Beginner to Advanced Bundle"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.

SOCIAL NETWORK