DOWNLOAD COURSE BROCHURE

DOWNLOAD REGISTRATION FORM

Learning Objectives

• Understand Excel Data thoroughly & Prevent common mistake in Excel Reports
• Manage & Analyze Database/Excel List effectively
• Ability to connect data from another source/file
• Introduction to Macro Recording to automate repetitive task
• Manage worksheet & file Protection

Requirements

1. Participants should be able to use a PC at the beginner level
2. Basic knowledge and functionality of Microsoft Excel 
3. Microsoft Office 2013 and above
4. Good Internet Connection
5. Laptop / PC
6. Headset with Microphone

Course Outline

MICROSOFT EXCEL (ADVANCED) #1: Sorting and Filtering Data

• Sorting Data by Multiple Columns at the Same Time
• Applying a Pre-Installed Custom Sort
• Creating a Customized List and Performing a Custom Sort
• Using AutoFilter
• Using AutoFilter to Perform Multiple Queries
• Top 10 AutoFilter
• Removing All AutoFilters from a Worksheet
• Advanced Filter Criteria
• Sub-Totalling
• Removing Subtotals

MICROSOFT EXCEL (ADVANCED) #2: Pivot Tables

• Creating and Using a Pivot Table
• Filtering and Sorting Data within a Pivot Table
• Automatically Grouping Data in a Pivot Table and Renaming Groups
• Manually Grouping Data in a Pivot Table and Renaming Groups

MICROSOFT EXCEL (ADVANCED) #3: Importing Text Files

• What Is a Delimited Text File?
• Importing a Delimited Text File

MICROSOFT EXCEL (ADVANCED) #4: Linking & Embedding

• What Is Embedding and Linking?
• Linking Data within a Worksheet
• Linking Cells between Worksheets within a Workbook
• Linking Data between Workbooks
• Linking Data from Excel to a Word Document
• Linking an Excel Chart to a Word Document
• Updating, Locking and Breaking Links

MICROSOFT EXCEL (ADVANCED) #5: Hyperlinks

• Inserting a Hyperlink
• Editing a Hyperlink
• Removing a Hyperlink

MICROSOFT EXCEL (ADVANCED) #6: Tracking and Reviewing Changes

• Enabling or Disabling the ‘Track Changes’ Feature
• Sharing, Comparing and Merging Worksheets

MICROSOFT EXCEL (ADVANCED) #7: Validating

• Data Validation – Whole Number
• Data Validation – Decimal Number
• Data Validation – List
• Data Validation – Date
• Data Validation – Time
• Data Validation – Text Length
• Customising a Validation Input Message and Error Alert
• Removing Data Validation

MICROSOFT EXCEL (ADVANCED) #8: Auditing

• Tracing Precedent Cells
• Tracing Dependent Cells
• Cells with Missing Dependents
• Showing All Formulas in a Worksheet
• Inserting and Viewing Comments
• Editing and Deleting Comments
• Showing and Hiding Comments

MICROSOFT EXCEL (ADVANCED) #9: Charts

• Creating a Combined Line and Column Chart
• Adding a Secondary Axis to a Chart
• Changing the Chart Type for a Particular Data Series
• Re-Positioning Chart Title
• Re-Positioning the Chart Legend
• Moving and Formatting Chart Data Labels
• Modifying Chart Axis Scales
• Formatting an Axis to Display Using Commas
• Inserting Images into Chart Columns
• Inserting Images to Chart Bars
• Formatting the Chart Plot Area Using a Picture
• Formatting the Chart Area Using a Picture

MICROSOFT EXCEL (ADVANCED) #10: Input Tables

• One-Input Data Tables
• Two-Input Data Tables

MICROSOFT EXCEL (ADVANCED) #11: Scenarios

• Scenario Manager

MICROSOFT EXCEL (ADVANCED) #12: Macros

• ModifyingWorksheet Margins
• Macro to Change the Page Set-Up
• Macro to Apply a Custom Number Format
• Macro to Format a Cell Range
• Macro to Insert Fields into the Header or Footer
• Assigning a Macro to a Button on the Quick Access Toolbar
• Deleting Macros

MICROSOFT EXCEL (ADVANCED) #13: Passwords & Security Issues

• Adding ‘Open’ Password Protection to a Workbook
• Adding ‘Modify’ Password Protection to a Workbook
• Removing an ‘Open’ Password from a Workbook
• Removing a ‘Modify’ Password from a Workbook
• Password Protecting Cells and Worksheets
• Hiding Formulas
• Un-Hiding Formulas

Who Should Attend

• Executives
• Administrators
• Managers
• Finance and Accounting Professionals
• Financial Controllers
• Academicians