Excel for Intermediate Level

Overview

Excel for Intermediate Level course is a continuation of Excel for Beginners, which provides you with the skill sets to make the most effective use of Microsoft Excel. Microsoft Excel is an industry-leading spreadsheet software and a robust analysis and data visualization tool. This will enable you to create, calculate and analyze your spreadsheet to fulfill your needs confidently. With Excel's modern templates, jump-start your budget, task list, accounting, or financial analysis. You will learn to use formulas to do intricate calculations to analyze your data. You will also get an extensive understanding of data cleaning, data visualization, Aggregation, and charts. Great Learning offers multiple Post Graduate Programs in the field of Data Science. You can join our online data science course and Earn a Postgraduate Certificate in the top-rated Data Science and Business Analytics online course from Great Lakes in collaboration with the University of Texas. We have multiple PG Programs with various university partners such as Northwestern School of Professional Studies, SRM University, PES University. We aim to empower our learners with everything they need to succeed in their careers, resulting in 8000+ successful career transitions.

Syllabus

Substrings

This module introduces text manipulation functions, focusing on how to extract, search, and modify substrings within text data in Excel.

Conditional Formating

This module covers conditional formatting, showing you how to automatically apply formatting to cells based on specific criteria or rules.

Data Mapping, Data Visualization, Data Aggregation

This module focuses on advanced data handling, including mapping, visualization, and aggregation techniques to summarize and present data effectively.

Charts in Excel

This module explores the creation and customization of various chart types, enabling you to visualize data trends and insights for better communication.