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

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

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