Microsoft Office Excel 2016 – Part 1,2,3

0.00

Excel can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you and the decision makers in your organization gain the ultimate competitive edge. If you are using Excel 2016 – part of the Office 365 suite and working with the latest features to collaborate, share, and work on-the-go with, or using earlier versions like Excel 2013 – these courses will get you working effectively and efficiently to ensure you are making the most of the world’s most powerful and versatile data management tool.

Choose Part 1, 2 or 3 or take our 3 for 2 ‘mix and match’

Sharing is caring!

Out of stock

Category:

In this course, you will learn fundamental Excel skills. You will start by getting acquainted with the Excel user interface, perform basic calculations and organise data. Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with, organise and analyze the data that is critical to the success of your organization.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Excel.

Each student will receive:

Microsoft Office 2013 certificate of completion
Microsoft Office 2013 Certiifcation exam (optional extra)
Official Microsoft Office 2013 Course Manual
12 months FREE email support
FREE class repeat (if necessary)

Sharing is caring!

Part 1:
Get started with Microsoft Office Excel.
Perform basic calculations with operators and functions.
Modify a worksheet and arrange data.
Format a worksheet and style your information..
Print your data, worksheets and workbooks.
Manage workbooks with templates, properties and views.

Part 2:
Customize the Excel environment.
Create advanced formulas.
Analyze data by using functions and conditional formatting.
Organize and analyze datasets and tables.
Visualize data by using basic charts.
Analyze data by using PivotTables, slicers, and PivotCharts.

Part 3:
Work with multiple worksheets and workbooks simultaneously.
Share and protect workbooks.
Automate workbook functionality.
Apply conditional logic with advanced formulas.
Troubleshoot and audit worksheets.
Use automated analysis tools and plugins.
Present your data visually in other applications and formats.

Sharing is caring!

Part 1:
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and work with electronic spreadsheets.

Part 2:
This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Part 3:
This course is intended for students who are experienced Excel 2013 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.
Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

Sharing is caring!

Sharing is caring!