Microsoft Excel 2013 (ADVANCED)

Our Ration for the course : 4.7 Start Based on 24 users

Experienced and Friendly Expert Trainers

Practical hands-on Training

Interactive Training Experience

Name of Course	Scheduled Dates	Vanue	Registration Link
Microsoft Excel 2013 (Advanced)	To be determined	NBIZ Infosol Abu Dhabi	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Beirut, Lebanon	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Doha, Qatar	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Muscat, Oman	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Manama, Bahrain	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Cairo, Egypt	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Chennai, India	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Dubai, UAE	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Abu Dhabi, UAE	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Tehran, Iran	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Riyadh, Saudi Arabia	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Jeddah, Suadi Arabia	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Baghdad, Iraq	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Abu Dhabi, UAE	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Chennai, India	Registration Now
Microsoft Excel 2013 (Advanced)	To be determined	Abu Dhabi, UAE	Registration Now

Introduction

This one-day instructor-led course provides students with an overview of the more advanced features and functions of Microsoft Office Excel 2013. This course is intended for experienced information workers who want to learn advanced-level Excel 2013 skills. Before attending this course, students must have basic computer knowledge, basic file-management skills, basic knowledge of the Excel interface, workbook manipulation and formula creation.

Course Objectives

After completing this course, students will be able to:

Define an alternative data set.
Define multiple alternative data sets.
Vary your data to get a desired result by using Goal Seek.
Find optimal solutions by using Solver.
Analyze data by using descriptive statistics.
Analyze data dynamically by using PivotTables.
Filter, show, and hide PivotTable data.
Edit PivotTables.
Format PivotTables.
Create PivotTables from external data.
Create dynamic charts by using Pivot Charts.
Describe and examine macros.
Create and modify macros.
Run macros when a button is clicked.
Run macros when a workbook is opened.
Include Office documents in worksheets.
Store workbooks as parts of other Office documents.
Create hyperlinks.
Paste charts into other documents.
Share data lists.
Manage comments.
Track and manage colleagues’ changes.
Protect workbooks and worksheets.
Authenticate workbooks.
Save workbooks for the Web.

Duration & Learning Level

Learning Level:

Duration:

Module 1: Data Analysis

Defining an Alternative Data Set
Defining Multiple Alternative Data Sets
Varying Your Data to Get a Desired Result by Using Goal Seek
Finding Optimal Solutions by Using Solver
Analyzing Data by Using Descriptive Statistics

Module 2: PivotTables and Pivot Charts

Analyzing Data Dynamically by Using PivotTables
Filtering, Showing, and Hiding PivotTable Data
Editing PivotTables
Formatting PivotTables
Creating PivotTables from External Data
Creating Dynamic Charts by Using Pivot Charts

Module 3: Macros

Introducing Macros
Creating and Modifying Macros
Running Macros When a Button Is Clicked
Running Macros When a Workbook Is Opened

Module 4: Office Document Recycling

Including Office Documents in Worksheets
Storing Workbooks as Parts of Other Office Documents
Creating Hyperlinks
Pasting Charts into Other Documents

Module 5: Collaboration

Sharing Data Lists
Managing Comments
Tracking and Managing Colleagues’ Changes
Protecting Workbooks and Worksheets
Authenticating Workbooks
Saving Workbooks for the Web

Exam & Certificate

Upon completion of the training the participants will be provided a Certificate of Completion / Attendance.

Participants have the option to gain MOS - Microsoft Office Specialist Certification by clearing the required exam. Microsoft Office Specialist (MOS) Certification is granted to individuals who have excellent skills and expertise in using Microsoft Office applications. This is a comprehensive certification authorized by Microsoft and it validates your competency and knowledge in Microsoft Office. Details are available through this link.

Target Group

Participants who want to learn advanced-level Excel
Office Personnel
Sales Professionals
Regular Computer Users
Supervisors and Managers

1. How do I enroll/register for the training course?

To enroll or register to any training course, you can use the registration page from training page or fill the request a call back form from each course pages. The following page will provide you a list of course and training that we are providing based on the category and from each course item you can see the course details.
URL: https://nbizinfosol.twtests.co.in/training.aspx
Another method is to fill a Request a call back form provided in each Training/Course pages.