Excel And Advanced Excel Courses - CiteHR
Hrtraining360
Professional Training Institute
Samtaurus
Digital Marketer
+1 Other

Prime Sponsor - FactoHR.com - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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
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
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

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
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:
mail@corporatebridge.net
For Registrations Contact:
92222 87738, 92222 87739, 92232 33568,
92232 33569, 3222 5058



Corporate Bridge Academy Linkedin

http://www.linkedin.com/e/vgh/3104270/


Corporate Bridge Website

www.corporatebridge.net
BSE Link
BSEIndia
Follow Us on Twitter
www.twitter.com/corporatebridge
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
BSE
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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: http://www.onlinecourses.trainedge.co.in/ms-excel-training-with-microsoft-certificate/
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.
Prime Sponsor - Talentedge.com "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
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 @ 2019 Cite.Co