Microsoft Excel 2016 Intermediate Training - CPD & IAO Accredited
Course
Online
No experience or previous qualifications required for enrolment on this course
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Class hours
12h
-
Duration
Flexible
-
Start date
Different dates available
Since its inception in 1985, Microsoft Excel has an average of five new users added every minute. Now the total stands at more than thirty million users of this amazing spreadsheet program, who use it every day for personal and professional reasons. The 2016 version has many new features added to the program, and if you would like to learn more about them, you can do so with this Microsoft Excel 2016 Intermediate Training course.
This course is designed to help all users get familiar with the different features of Excel. As such you start out with learning how to use range names in formulas and functions, along with using specialized functions. Next you get to analyze the data with logical and lookup functions, organise and analyze datasets and tables, and also visualize data with charts. Furthermore, you will learn about creating Pivot Table, filtering data using slicers, and analyzing data using PivotCharts. Finally, the course will teach you to insert graphics, and enhance workbooks through customizing them, managing themes, and creating and using templates.
Overall this course can help you rediscover Excel, and if used correctly, you will only get to add invaluable skills to your arsenal.
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
About this course
There is no experience or previous qualifications required for enrolment on this course. It is available to all students of all academic backgrounds.
On receiving your request an academic officer from the course will call you to explain everything about the course, including how you can sign up, payment options and enrollment periods
Reviews
Subjects
- Excel
- Microsoft Excel
- Graphics
- Accredited
- Microsoft excel training
- MS Excel
- Manage Themes
- Use Lookup Functions
- Create Charts
- CProtect Files
Teachers and trainers (1)
Adams Academy
Instructor
Course programme
COURSE CURRICULUM
- Apply Range Names
- Use Specialized Functions
- Use Text Functions
- Use Logical Functions
- Use Lookup Functions
- Use Date Functions
- Use Financial Functions
- Create and Modify Tables
- Sort and Filter Data
- Use Subtotal and Database Functions to Calculate Data
- Create Charts
- Modify and Format Charts
- Create a Trendline
- Create Advanced Charts
- Create a PivotTable
- Filter Data by Using Slicers
- Analyze Data with PivotCharts
- Insert and Modify Graphics Objects
- Layer and Group Graphic Objects
- Incorporate SmartArt
- Customize Workbooks
- Manage Themes
- Create and Use Templates
- Protect Files
- Preparing a Workbook for Multiple Audiences
Microsoft Excel 2016 Intermediate Training - CPD & IAO Accredited