advanced excel skills - masteryjo.commasteryjo.com/content/products/2018/3/15/advanced excel...
TRANSCRIPT
1
Advanced Excel Skills
Designed ByMastery for Business and Training Development
Course LevelAdvanced Level
Target PopulationExisting, Experienced Users
Course Duration18 training hours
2
Mastery for Business and Training Development
About MasteryMastery for Business and Training Development is established to build a unique business andtraining development experience in the market. Believing that working according to standardscan fulfil unmatched success to organizations and individuals, Mastery started with selectiveexperienced and internationally recognized professionals, who are keen to create the rightlearning and development environment solidly based on international standards. Developingtraining departments including trainers, environment, management, and material in addition toincreasing the level of services that organizations provide is the core business that Masteryprovides.
Mastery for business and training development is recognized as accredited certification exampreparation provider by the Human Resource Certification Institute (HRCI®), accredited as arecognized learning institute by the International Accreditation Organization (IAO), andaccredited as Endorsed Education Provider by International Institute of Business Analysis(IIBA®).
TrainingServices
ConsultingServices
AssessmentTools
3
Mastery for Business and Training Development
This advanced Microsoft Excel 2013 training course will teach you to use the advanced features of Excel in any version to their full extent.
By the end of this course, you will be able to report on data in a list using Pivot Tables, edit and analyze complex data using advanced
features such as Scenarios, Goal Seek and Solver, incorporate built-in functions into a worksheet, work with controls and record macros.
Course Aim
4
Mastery for Business and Training Development
Course ObjectivesAt the end of the program; the participants will be able to:
• Understand advanced excel features.• Apply macro features.• Use Pivot option on Microsoft excel.• Identify Microsoft office new features.• Relate advanced excel features to day-to-day work.
5
Mastery for Business and Training Development
Topics to be coveredThe program will cover the following topics
Advanced Functions and Formulas
Advanced Charting
Data Management
Macros
Pivot Tables
6
Mastery for Business and Training Development
Content Details
1. Using Pivot Tables
• Creating Pivot Tables.• Inserting Slicers.• Working with Pivot Tables.• Inserting Pivot Charts.• More Pivot Table Functionality.
7
Mastery for Business and Training Development
Content Details
2. Auditing Worksheets
• Tracing Precedents.• Tracing Dependents.• Showing Formulas.
8
Mastery for Business and Training Development
Content Details
3. Data Tools
• Converting Text to Columns.• Linking to External Data.• Controlling Calculation Options.• Data Validation.• Consolidating Data.• Goal Seek.
9
Mastery for Business and Training Development
Content Details
4. Working With Others
• Protecting Worksheets and Workbooks.• Tracking Changes.• Marking a Workbook as Final.
10
Mastery for Business and Training Development
Content Details
5. Recording and Using Macros
• Recording Macros.• Running Macros.• Editing Macros.• Adding Macros to the Quick Access Toolbar.
11
Mastery for Business and Training Development
Content Details
6. Random Useful Items
• Sparkline's.• Preparing a Workbook for Internationalization and Accessibility.• Importing and Exporting Files.
12
Mastery for Business and Training Development
Content Details
7. Microsoft Excel 2013 New Features
• Using Slicers to Filter Data.• Creating a PivotTable Timeline.• Creating a Standalone PivotChart.• Workspaces in Excel 2013.
13
Mastery for Business and Training Development
Training Methodologies
Presentation Discussion Audio and Video Exercises Case Study Hands-on Training
14
Mastery for Business and Training Development
Thank you
Mastery for Business and Training DevelopmentAmman - Jordan