loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Share

course photo

Advance Excel Training - 2-Day workshop in Bangalore

Richmond Road, Bangalore

5,000

No Reviews Yet
1 Interested

About the Course


Advance Excel Training in Bangalore, Vatika Business Center, Richmond Road, Bangalore

Topics Covered

#1: Using Formatting and Functions

• Applying Formatting to Numbers
• Creating Custom Number Formats
• Applying Conditional Formats
• Using Formulas in Conditional Formats
• Absolute and Relative References
• Naming a Range
• Using a Named Range in a Formula
• Using Lookup Functions
• IF Functions

#2: Using Templates and Workbooks

• Applying a Template
• Using a Template
• Creating a New Template
• Editing a Template
• Linking Between Workbooks
• Importing Data from Text Files
• Importing Data from Other Applications

#3: Working with Data

• What is a List?
• Validating Data Entries
• Sorting Data
• Subtotaling and Outlining Data
• Extracting Data with Filters
• Using Advanced Filters
• Extracting data from Web
• Consolidating Data

#4: Analyzing Data

• Using PivotTable Add info about Slicers
• Managing PivotTable Reports
• Creating PivotChart Reports
• Using Pivot Charts

#5: What-if Analysis

• Working with Data Table
• Working with Goal Seek
• Working with Scenarios
• Working with Solver

#6: Auditing Tools

• Auditing Workbooks
• Tracing Errors
• Circle error Data
• Working with broken links
• Highlight errors to identify and correct
• Validate Cells to avoid errors

#7: Sharing & Protecting Workbooks

• Creating a Shared Workbooks
• Protecting Columns
• Protecting Worksheets
• Protecting Worksheet Content
• Protecting Cells
• Assigning a Password
• Tracking Changes
• Adding Comments
• Preparing a Workbook

#8: Adding Charts

• Enhancing a Chart
• Working with multiple Chart Types
• Working with Sparklines
• Adding Secondary Axis
• Plotting Ranges
• Adding Trend lines/Target lines/Series lines/drop lines/high-low lines etc.
• Working with Error Bars

#9: Introduction to Macros

• What is a Macro?
• Recording a Macro
• Running a Macro
• Editing a Macro

#10: Excel Settings

• Working with Compatibility Checker
• Customizing Ribbon Settings
• Inspecting Workbook
• Marking the Workbook Final
• Other Default Settings

Who should attend

Excel users who would like to enhace their capability of Excel usage, Professionals who aim to get an edge over others, Users who look to exploit Excel to their advantage

Pre-requisites

Basic understanding of Excel

What you need to bring

Laptop with Office 2010/2007 loaded

Key Takeaways

• Learn How to Use Formatting and Functions
• Use Templates and Workbooks
• Edit, Validate, and Extract Data
• Use Pivot Tables, Charts, and Trend Lines
• Work with Macros and Auditing Tools
• Create and Prepare Shared Workbooks
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Showing 1 to 3 of 3
U

mohanraj 14/03/2014

very much interested in advance excel and macros

0 0

Answer

You can add upto 6 Images

U

Kunal Verma 26/08/2013

Looking for a session next month

0 0

Answer

You can add upto 6 Images

U

s.v.sudhakar rao 16/08/2013

very much interested in advance excel

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

About the Trainer

T K Vijayalakshmi

Master of Computer Applications from The Chennai University & Post Graduate in Financial Management from IMT Ghaziabad


I have good experience in relative manner.

Course Id: 8030