Ultimate Excel Beginner to Advanced Bundle

Master Microsoft Excel: From Beginner to Advanced

Become an Excel expert with this comprehensive course, perfect for beginners and experienced users alike! Get lifetime access and Excel 2019 included! Taught by Excel experts at Simon Sez IT, this course covers everything you need to master Microsoft Excel, regardless of your current skill level. Choose the version that suits you: 2013, 2016, or 2019.

Excel for Beginners: Build a Solid Foundation

This Microsoft Excel beginners course provides a thorough introduction to the core features of Excel. Ideal for those new to spreadsheets or upgrading from older versions (including Excel 2013, 2016, 2019, and 365).

What You'll Learn:

• Excel Basics: Entering text, numbers, and dates.
• Workbook Navigation: Effortlessly navigate your spreadsheets.
• Page Setup & Printing: Control how your spreadsheets look when printed.
• Cell & Data Management: Working with rows, columns, and cells.
• Data Manipulation: Mastering Cut, Copy, and Paste.
• Essential Functions & Formulas: Introduction to the power of Excel formulas.
• Formatting: Enhance your spreadsheets with cell and number formatting.
• Charts & Graphs: Create compelling visuals to represent your data.
• Sorting & Filtering: Quickly organize and analyze data.
• PivotTables & Filtering: Introduction to PivotTables for data summarization.
• Logical & Lookup Formulas: Learn the basics of powerful formulas.

Advanced Excel: Unlock Powerful Features

Take your Excel skills to the next level with this in-depth training. Learn to analyze and report on financial information with confidence.

What You'll Learn:

• Advanced Charting & Graphing: Create sophisticated visualizations.
• Detailed Formatting Tools: Fine-tune your spreadsheet appearance.
• Lookup Functions: Master lookup and advanced lookup formulas.
• Financial Functions: Calculate interest, depreciation, and more.
• Data Connectivity: Connect to external data sources like MS Access and the web.
• Sparklines & Data Bars: Create impactful data visualizations.
• PivotTable & PivotChart Mastery: Become proficient in data analysis.
• Scenario Manager, Goal Seek & Solver: Advanced tools for data modeling and optimization.
• Advanced Chart Types: Explore Surface, Radar, Bubble, and Stock Charts (version dependent).

Exercise files included with all courses!

BONUS: Includes Excel 2016 Intermediate!

This 7-Course Bundle Includes:

• Excel 2019 Beginners: 95 Videos, 7.5 Hours
• Excel 2019 Advanced: 57 Videos, 8 Hours
• Excel 2016 Beginners: 65 Videos, 9 Hours
• Excel 2016 Intermediate: 39 Videos, 4.5 Hours
• Excel 2016 Advanced: 57 Videos, 9 Hours
• Excel 2013 Beginners: 54 Videos, 10 Hours
• Excel 2013 Advanced: 47 Videos, 9 Hours

Benefits:

• Multiple Excel Versions: Covers 2013, 2016, and 2019 – perfect for upgrades!
• Lifetime Access: Learn at your own pace, anytime.
• Practice Exercises: Reinforce your learning with hands-on exercises.
• Certificates of Completion: Showcase your new skills.

Course Summary:

This Excel mega bundle is designed for all skill levels. Whether you're a beginner starting with Microsoft Excel or an experienced user looking to stay current, this course will help you succeed. If you're upgrading from an older version, this package provides a seamless transition.

Outcomes:

Upon completion, you'll:

• Develop a strong understanding of Excel formulas and functions.
• Confidently navigate, share, and use spreadsheets.
• Create impactful charts to communicate data effectively.
• Report data in various formats: tables, graphs, and PivotTables.
• Gain advanced Excel skills to enhance your professional capabilities.

What Our Students Are Saying:

*"As an engineering student, I could