Learn Excel 365: 7-Course Bundle

Boost productivity and accuracy with Excel 365 skills for data management, analysis, and visualization.

What you'll learn
- Access and utilize the Backstage view to create, open, save, and share Excel files.
- Implement the split-screen feature to view different spreadsheet sections simultaneously.
- Cleanup datasets using the 'Remove Duplicates' tool.
- Manage data visibility with outlining techniques.
- Utilize absolute references to prevent value changes in formulas.
- Calculate averages and sums using the AVERAGE and SUM functions.
- Translate text between languages using Excel's translator.
- Use SUBSTITUTE to replace specific text strings in cells.
- Project future savings using the FV function in Excel.
- Build and interpret linear regression models using LINEST.
- Modify chart elements (titles, labels, colors, legends).
- Distinguish between area charts and other chart types.
- Establish and maintain dynamic data links between workbooks.
- Import data from Access databases and manage connection properties.

Requirements
- A computer with Microsoft Excel 365 installed and an active subscription.
- Basic computer literacy.
- Reliable internet access if you plan to use cloud-based features like OneDrive or online data connections.

Description
This course bundle includes downloadable course instructor files and exercise files to work with and follow along.

Learn Excel 365: 7-Course Bundle equips you with the essential skills to work efficiently, organize information, and confidently present data. From navigation basics to advanced data management, you will gain practical techniques that help you save time, reduce errors, and create professional results.

Across seven structured learning experiences, you will first strengthen your foundation by exploring Excel’s interface, navigation tools, and file management options, including saving, printing, and sharing through OneDrive. You will then build confidence in applying formulas and functions to streamline calculations, while learning to manage ranges, clean up messy data, and consolidate information for accuracy.

As you progress, you will gain the ability to clean and format text data for consistency, automate repetitive tasks, and apply shortcuts that improve productivity. Advanced lessons expand your skills in financial and statistical analysis, where you practice forecasting, loan calculations, and data modeling. You will also discover how to create impactful charts and graphs that transform raw numbers into clear, persuasive visuals.

Finally, you will explore workbook tools and external data connections, enabling you to link multiple sources, update information in real time, and customize Excel to fit your workflow.

By the end, you will have a complete set of skills to handle complex spreadsheets, manage large datasets, and communicate insights effectively. Whether you use Excel for personal projects or professional responsibilities, this bundle gives you the confidence and efficiency needed to excel in today’s data-driven world.

In this course, you'll learn how to:

Access and utilize the Backstage view to create, open, save, and share Excel files.

Implement the split-screen feature to view different spreadsheet sections simultaneously.

Cleanup datasets using the 'Remove Duplicates' tool.

Manage data visibility with outlining techniques.

Utilize absolute references to prevent value changes in formulas.

Calculate averages and sums using the AVERAGE and SUM functions.

Translate text between languages using Excel's translator.

Use SUBSTITUTE to replace specific text strings in cells.

Project future savings using the FV function in Excel.

Build and interpret linear regression models using LINEST.

Modify chart elements (titles, labels, colors, legends).

Distinguish between area charts and other chart types.

Establish and maintain dynamic data links between workbooks.

Import data from Access databases and manage connection properties.

This course bundle includes:

4 hours and 53 minutesof video tutorials.

77 individual videolectures.

Course and exercise filesto follow along with.

Certificate of completion.

Who this course is for:
- Beginners who want to build a strong foundation in Excel 365.
- Students who need reliable skills to organize, analyze, and present data.
- Professionals who use spreadsheets for budgeting, reporting, or project management.
- Job seekers aiming to strengthen their resumes with practical Excel skills that are highly valued in today’s workplace.
- Anyone who wants to feel confident working with data, from creating simple tables to managing large, complex spreadsheets.
More Info