Key Features
- 1 day Instructor-Led Live Online Classroom
- Webex Virtual Class for interactive near classroom experience
- Access to Remote Lab PC for Hands-On activities
- Integrated Courseware in the Learning Management System
- Step by Step guide for challenging hands-on lab activities
- Flexible Schedules – Both Weekdays and Weekends Classes
- Get Trained by Certified ME Excel Trainer with Over 15 Years of Industry Experience
- No. 1 Training Center for Office 365 Courses
- Best Price Guaranteed for Office 365 Courses
Key Features
- 1 day Instructor-Led Face to Face Classroom training
- We are a TESDA Registered Training Center
- Offering Flexible Schedules – Both Weekdays and Weekends Classes
- Get Trained by Certified MS Excel Trainer with Over 15 Years of Industry Experience
- No. 1 Training Center for Office 365 Courses
- We Guarantee Best Price for Office 365 Courses
Key Features
- Gain the technical skills needed in the workplace. 1 on 1 training is the best way to learn
- Quickest way to master any of our course offerings.
- Experience superb hands-on laboratory activities and unobstructed attention from your trainer.
- Guaranteed to start the Training
TRAINEE FEEDBACKS
ABOUT THE COURSE
This 1-day course is designed specifically for the Advanced level. This will be your final step in learning how to be efficient in Microsoft Excel. Training is more on the actual implementation of MS Excel in making spreadsheets for office data purposes.
WHO SHOULD ATTEND
This course is for organizations and individuals who are looking to create and manage Advanced MS Excel Spreadsheets. It is ideal for Office Staff, Fresh IT Graduates, IT Enthusiasts, and to those who support and manipulate company data.
COURSE OUTCOME
After completing this course you will learn how to:
- Create pivot tables and charts.
- Learn to trace precedents and dependents.
- Convert text and validate and consolidate data.
- Collaborate with others by protecting worksheets and workbooks.
- Create, use, edit, and manage macros.
- Import and export data.
ENTRY REQUIREMENTS
MS Excel for Intermediate
OCCUPATIONAL OBJECTIVES
Upon completion of the course, students will be qualified to be a data analyst, bookkeeper, office clerk
COURSE CURRICULUM
Microsoft Excel for Advanced Syllabus
Chapter 1: Using Pivot Tables
- Creating Pivot Tables
- Inserting Slicers
- Working with Pivot Tables
- Inserting Pivot Charts
- More Pivot Table Functionality
Chapter 2: Auditing Worksheets
- Tracing Precedents
- Tracing Dependents
- Showing Formulas
Chapter 3: Data Tools
- Converting Text to Columns
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Consolidating Data
- Goal Seek
Chapter 4: Working with Others
- Protecting Worksheets and Workbooks
- Tracking Changes
- Marking a Workbook as Final
Chapter 5: Recording and Using Macros
- Recording Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
Chapter 6: Random Useful Items
- Sparklines
- Preparing a Workbook for Internationalization and Accessibility
- Importing and Exporting Files
Chapter 7: Microsoft Excel Features that Were New in 2013
- Using Slicers to Filter Data
- Creating a PivotTable Timeline
- Creating a Standalone PivotChart
- Workspaces in Excel 2013
Chapter 8: Features New in 2016
- PivotTable Updates
- Ink Equations
- Multi-Select Option in Slicers
- Quick Shape Formatting
- Sharing with SharePoint or OneDrive
COURSE FEE
COURSE SCHEDULES
1 day / 8am - 5pm (8hrs)
No Events
Next Level Course
Call Us for more information
Tel: (+632) 8285-2936 / (+632) 8736-2032
SMART: 09204282022 / 09603525900
GLOBE: 09773282627 / 09563346864
GET STARTED
Request Course Quotation
Virtual/Webex Learning
Take advantage of CNCTC 's latest interactive Instructor-Led Live Online Training. Online Courses are delivered using WebEx to bring the classroom to your home or at your workplace and can be accessed directly on your own computer with an internet connection. By using Cisco’s WebEx, and integrating our Computer lab facilities, we can provide a near-classroom experience remotely to your own location of choice. Register Now!