Excel for Office Administrator

Home
Course
Hidden Course
Excel for Office Administrator

Level: Intermediate
Modules: 60 Modules
Duration: 10 hours, 28 minutes
Students: 127

Overview

Easily learn the skills and knowledge you desire in mastering MS Excel with our Excel for Office Administrator, you get an unparalleled learning experience with us and you get a digital certificate, transcript and a student ID card all included with the course price.
What makes us the go to choice for people who want to learn about mastering MS Excel is our dedication and commitment to providing you with the best service possible. You will get unlimited access to the Excel for Office Administrator, no matter where you are in the world you will be able to access your Excel for Office Administrator any time you want.
Should you have any questions while studying this Excel for Office Administrator, our experienced tutors and mentors will answer them via email and live chat.
With the original certificate you get after completing your Excel for Office Administrator you will gain the CPD qualifications that will help you succeed out in the world and in your career.
With our Student ID card you will get discounts on things like music, food, travel and clothes etc.
Enrol in our Excel for Office Administrator today and start learning.

Why buy this Excel for Office Administrator?

Digital Certificate, Transcript, student ID all included in the price
Absolutely no hidden fees
Directly receive CPD accredited qualifications after course completion
Receive one to one assistance on every weekday from professionals
Immediately receive the PDF certificate after passing
Receive the original copies of your certificate and transcript on the next working day
Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the Excel for Office Administrator you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.

Who is this course for?

This Excel for Office Administrator does not require you to have any prior qualifications or experience. You can just enrol and start learning.

Prerequisites

This Excel for Office Administrator was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Career path

As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Excel for Office Administrator is a great way for you to gain multiple skills from the comfort of your home.

Course Curriculum

Getting Started with Microsoft Office Excel 2016
	Navigate the Excel User Interface	00:28:00
	Use Excel Commands	00:10:00
	Create and Save a Basic Workbook	00:19:00
	Enter Cell Data	00:12:00
	Use Excel Help	00:05:00
Performing Calculations
	Create Worksheet Formulas	00:15:00
	Insert Functions	00:17:00
	Reuse Formulas and Functions	00:17:00
Modifying a Worksheet
	Insert, Delete, and Adjust Cells, Columns, and Rows	00:10:00
	Search for and Replace Data	00:09:00
	Use Proofing and Research Tools	00:07:00
Formatting a Worksheet
	Apply Text Formats	00:16:00
	Apply Number Format	00:08:00
	Align Cell Contents	00:09:00
	Apply Styles and Themes	00:12:00
	Apply Basic Conditional Formatting	00:11:00
	Create and Use Templates	00:08:00
Printing Workbooks
	Preview and Print a Workbook	00:10:00
	Set Up the Page Layout	00:09:00
	Configure Headers and Footers	00:07:00
Managing Workbooks
	Manage Worksheets	00:05:00
	Manage Workbook and Worksheet Views	00:07:00
	Manage Workbook Properties	00:06:00
Working with Functions
	Work with Ranges	00:18:00
	Use Specialized Functions	00:11:00
	Work with Logical Functions	00:23:00
	Work with Date & Time Functions	00:08:00
	Work with Text Functions	00:11:00
Working with Lists
	Sort Data	00:10:00
	Filter Data	00:10:00
	Query Data with Database Functions	00:09:00
	Outline and Subtotal Data	00:09:00
Analyzing Data
	Create and Modify Tables	00:16:00
	Apply Intermediate Conditional Formatting	00:07:00
	Apply Advanced Conditional Formatting	00:05:00
Visualizing Data with Charts
	Create Charts	00:13:00
	Modify and Format Charts	00:12:00
	Use Advanced Chart Features	00:12:00
Using PivotTables and PivotCharts
	Create a PivotTable	00:13:00
	Analyze PivotTable Data	00:12:00
	Present Data with PivotCharts	00:07:00
	Filter Data by Using Timelines and Slicers	00:11:00
Working with Multiple Worksheets and Workbooks
	Use Links and External References	00:12:00
	Use 3-D References	00:06:00
	Consolidate Data	00:05:00
Using Lookup Functions and Formula Auditing
	Use Lookup Functions	00:12:00
	Trace Cells	00:09:00
	Watch and Evaluate Formulas	00:08:00
Sharing and Protecting Workbooks
	Collaborate on a Workbook	00:19:00
	Protect Worksheets and Workbooks	00:08:00
Automating Workbook Functionality
	Apply Data Validation	00:13:00
	Search for Invalid Data and Formulas with Errors	00:04:00
	Work with Macros	00:18:00
Creating Sparklines and Mapping Data
	Create Sparklines	00:07:00
	MapData	00:07:00
Forecasting Data
	Determine Potential Outcomes Using Data Tables	00:08:00
	Determine Potential Outcomes Using Scenarios	00:09:00
	Use the Goal Seek Feature	00:04:00
	Forecasting Data Trends	00:05:00
Resources
	Resources – Excel for Office Administrator	00:00:00