#query{background:#ebf5fd;color:#4f4f4f;letter-spacing:1px;padding:5px;border:1px #001b31 solid;text-indent:3%;font-size:small} form#search_query{color:#fdfcfb;text-align:left;margin:0}
Hrtraining360
Job Oriented Training Institute
Samtaurus
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.

http://educba.com <link updated to site home>
Session 1: Basic Excel
Excel overview
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
Aggregation: COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF, SUMPRODUCT
Strings: LEFT, RIGHT, MID, FIND, PROPER, CONCATENATE

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

o Customizing Data
o Conditional Formatting
o Format Consistency
o Data Outlining

Session 5: Advanced Formulae
Auditing form
Auditing Worksheets And Tracing Cell References
Tracing Errors
CHOOSE, COLUMNS, MATCH, ROWS, VLOOKUP, HLOOKUP

Session 6: Multiple Sheets & Auditing features
Multiple Sheets
Linking worksheets using 3-D formulas, Consolidating data, Creating hyperlink, Creating links between different worksheets
Auditing
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

Macros
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:
[email protected]
For Registrations Contact:
92222 87738, 92222 87739, 92232 33568,
92232 33569, 3222 5058

Corporate Bridge Website

www.corporatebridge.net
BSEIndia
Dheeraj Vaidya | Facebook
Courses and Centres
Corporate Bridge :: About Us :: Contact Us <link updated to site home> ( Search On Cite | Search On Google )
CB’s placements till date
BSE

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.

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.