Advanced Excel

Course Content

Module 1 – Excel Fundamentals
Getting to know the application and its interface. Here, we try to understand the features of excel, available options in each of the menu tabs. Entering data and how excel understands the user inputs along with basic data formatting and shortcuts.

Introduction to the Excel Course

08:19
Excel Fundamentals

50:43

Module 2 – Modifying Excel Worksheet
Work with worksheets, introducing the sheet additions, deleting and how to edit multiple sheets in one go! Work with cells and its formatting. Different ways to use the cells when text is involved vs Numeric. Get know the most amazing feature! Conditional Formatting. Highlight and draw attention to the Cells, Rows and Columns based on conditions.

Module 3 – Filters and Sorting
Quick analysis! Knowing how to apply filters, multiple columns and sorting

Module 4 – Excel Functions
Understand the most important feature, Cell Referencing. This enables us to navigate formulas with ease. Work with the basic formulas under the categories: Numeric, Text, Logical, Date and Lookups. Understand how to write Formulas in different sheets and sheet references.

Module 5 – Dashboard Creation
Lets apply what we have learnt so far and also learn further data manipulation to seek insights. Understand the data, frequent challenges and how to shape the data to generate charts and Pivot Tables. Build the Dashboard Views and work with Slicers.

About Course

Why should you learn this course?

Excel is the essential skill for all the finance, HR, Management students.
Excel is necessary step to understand data and first steppingstone to become a business analyst and data scientist.
This course will give you practical experience on different datasets including Finance and HR data.
Learn any time and anywhere.
Learn using industry relevant examples.

Each module has practice along files and assignments which will help sharpen your skills. The examples and scenarios used in the course are in line with the live-work scenarios.

At the end of the course, you will be comfortable working with process of turning raw data into amazing dashboards !

0 /5

nerdindians123

20 Courses

Find your desired course

Select Your Favourite Category And Start Learning.

ULP Pharmacy

ULP BioSciences

Marketing and Management

Engineering

Advanced Excel

Intermediate

40h

12

Course Content

Module 1 – Excel Fundamentals Getting to know the application and its interface. Here, we try to understand the features of excel, available options in each of the menu tabs. Entering data and how excel understands the user inputs along with basic data formatting and shortcuts.

Introduction to the Excel Course

Excel Fundamentals

Modifying Excel Sheets

Module 3 – Filters and Sorting Quick analysis! Knowing how to apply filters, multiple columns and sorting

Filtering and Sorting

Formula – Logical functions

Formulas – Date functions

Formulas – Lookup functions

Formulas – Numeric Extended

Formulas intro + Text Functions

Module 5 – Dashboard Creation Lets apply what we have learnt so far and also learn further data manipulation to seek insights. Understand the data, frequent challenges and how to shape the data to generate charts and Pivot Tables. Build the Dashboard Views and work with Slicers.

Dashboard Creation A

Dashboard Creation B

Dashboard Creation C

About Course

Advanced Excel

What Will You Learn?

Material Includes

Requirements

Audience

Instructor

Material Includes

More Courses to get You Started

support@nerdindians.com

+91-8374141845

Student Zone

WORKING HOURS

Select Your Favourite
Category And Start Learning.

Module 1 – Excel Fundamentals
Getting to know the application and its interface. Here, we try to understand the features of excel, available options in each of the menu tabs. Entering data and how excel understands the user inputs along with basic data formatting and shortcuts.

Module 3 – Filters and Sorting
Quick analysis! Knowing how to apply filters, multiple columns and sorting

Module 5 – Dashboard Creation
Lets apply what we have learnt so far and also learn further data manipulation to seek insights. Understand the data, frequent challenges and how to shape the data to generate charts and Pivot Tables. Build the Dashboard Views and work with Slicers.