ADVANCED MICROSOFT EXCEL
Course Introduction:
This workshop will teach you the most common advanced features of Microsoft Excel. The goal of this course is to get you familiar with these functions in a safe learning environment. Once you complete the course, your familiarity and confidence in using the advanced features of Excel will increase, making the software a more useful tool for you at work or at home. This 2 days, instructor-led course will provide you with the knowledge and skills to understand Microsoft excel. Who Should Attend?
This course is intended for Existing users, Business Analyst After completing this course, participants will be able to:
Efficient business analysis and reporting
Increased Data Integrity
Excellent management of service interactions with customers
Increase in employee productivity
Achievement of operational efficiency
Decreased liability
Comprehensive view of customer interactions and data
Course Content:
EXCEL 2013 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
EXCEL 2013 INPUT TABLES
One-Input Data Tables
Two-Input Data Tables
EXCEL 2013 CHARTS
Creating A Combo Line And Column Chart
Changing The Chart Type For A Particular Data Series
Adding A Data Series To A Chart
Removing A Data Series From A Chart
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
Formatting The Chart Plot Area Using A Picture
Formatting The Chart Area Using A Picture
EXCEL 2013 AND HYPERLINKS
Inserting A Hyperlink
Editing A Hyperlink
Removing A Hyperlink
LINKING & EMBEDDING WITHIN EXCEL 2013
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
IMPORTING TEXT FILES INTO EXCEL 2013
What Is A Delimited Text File?
Importing A Delimited Text File
SORTING, FILTERING & TOTALLING DATA WITHIN EXCEL 2013
Sorting Data By Multiple Columns At The Same Time
Applying A Pre-Installed Custom Sort
Creating A Customized List And Performing A Custom Sort
Deleting An Excel Customised List
Using Autofilter
Using Autofilter To Perform Multiple Queries
Top 10 Autofilter
Removing All Autofilters From A Worksheet
Advanced Filter Criteria
Sub-Totalling
Removing Subtotals
Expanding And Collapsing Outline Detail Levels
TRACKING AND REVIEWING CHANGES IN EXCEL 2013
Enabling Or Disabling The 'Track Changes' Feature
Sharing, Comparing And Merging Worksheets
EXCEL 2013 SCENARIOS
Scenario Manager
Scenario Summary Reports
VALIDATING WITHIN EXCEL 2013
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
AUDITING TECHNIQUES IN EXCEL 2013
Tracing Precedent Cells
Tracing Dependent Cells
Identifying Cells With Missing Dependents
Showing All Formulas In A Worksheet, Rather Than The Resulting Values
Inserting And Viewing Comments
Editing Comments 190
Deleting Comments
Showing And Hiding Comments 192
MACROS WITHIN EXCEL 2013
Recording An Excel Macro
EXCEL 2013 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