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.

Enquire

Submit your enquiry for Advance Excel Training - 2-Day workshop in Bangalore

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Vijatiya Training Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

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

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 3 of 3
U

14/03/2014

very much interested in advance excel and macros

0 0

Answer

You can add upto 6 Images

U

26/08/2013

Looking for a session next month

0 0

Answer

You can add upto 6 Images

U

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

Date and Time

Not decided yet.

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.
Seats Left-

Students Interested 1

Course Id: 8030