Follow us

Base and Intermediate Excel

About this Course

In this Course we will learn the basics of Advanced Excel.

What will you learn

From this course students will have a clear understanding about the concepts of Base and Intermediate Excel

Requirements

No prior knowledge required

Section

11 Sections

Introduction, Importing Data, Data Entering and Data Cleansing

Importing text files to excel 5 mins
Introducing the User Interface of Excel 5 mins
Different menu options in Excel 5 mins
Different Formatting option in excel 5 mins
Editing Option 5 mins

Conditional Formatting and Custom Filtering in MS Excel

Conditional Formatting 5 mins
Conditional Formatting options 5 mins
Finding Unique Values 5 mins
Custom Filtering-user defined filtering 5 mins
Multi-level sorting; custom sorting-user defined sorting 5 mins
Data Validation-concepts 5 mins
Group-Ungroup-Subtotal on data 5 mins
Data Validation applying on lists 5 mins
Name Manager, Concept of List, creating list , accessing from another sheet 5 mins

Functions and Formulas

Formulas and Functions 5 mins
System defined function-SUM 5 mins
SUMIF 5 mins
SUMIFS 5 mins
COUNT 5 mins
COUNTIF 5 mins
COUNTIFS 5 mins
COUNTBLANK 5 mins
LEN 5 mins
LEFT 5 mins
RIGHT 5 mins
VLOOKUP, HLOOKUP, ADVANCED VLOOKUP 5 mins
IF CLAUSE, ADVANCED IF CLAUSE 5 mins
REPLACE,STD DEV, AVERAGE 5 mins
OFFSET, UPPER, LOWER 5 mins
IFERROR 5 mins
IFERROR 5 mins

Create and manage tables

Create and manage tables 5 mins
Create an Excel table from a cell range 5 mins
Convert a table to a cell range 5 mins
Add or remove table rows and columns 5 mins
Manage table styles and options 5 mins
Manage table styles and options 5 mins
Apply styles to tables 5 mins
Configure table style options 5 mins
Insert total rows 5 mins
Filter and sort a table 5 mins
Filter records 5 mins
Sort data by multiple columns 5 mins
Change sort order 5 mins
Remove duplicate records 5 mins

ClipArt and Shapes in MS Excel

Drawing in Excel 5 mins
Examples 5 mins
Using Shapes 5 mins
Working with SmartArt 5 mins
Working with Clip Art 5 mins
Embedding Objects in MS Excel 5 mins
Add pictures to your worksheets. 5 mins
Use Clip Art to illustrate your worksheets. 5 mins
Insert shapes into Microsoft Excel worksheets 5 mins

What if Analysis, Goal Seek, Scenario Manager

Concept of What if Analysis 5 mins
Concept of Goal Seek 5 mins
Concept of Data table 5 mins
Concept of Scenario Manager 5 mins
Areas where What if analysis is used 5 mins

Excel Concepts

Name concept 5 mins
Trace dependants 5 mins
Trace precedents 5 mins
Error Checking concept 5 mins
Remove Arrows 5 mins
Working with Clip Art 5 mins
Adding Shapes 5 mins

Pivot Tables

Concept of Pivot Table 5 mins
Why is it important, where it is used? 5 mins
Calculations in pivot table 5 mins
Subtotals in pivot table 8 mins
Dynamic pivot table 5 mins

Charting in Excel

Concept of chart-various charts in excel 5 mins
Different chart types-line chart 5 mins
Bar chart 5 mins
Grouped bar chart 5 mins
Stacked bar chart 5 mins
Pie chart and applications 5 mins
Line chart 5 mins
Bullet Chart 5 mins
Radar Chart 5 mins
Combination Chart 5 mins
Area Chart 5 mins
Heat Map 5 mins

Working with Dashboards

Concept of dashboard 5 mins
How to apply dashboard 5 mins
Combining multiple pivot charts to form a dashboard 5 mins
Concept of slicer 5 mins

Study Material

Section 1 10 mins
Section 2 10 mins
Section 3 10 mins
Section 4 10 mins
Section 5 10 mins
Section 6 10 mins
Section 7 10 mins
Section 8 10 mins
Section 9 10 mins
Section 10 10 mins

Reviews

View course preview

₹5000.0

This course is available in

What's included

Mobile support
Lesson archive
Course certificate