Excel Training for Intermediate and Advanced Users

Introduction

Microsoft Excel provides you with the relevant tools to transform data into formatted and meaningful information. It also allows you to generate great business reports, graphs and charts for business analysis and presentation. It is an essential tool for today’s business. If you already have the basics of Microsoft Excel, this Excel training course will help bring you to the next level for greater efficiency and productivity.

Course Objectives

Upon completion of this Excel training program, participants should be able to:

• Outline and Group Data
• Work with PivotTables
• Hyperlink Excel and The Internet
• Creating and Using Shared Workbooks
• Work with Visual Basic and Macros
• Perform Advanced File Management
• Customize Excel and Use Excel with Other Programs

Course Outline

UNIT 1: OUTLINING AND GROUPING YOUR DATA

• Using Automatic Outlining
• Displaying and Collapsing Levels
• Grouping Data Manually
• Creating Subtotals

UNIT 2: PIVOT TABLES

• What Is a Pivot Table?
• Creating A Pivot Table Frame
• Specifying Data in A Pivot Table
• Rearranging Pivot Table Data

UNIT 3: MORE ON PIVOT TABLES

• Modifying Pivot Table Calculations
• Formatting A Pivot Table
• Refreshing A Pivot Table
• Charting A Pivot Table
• Creating A Pivot Table Based On Data From
• An External Database

UNIT 4: WHAT IF ANALYSIS

• Using A One And Two Input Data Table
• Using Goal Seek
• Using Solver

UNIT 5: HYPERLINK EXCEL AND THE INTERNET

• Hyperlinks and The Internet
• Inserting Hyperlinks
• Modifying Hyperlinks
• Using The Web Toolbar
• Browsing Hyperlinks in Excel

UNIT 6: CREATING AND USING SHARED WORKBOOKS

• Sharing A Workbook
• Requesting Reviews
• Reviewing A Workbook
• Tracking Changes
• Merging and Revising a Shared Workbook

UNIT 7: VISUAL BASIC AND MACROS

• Adding Code to Your Macro
• Adding Comments to VBA Code
• Declaring Variables
• Prompting for User Input
• Iteration Over a Range
• Using If Then Else Statements

UNIT 8: ADVANCED FILE MANAGEMENT

• Identifying File Properties
• Searching For Files
• Protecting Personal Information
• Creating Back Up Files
• Changing Auto-Recovery Settings

UNIT 9: CUSTOM AND ADVANCED FEATURES IN EXCEL

• Customizing Excel By Changing Options
• Using Custom Auto-Fill Lists
• What Is Text To Speech?
• Using Detect And Repair

UNIT 10: USING EXCEL WITH OTHER PROGRAMS

• Using Excel In Word
• Inserting Excel Data In Word
• Modifying Excel Data After Insertion

Why Excel Training is Crucial for Intermediate and Advanced Users

Excel training boosts productivity. It shows users how to automate tasks, create detailed reports, and handle large sets of data. Advanced tools, like PivotTables and Visual Basic, sharpen data analysis and decision-making skills. This training speeds up work and reduces mistakes. Many industries look for skilled Excel users, making Excel training a great way to advance your career.

Key Excel Training Techniques for Mastering Advanced Functions

• PivotTables: Arrange and examine complex data quickly. They help users spot trends and build reports with ease. PivotTables simplify the way you handle large data and present it clearly.
• Macros: Automate tasks that you repeat often to save time. By recording or writing macros, you can finish difficult jobs with one simple command. This not only speeds up work but also cuts down errors.
• Advanced Formulas (VLOOKUP, INDEX-MATCH): Boost accuracy in data analysis. These formulas let you pull out, compare, and work with data from different sheets. Learning these tools strengthens your data reports.
• Solver and Goal Seek: Explore different outcomes and find the best answers by adjusting variables. These tools help solve complex problems and are key for business planning, financial forecasting, and decision-making.
• Excel Integration: Link Excel with programs like Word for smooth sharing. You can add Excel charts and tables straight into Word or PowerPoint. This makes creating reports and presentations faster and more professional.

FAQ