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

No Reviews Yet

Nallakunta, Hyderabad

Course ID: 11518

Nallakunta, Hyderabad

No Reviews Yet

About the Course

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
* Adv Formating
* Conditional Formatting
* Data Validation
* Linking across Sheets
* Linking across Workbooks
* Referencing
* Cell Referencing In Excel
* Relative Referencing
* Absolute Referencing
* Difference Between Relative & Absolute Cell Referencing
* Functions In Excel
* Sumproduct,subtotal,count,counta,
* 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

Who should attend

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


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.

About the Trainer

rav picture

4.6 Avg Rating

5 Reviews

6 Students

6 Courses


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.


No reviews currently Be the First to Review


Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, 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 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