Overview
In This Advanced Microsoft Excel Training Course you will Gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Why Learn Microsoft Advanced?
Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.
Audience Profile :
- Experienced Excel users who want to learn the topics covered in this advanced course in the interface.
Prerequisites:
- Knowledge of Microsoft Excel Fundamentals.
Course Outlines
Module 1: Using Pivot Tables
Creating Pivot Tables
More PivotTable Functionality
Inserting Slicers
Multi-Select Option in Slicers
PivotTable Enhancements
Working with Pivot Table
Inserting Pivot Charts
More Pivot Table Functionality
Working with Pivot TablesModule 2: Auditing Worksheets
Tracing Precedents
Tracing Dependents
Showing Formulas
Auditing Worksheets ExercisesModule 3: Data Tools
Converting Text to Columns
Linking to External Data
Controlling Calculation Options
Data Validation
Using Data Validation
Consolidating Data
Goal Seek
Using Goal Seek
Data Tools ExercisesModule 4: Working with Others
Protecting Worksheets and Workbooks
Password Protecting a Workbook
Password Protecting a Worksheet
Password Protecting Ranges in a Worksheet
Marking a Workbook as Final
Working with Others ExercisesModule 5: Recording and Using Macros
Recording Macros
Recording a Macro
Running Macros
Editing Macros
Adding Macros to the Quick Access Toolbar
Adding a Macro to the Quick Access Toolbar
Recording and Using Macros ExercisesModule 6: Random Useful Items
Sparklines
Inserting and Customizing Sparklines
Using Microsoft Translator
Preparing a Workbook for Internationalization and Accessibility
Importing and Exporting Files
Importing Text Files
Copying Data from Excel to Word
Copying Charts from Excel to Word
Random Useful Items ExercisesModule 7: Cloud
Using the Cloud.
Training Solutions:
- Offline Classroom Instructor-Led Training in our labs or onsite Locations.
- Virtual Instructor-Led Training Via
- Virtual Video Conferencing Tools.
Why Learners Prefer iLearn as their Training Services provider ?
- Premuim Training Services Accredited from Global Technology Vendors.
- Best Rated Experts & Certified Trainers in Egypt.
- Official Training Hours, Practice Labs, Hands-on Learning.
- iLearn Classrooms are designed with High Edge PCs and Training Facilities.
- Return on Training Investment is Guaranteed to boost performance.
