Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

# "Excel In a DAY - Basics - Advanced" is no longer available

2 Reviews

Course ID: 11518

2 Reviews

We will have a 1 day course on Excel, Basics to Advanced .
* 9 - 11:30 Basics of Excel
* 11:30 - 12:45 Lunch
* 12:45 - 3:00 Advanced Excel Concepts
* 3:00 - 3:30 Break
* 3:30 - 5:15 Advanced Excel Concepts

## Topics Covered

* Introduction
* Formatting In Excel
* Conditional Formatting
* Data Validation
* Referencing
* Cell Referencing In Excel
* Relative Referencing
* Absolute Referencing
* Difference Between Relative & Absolute Cell Referencing
* Functions In Excel
* SUM,COUNT,AVERAGE,SUMIF,COUNTIF ETC
* Sumproduct,subtotal,count,counta,
* IF,AND,OR ETC
* LOOKUP,VLOOKUP,HLOOKUP ETC
* LEN,UPPER,LOWER,PROPER ETC
* ISNUMBER, ISERROR, OR, AND, IF-THEN-ELSE
* Financial Functions
* Text Functions
* Date & Time Functions
* Working With Data Lists
* Sorting
* Validation
* Subtotals
* Filtering
* Pivot Tables
* Creating Pivot Table Using Wizard
* Modifying The Pivot Table
* Creating a Pivot Table Report
* Printing with Excel
* Working with print Options
* Setting Print Area/layout
* customization of toolbar
* Applying Protections
* Worksheet protection and locking of cells
* Workbook Protection
* Excel Keyboard shortcuts.
* Auditing Excel Sheet
* Working and editing with Hyperlinks
* Grouping the Columns and Rows
* * RECAP and PRACTISE SESSIONS

## Who should attend

Everybody and anybody who has a passion towards learning MS excel and taking a deep dive through advanced options .

## Pre-requisites

Interest towards learning Excel

## What you need to bring

Notepad if u are attending a class room training and Skype ID if u want to join ONLINE

## Key Takeaways

After the course, you can be assured that you will love to work on excel and how excel can make you excel at your workplace and other areas where you can showcase it.

## Date and Time

Not decided yet.

4.6 Avg Rating

5 Reviews

8 Students

5 Courses

rav

Msc in Information Systems

10 Years of Experience

I have been teaching excel for the past 8 years across various institutes and through online medium across the globe.well versed with Ms excel basics to advanced concepts.

5.0

Average Rating

100%
0%
0%
0%
0%

## Reviews

V

Viveka Vardhan

sajjan is good trainer in ms excel. reliable, patience teacher.

S

Sri Ramya

1. Good grip on the subject 2. Teaches with Practical examples 3. Good communication skills 4. Very good class in that locality.

## Discussions

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more