On Demand

Basic Excel 2024 Training & Certification

Get Trained & Get Certified in Basic Excel

Students Enrolled

0 +

Ratings for this course

What you'll learn?

Description

This training provides all the tools necessary to create and use basic spreadsheets. Candidates will receive an overview of the interface and learn the various methods for entering and editing data. Additionally, candidates will learn the various ways to write simple formulas.

Ideal Candidates for This Course:

Curriculum

Total Hours

0 Hours

Basic Excel

Module1: Excel Overview

An overview of the screen, navigation and basic spreadsheet operations.
Understanding workbooks, worksheets, rows, columns, cells.
Various selection techniques.

Module 2 : Entering Data

Entering, Editing and Deleting Text, Numbers, Dates.
Moving and copying data.
Inserting, Deleting and Hiding Rows & Columns.
Inserting, Deleting, Moving and Copying Sheets.
Fill series.

Module 3 : Formatting and Proofing

Formatting Cells with Number formats, Font formats, Alignment, Borders and Patterns.
Basic conditional formatting.
Copying and Clearing Formats.
Working with Styles.
Spell Check, Find & Replace and AutoCorrect.

Module 4: Creating Charts

Creating Bar Chart, Column Chart, Pie Chart, Line chart.
Changing Chart elements, Style, Filter.
Formatting Chart area, Plot area, Gridlines etc.

Module 5: Basic List Management

Sorting.
Filters.
Subtotal.

Module 6: Creating and Editing Formulae

Concept of Formulae.
Creating Formulae, Editing Formulae, Copying Formulae.
Using Functions – Sum, Average, Max, Min, Count, Counta, Countif, Sumif, Now etc.
Applying Absolute (Fixed) Referencing.
Paste special.

Module 7: Printing and Page Setup

Page Orientation.
Adding Headers and Footers.
Printing a selection.
Shrink to Fit.
Repeating columns and rows.

Course Features

Courses

Recent Courses

Salary Scale

Maximum

10 LPA 70%

Average

4 LPA 50%

Minimum

2.5 LPA 30%

Job Role

It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will
It is a long established fact that a reader will

Training Option

Live-Online Instructor Led Training
100+ lab assignments & Quizzes
24/7 Lab access on Rooman Cloud Lab
Labs Designed & Mentorship support by Industry Experts
5 capstone projects
Live-Online sessions with Industry Experts & Subject Matter Expert from Rooman
Access to Recorded Session of Live-Online Classes available 24/7
Industry Recognized Course Completion Certificate
Interview Preparation & Placement Support

In-Person Classroom based Training conducted by Subject Matter Expert
Flexibility to attend classes at any of our 50+ Centers PAN India
Hands-on experience at our state-of-the-art Lab
100+ lab assignments & Quizzes
24/7 Lab access on Rooman Cloud Lab
Labs Designed & Mentorship support by Industry Experts
5 Capstone & 1 real-world project
Exclusive sessions with Industry & Subject Matter Expert
Access to Recorded Session of Live-Online Classes available 24/7
Industry Recognized Course Completion Certificate
Interview Preparation & Placement Support
Access to Campus Placement drives
1 year access to our LMS

Our Alumni

Exam Partner

FAQ

Item #1

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.