Microsoft Excel 365 eLearning Bundle Course



Course Details:

Length: 7 courses

Access Length: 6 months

Price: $300/person (USD)

Bundle & Save: View Bundle

Bulk Pricing: 10+ Contact Us

Course Features:

Instant Access After Purchase

Lecture by Recorded Video

Stop and Start as Needed

Certificate of Completion

Software Lab Included?: Yes

Delivery Method:

Self-Paced Online

Individuals and Groups
@ Your Location

 


Course Overview

Bundle and Save $150! This eLearning Bundle includes the following Microsoft Excel 365 courses:

  • Excel 365: Beginner
  • Excel 365: Intermediate
  • Excel 365: Advanced

Unlock your full Excel potential with this comprehensive bundle, mastering everything from essential skills to advanced formulas and data analysis.

Level Up Your Skills:

  • Beginner: Build a solid foundation with spreadsheet creation, data entry, formatting, and basic formulas.
  • Intermediate: Take control of your data with sorting, filtering, tables, conditional formatting, charts, and PivotTables.
  • Advanced: Conquer complex analyses with powerful formulas, error checking, what-if tools, data protection, automation, and collaboration features.

What You'll Learn:

  • Excel fundamentals: Navigate the interface, enter data, format cells, and create formulas.
  • Data organization and analysis: Sort, filter, and group data, utilize tables, conditional formatting, and charts.
  • Advanced data manipulation: Master powerful formulas like SUMIF, VLOOKUP, and PivotTables.
  • Error checking and automation: Ensure accuracy with formula auditing, what-if tools, and macros.
  • Data protection and collaboration: Secure your information and work seamlessly with others.
  • Import and export data: Connect with external sources and share your work effectively.

Benefits:

  • Increase productivity: Automate repetitive tasks and make smarter decisions with data-driven insights.
  • Boost your resume: Stand out in the job market with valuable Excel skills.
  • Enhance your career: Take on new challenges and excel in data-driven roles.

Don't wait to level up your Excel skills! This comprehensive bundle offers everything you need to become a confident and powerful Excel user.

Invest in your success with this all-in-one Excel mastery bundle!

Also Included - 4 Courses: An Essential Career Skills Pack with 4 courses in key areas for career management and growth, including Time Management, Digital Skills, Creativity and Soft Skills.

 


Course Notes

Important Course Information
Course Taught with: Microsoft Office 365 for Windows ().
Versions that Can Attend: Desktop Version of Office 365, 2021, 2019, 2016 Windows PC () or Macintosh (Mac) - iOS ().

Learn at Your Own Pace

This self-paced online course lets you learn independently at your own pace through Certstaffix Training's easy-to-use platform.

How It Works

  • A Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screenshots
  • 6-month subscription length
  • Instant Access After Purchase

Have more than 10 students needing this course? Contact Us for bulk pricing.

 


Course Topics

Excel 365: Beginner

Course Duration - 4 hrs 46 min

Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. This course gives an introduction to Excel via the Office 365 Suite. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.



 

Excel 365: Intermediate

Course Duration - 4 hrs 31 min

In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.



 

Excel 365: Advanced

Course Duration - 4 hrs 20 min

This course will teach students advanced concepts and formulas in Microsoft Excel 365. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

 


 


Essential Career Skills Pack


Productivity and Time Management

Course Duration - 30 min

It seems that there is never enough time in the day. But, since we all get the same 24 hours, why is it that some people achieve so much more with their time than others? This course will explain how to plan and prioritize tasks, so that we can make the most of the limited time we have. By using the time-management techniques in this course, you can improve your ability to function more effectively – even when time is tight and pressures are high. So, by the end of the course you will have the knowledge, skills and confidence to be an effective manager of your time.



 

Basic Digital Skills

Course Duration - 13 min

With the rise of digital transformation and technology, having a basic digital literacy is essential for all types of jobs, regardless of the industry. To stay competitive and be successful in the workplace, enhancing your digital skills should be a top priority.



 

4 Ways to Boost Creativity

Course Duration - 30 min

The digital economy is opening up ways for everyone to be creative. It doesn’t just mean being artistic – it’s more about ideas, solutions, alternatives, incremental improvements. Peter Quarry and Eve Ash discuss ways that mental capacity can be developed, perspectives changed, group power leveraged and making things actually happen.



 

The 11 Essential Career Soft Skills

Course Duration - 1 hr 10 min

Soft Skills are the traits, characteristics, habits, and skills needed to survive and thrive in the modern work world. Soft skills aren't usually taught in school, but you will learn them all here in this course. Are you someone that other people in your organization and industry like to work with, collaborate with and partner with? Are you seen as a valuable asset to any new project that comes along?

This soft skills training course will teach you how to develop the skills that can make the difference between a lackluster career that tops out at middle management versus one that lands you in the executive suite. Or to wherever you define career success. So many soft skills seem like common sense at first glance, but they are not commonly applied by most workers. This soft skills training course will give you an edge over your competitors. It will also make your job, your career and your life more rewarding and enjoyable.

 



 


Related Microsoft Excel Information:

Individual live Certstaffix Excel training prices start at $295 per student. Group Excel training cost discounts are available.

Excel eLearning courses cost $150 at the starting point per student. Group purchase discounts are available.







Registration:

Have a Group?
Request Private Training


Online Class

Self-Paced eLearning

Start your training today!