Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Advance Excel Training - 2-Day workshop in Bangalore

No Reviews Yet

Richmond Road, Bangalore

Course ID: 8030

Richmond Road, Bangalore

₹ 5,000

No Reviews Yet

Date and Time

Not decided yet.

T K Vijayalakshmi

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

About T K Vijayalakshmi

I have good experience in relative manner.
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

₹ 5,000

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
₹ 5,000 Enquire