Job Oriented Training Institute
Digital Marketer
+1 Other

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
The main goal of the course is to enable professionals to enhance their MS excel skills through exercise and gaining hands-on experience on various techniques. The course covers step-by-step lessons ranging from basic fundamentals to more advanced features and program applications. It is a highly practical course that will lead to learning powerful features and options of excel to manage their worksheet-related tasks more efficiently. The course will help delegates gain Excel Proficiency calculations, functions, formulas, and Excel Best Practices. Also, the focus will be given on formatting. <link updated to site home>
Session 1: Basic Excel
Excel overview
Excel navigation & Menu commands
Entering, moving, & manipulating data
Managing worksheet & workbook information
Formatting worksheets
Adjusting Column Width / Row Height
Formatting Cell Using Toolbar
Formatting Cell Using Menu Options
Session 2: Charts & Layouts
Creating Chart using Chart Wizard
o Changing Chart Options
o Formatting Chart

Useful graphs and charts
o Two-axis graphs
o Multiple kind of charts

Setting up Page and Print

o Setting Up Page
o Previewing and Printing

Session 3: Basic Excel Functions
Logical functions : AND, IF, OR
Arithmetic functions : ABS, INT, LARGE, MAX, MIN, SMALL, TRUNC
Date functions : DATE, WEEKDAY

Session 4: Using Excel Tools
Data filter
Pivot Tables: Creating Pivot Table, Updating Pivot Table, Modifying Calculated Field in Pivot Table

Advanced formatting
o Customizing Data
o Advance Formatting
o Conditional Formatting
o Format Consistency
o Data Outlining

Session 5: Advanced Formulae
Auditing form
Auditing Worksheets And Tracing Cell References
Tracing Errors
Advanced referencing functions

Session 6: Multiple Sheets & Auditing features
Multiple Sheets
Linking worksheets using 3-D formulas, Consolidating data, Creating hyperlink, Creating links between different worksheets
Tracing errors in worksheet, Workgroup collaboration, Tracking

Session 7: Data form & Macros
Data Form
o Add a record
o Modify a record
o Delete a record

o Recording a macro
o Running a macro using menu command
o Assign a macro to a button

Session 8: What-if Analysis
Goal-seek command
Using Data Tables
o One input data table
o Two input data table
Create a scenario
Merger scenario from another worksheet
Protecting Scenarios

[email protected]
For Registrations Contact:
92222 87738, 92222 87739, 92232 33568,
92232 33569, 3222 5058

Corporate Bridge Academy Linkedin

Corporate Bridge Website
BSE Link
Follow Us on Twitter
Follow Us on Facebook
Dheeraj Vaidya | Facebook
Courses and Centres
Corporate Bridge :: About Us :: Contact Us <link updated to site home> ( Search On Cite | Search On Google )
CBs placements till date

From India, Pune
Here’s another excel course with Microsoft Certification, online Microsoft Excel Training is interactive and designed to help you learn key skills comes with 30 videos, 26 practice & guided exercises and 12 self- assessment exercises.
For more info visit:

From India, Bangalore
Do you wish to learn Advanced Excel the easy way? Are you seeking an opportunity to learn MS Excel along with your job? Is no knowledge of Advanced MS Excel halting your career growth? If you answered yes to any or all of these questions then you should seek help at SLA Consultants. We provide world class Advanced Excel Training in a short amount of time. The key features of our training program include:

Familiarity with functions like Basics, Mathematical and Statistical

In-depth knowledge of Pivot Tables

Imparting understanding of Filters

Instructions on creating reports with efficiency

Exposure to a Live Project

When you decide to pursue an Advanced Excel Course, there is nothing that would not be included by us. We give you theoretical notes as well as practical exposure in equal measures. It would help you to learn every aspect of MS Excel by just spending a few weekends in our classes. For us all our students are the same so whether you are a student or a working professional, we would treat you with equal respect.

If you think that any of your queries has been left unanswered or you would simply like to know more about this course then feel free to contact us on 011-65953890 or +919999491895. You can also get in touch with us today by sending a mail to us at . We would be delighted to hear from you.

From India, Mumbai
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co