Excel Intermediate

# Master Excel's Hidden Powers

Unleash Efficiency, Save Time, and Amplify Productivity!

## What you Learn?

By the end of the course, you’ll have the hands-on skills to navigate, edit data, use basic formulas, format and create charts, which you could print and collaborate with others on.

## This course covers

Excel Essential

Introduction to Excel Interface
Understanding the structure of excel workbook
Formatting Options
Saving Excel Document
Common Excel Shortcut
Copy, Paste

FORMATTING DATA IN EXCEL

Changing the colour
Formatting Data
Excel's Format
Conditional Formatting
Add Delete Cells Rows And Columns
Sort And Filters
Error type

ENTERING AND EDITING FORMULAS

Relative Reference In Excel
Calculation Method
Count Function
Statistical Formula
Large, Small & Rank
Rounding Values
Statistical Formula
Large, small, and Rank
Error Type

SUM IF & IFs
Logical Formula - IF & IFs
Average IF
Logical Formula - AND & OR Using Nested IF
VLOOKUP Using Exact Match Within The Sheets
HLOOKUP Using Exact Match Within The Sheets
Using VLOOKUP & HLOOKUP Between Sheets
Index Within The Sheet
Using INDEX Between The Sheet
Match Within The Sheet
Using MATCH Between The Sheet
Index And Match Within The Sheet
Index And Match Between The Sheet

Financial Functions in Excel

Simple Interest and Compound Interest
Future and Present Value in Excel
Net Present Value
Internal Rate of Return
Return on Investment
Calculating a Complete Loan Schedule in Excel
Complete Calculation of Financial Function

Text, Time And Date Format

Difference Between Text, Time and Date
Changing The Case of Text
Combining Text
Cutting Substring From Text
Combining Date And Time Data
Conducting Day of The Week

Creating Basic Chart In Excel

Creating Excel Column Chart
Modifying Data In Excel Chart
Formatting Excel Chart
Insert Sparkline
Frequency Distribution and Histograms
Waterfall Chart
Area Chart
Pie Chart

Modifying And Printing Excel Worksheet

Moving And Copying Data In Excel Worksheet
Deleting And Renaming Excel Worksheet
Document Output Management

HR Analytics

Match Employee ID With Location
Financial Report

01

### Organize and Analyze data

you can ensure that your data is properly collected, cleaned, and analyzed to generate insights

02

### Perform Complex Calculation

The ability to perform complex calculations is essential in many fields, including science, engineering, finance, and data analysis.

03

### Create charts and graphs

Creating charts and graphs is an effective way to visually represent data and communicate insights to others.

04

### Automate Calculations

Automating calculations can save time and increase accuracy by reducing the risk of human error.

Why Choose Us?

# Certificate of Training

Rewarded upon successful completion of your  course.
Pricing System

## Enhance your skills to a higher level starting today.

Free plan

### \$0 For   7 days

and new courses
Short, bite-sized lessons to learn faster
Limited for 7 days
Without tutoring

### \$100 / Month

Pricing feature here
Pricing feature here
Pricing feature here
Pricing feature here
with tutoring
Popular

### \$125 / Month

Pricing feature here
Pricing feature here
Pricing feature here
Pricing feature here
Free plan

### \$0 For   7 days

and new courses
Short, bite-sized lessons to learn faster
Limited for 7 days
Without tutoring

### \$200 / Month

Pricing feature here
Pricing feature here
Pricing feature here
Pricing feature here
with tutoring
Popular

### \$250 / Month

Pricing feature here
Pricing feature here
Pricing feature here
Pricing feature here
Free plan

### \$0 For   7 days

and new courses
Short, bite-sized lessons to learn faster
Limited for 7 days
Without tutoring

### \$360 / Month

Pricing feature here
Pricing feature here
Pricing feature here
Pricing feature here
with tutoring
Popular

### \$450 / Month

Pricing feature here
Pricing feature here
Pricing feature here
Pricing feature here

Who is this course for?

Anyone can learn Excel! course takes someone from beginner to advanced using guided simulation learning.

What is guided simulation learning?

Unlike video which is a passive way to learn we use a hands-on approach to building muscle memory. This hands-on approach results in a significant increase in memory retention.

I am new to Excel. Would this course be suitable for someone at my level?

This Excel course covers a range of topics, starting from the basics and progressing towards essential concepts and skills. Once you have learned Excel efficiency, you can expect to experience increased productivity, accuracy, data analysis, reporting, efficiency, organization, and career opportunities.

Once you have a solid understanding of the basics, you will be better equipped to handle more advanced Excel courses and concepts with greater ease.

What is the duration of the Excel course?

Our LMS course consists of 80 hours of comprehensive training that is designed to enhance your Microsoft Excel skills, enabling you to work with greater efficiency and speed.

Do we need to have Microsoft Excel installed on our computer to take the Excel course?

A simulated learning environment is a type of educational setting that replicates a real-life scenario or situation in a controlled and safe environment. Our Excel course is designed to be accessible through a web browser, so you don't need to have Microsoft Excel installed on your system to take the course.

Are there any other resources or materials available to help learners improve their Excel skill?