Signup as a Tutor

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

Excel in Excel

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype

Course ID: 12492

Course type: Online Instructor led Course

Platform: Skype

Students Interested 0 (Seats Left 0)

₹ 2,000

No Reviews Yet

Date and Time

Not decided yet.

A Gayatri

B level,M.Sc

About A Gayatri

13 years of IT-Corporate training experience,Expert in Excel, VBA,
Have dealt with most of the corporates in Hyd like Thomsn Reuters, UBS,Genpac,ISB,Satyam Mahindra etc.
No reviews currently

About the Course

Do you want to Excel in Excel, Do join the course

Topics Covered

Topic No Topic Name
1 Formatting
Formatting In Excel
Adv Formatting
Conditional Formatting
2 Validations
Cell level validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on formula for a cell
4 Various Functions of Excel
Working with functions
Financial functions
Date and time functions
Statistical functions
Lookup and reference functions
Text manipulation functions
Logical functions
Worksheet and cell information functions
5 Filters
Data Filters
Auto Filters and Advanced filters
6 Customizing Setting and View (¾ Hour)
Customizing views
Customizing calculations and iterations
Creating custom lists
7 Pivot Tables
Creating Pivot Table Using Wizard
Modifying The Pivot Table
Creating a Pivot Table Report
8 Excel Charts
9 Protection
Applying Protections
Worksheet protection and locking of cells
Workbook Protection
Excel Keyboard shortcuts.
Working and editing with Hyperlinks
10 Workbook sharing
Tracking changes
Merging workbooks
Workbook and sheet protection
14 Introduction to Macros only User Interface

Who should attend

Minimum knowledge on Ms Excel can attend this session

Pre-requisites

Very Basic knowledge of Excel

What you need to bring

Skype Connectivity, For practicing Ms Office installed

Key Takeaways

Knowledge on Excel Functions, Pivot, Charts etc

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

₹ 2,000

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 2,000 Enquire