Ultimate Microsoft Excel 2016 Course - Beginner to Expert
Learn all the tools you'll need to become a Microsoft Excel power user with this effective MS Excel 2016 training bundle
Learn Microsoft Excel 2016 Inside and Out with This 3-Course Training Bundle
- Includes 3 complete courses: The Excel 2016 Beginner Course, Learn Excel 2016 Intermediate Level - Beyond the Basics & The Excel 2016 Advanced Course
- Includes over 22 hours of high-quality, video training by your professional trainer
- Practice along using exercise files
- Watch and learn with demo project files
- Progresses logically from beginning with an easy intro to advanced topics
- Learn to Create Charts and Graphs
This bundle includes:
- 3 complete courses
- 22 hours of video tutorials
- Over 100 individual video lectures
- Exercise files to practice what you learned
- Demo files used by the trainer
- Certificate of completion
What You'll Learn:
Microsoft Excel for Beginners
- Step-by-step, simple 1-2-3 methods for getting started with Excel 2016.
- The ribbon and how to personalise Excel in the options tab
- What's new in Excel 2016
- Working with a touchscreen in Excel
- Entering data in Excel
- Backing up, recovering and saving your workbooks
- How to print (the thing you want!) in Excel
- How formulas work and the basic formulas you need to know
- How to sort and filter data to see what you want
- Creating Tables
- Creating graphs and charts to bring your data to life
Microsoft Excel - Intermediate
- Starts where the beginning Excel course concluded.
- Tips and tricks to make the most of the ribbon
- Hotkeys and different views in Excel
- INDEX, MATCH
- VLOOKUP, HLOOKUP
- INDIRECT and OFFSET
- Named Ranges
- Dynamic functions and how they work
- More advanced charts like Waterfall and Sunburst
- Detailed chart formatting
- PivotTables, Pivot Charts, slicers and Power Query
Advanced Microsoft Excel:
- How to create amazing looking charts and graphs
- Complex Time and Date functions
- VLOOKUP, HLOOKUP
- Statistical functions
- Using Excel for forecasting
- Connecting to external databases including Access and live web sources
- Advanced Tables, including Styles and References
- Advanced PivotTable uses including using filters, slicers and Pivot Charts
- Goal Seek, Scenario Manager and Solver
- Advanced charts such as Stock charts, Bubble Charts, Radar Charts and Sparklines
- Using the Excel web app
Exercise files, demo files and optional quizzes and certificate of completion are all available to you during and upon completion of the course.
Courses Included with Purchase
Original Price: $250
Frequently Asked Questions
All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.
All of our courses are compatible with both Windows (PC) and Mac computers.
Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.
We offer Certificates of Completion for courses that offer an online quiz (currently over 50% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.
Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ to get additional details about the Ultimate Training Library membership.
Yes, we offer group discounts or multiple users. Contact [email protected] for more information.
Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.
Yes, you can interact with others by using the discussion section offered for each course.
We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 80 courses, with tens of thousands of satisfied customers in over 100 countries.