Microsoft Excel 365: Part 2 - Intermediate (eLearning) Course



Course Details:

Length: 5 courses

Access Length: 6 months

Price: $150/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

Unleash Excel's Power: Master Data Analysis with Intermediate Excel 365 (Part 2).

Level up your Excel skills and become a data pro! This intermediate eLearning course builds on your foundations to empower you with advanced techniques for organizing, analyzing, and visualizing data.

Here's what you'll conquer:

  • Data Wrangling: Link workbooks & worksheets, create named ranges, and master sorting & filtering for seamless data manipulation.
  • Table Talk: Organize your data like a boss with powerful tables, including subtotals and grouping for deeper insights.
  • Conditional Color & Sparkles: Apply conditional formatting to highlight key trends and add sparklines for instant data visualizations.
  • Charting Champions: Create stunning charts and graphs to bring your data to life, from basic visuals to advanced chart types.
  • PivotTable Powerhouse: Unlock the magic of PivotTables and PivotCharts to analyze your data from multiple angles. Explore advanced features like PowerPivot to take your analysis to the next level.
  • Slicer Savvy: Slice and dice your data with ease using slicers for interactive exploration and insightful discoveries.

Don't just crunch numbers, make them sing! This course will equip you with the skills to tackle any data challenge in Excel 365 and elevate your career to the next level.

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.


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

Prerequisites:

To ensure your success in this course, you should have end-user skills with any current version of Windows, including starting programs, switching between programs, locating saved files, closing programs, and using a browser to access websites. You can obtain this level of skills and knowledge by taking either the Windows 10 eLearning Bundle or the Windows 11 eLearning Bundle.

You should also be familiar with the topics covered in:


Follow-Ons:

 

Course Topics

Excel 365: Intermediate - 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.

 


 


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!