Advertisements


    Add to My Briefcase
 
   
Event Name: Excel and Advanced Excel Courses
   
Event Description: 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://www.corporatebridge.net/courses_offered/EXCEL.pdf

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
Changing Chart Options
Formatting Chart
Useful graphs and charts
Two-axis graphs
Multiple kind of charts

Setting up Page and Print

Setting Up Page
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
Customizing Data
Advance Formatting
Conditional Formatting
Format Consistency
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
Add a record
Modify a record
Delete a record

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

Session 8: What-if Analysis

Goal-seek command
Using Data Tables
One input data table
Two input data table
Create a scenario
Merger scenario from another worksheet
Protecting Scenarios

Email:
mail@corporatebridge.net

Corporate Bridge Academy Linkedin
http://www.linkedin.com/e/vgh/3104270/

Corporate Bridge Website
www.corporatebridge.net

BSE Link
http://www.bseindia.com/training/schedule.asp

Follow Us on Twitter
www.twitter.com/corporatebridge

Follow Us on Facebook
http://www.facebook.com/CorporateBridge

Courses and Centres
http://corporatebridge.net/cfa_mumbai.php

CB’s placements till date
http://corporatebridge.net/placement_frame.html

FREE job posting for Employers / Consultants
http://cbjobs.in/
   
Event Date/Time: Wednesday 7 July 2010 from 3:59 PM to 4:59 PM
   
Venue: Mumbai
   
Zip Code: 400072
   
Website: http://www.corporatebridge.net
   
Location: , India
   
Industry: Education Management
   
Event Type: Workshops
 
   
Orgnaization: Corporate Bridge Academy
 
 
 
STATS
 
Total events: 0
    Total Categories: 7
    Uploaded in Last Week: 0
LOGIN
 
   Login Id
   Password
  Forgot Password?
    
   
My RSVP
 
Posted By
 
Corporate Bridge
Company
Corporate Bridge
INVITE FRIENDS
 
  Invite your Friends and Others for an Event
 
SEARCH EVENT
 
  Enter Keywords
 
     
BROWSE
 
Academic Events
Seminars
Workshops
Concerts
Cultural events
 
spacer gif
Management Paradise
spacer gif
arrow gif About Us
Press
Jobs
MBA Projects
Kartik Raichura
spacer gif
spacer gif
spacer gif
Legal
spacer gif
spacer gif Terms & Conditions
spacer gif Privacy Policy
spacer gif Disclaimer
spacer gif Copyrights
spacer gif Contact Us
spacer gif
spacer gif
spacer gif
Help
spacer gif
spacer gif Zeitgeist
Support
FAQs
Tour
Feedback
Our Network

MBA B School Blog

MBA Buy Entrance Exam Forms

MBA BMS Blog

MBA MBA Blog

MBA BMM Network

Follow
       
   

 

Copyright 2004 - 2021 Management Paradise.