Excel Essentials for Office Administrators

Home
Course
Office Productivity
Excel Essentials for Office Administrators

Level: Intermediate
Modules: 79 Modules
Duration: 1 day, 6 hours
Students: 4

Embark on a journey to master Microsoft Excel with our “Excel Essentials for Office Administrators” course. Designed to transform beginners into proficient users, this comprehensive course is divided into two main sections: Excel Beginner and Excel Intermediate. In the initial phase, learners are introduced to the Excel interface, where they explore and identify its various elements. This is followed by practical activities such as creating basic worksheets, using the help system, and crafting formulas. As the course progresses, participants will delve into more advanced features like manipulating data, applying styles and formats, and managing worksheets. The intermediate section elevates your skills further, covering a wide range of topics from applying range names and specialized functions to creating sophisticated charts and PivotTables.

Learning Outcomes

Gain proficiency in navigating and utilizing the Excel interface.
Develop the ability to create and manage complex worksheets effectively.
Master a variety of Excel functions and formulas for diverse data processing needs.
Learn advanced data management techniques including sorting, filtering, and using PivotTables.
Acquire skills in visual data presentation and customization of Excel workbooks.

Why choose this Excel Essentials for Office Administrators course?

Unlimited access to the course for a lifetime.
Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course.
Structured lesson planning in line with industry standards.
Immerse yourself in innovative and captivating course materials and activities.
Assessments designed to evaluate advanced cognitive abilities and skill proficiency.
Flexibility to complete the Course at your own pace, on your own schedule.
Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.
Unlock career resources for CV improvement, interview readiness, and job success.

Who is this Excel Essentials for Office Administrators course for?

Office administrators and secretaries seeking to enhance their Excel skills.
Professionals in various sectors requiring proficiency in Excel for data management.
Students and individuals interested in learning Excel from a beginner to an intermediate level.
Business owners needing to manage business data more efficiently.
Anyone aiming to improve their productivity and data analysis skills through Excel.

Career path

Data Analyst: £25,000 – £50,000
Administrative Assistant: £18,000 – £30,000
Office Manager: £22,000 – £40,000
Business Analyst: £30,000 – £60,000
Financial Analyst: £28,000 – £55,000
Project Coordinator: £24,000 – £45,000

Prerequisites

This Excel Essentials for Office Administrators does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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.

Certification

After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.

Course Curriculum

Excel Beginner
	Identify the Elements of the Excel Interface	00:30:00
	Activity – Identify the Elements of the Excel Interface	00:05:00
	Create a Basic Worksheet	01:00:00
	Activity – Create a Basic Worksheet	00:05:00
	Use the Help System	00:30:00
	Activity – Use the Help System	00:05:00
	Create Formulas in a Worksheet	01:00:00
	Activity – Create Formulas in a Worksheet	00:05:00
	Insert Functions in a Worksheet	00:30:00
	Activity – Insert Functions in a Worksheet	00:05:00
	Reuse Formulas	00:30:00
	Activity – Reuse Formulas	00:05:00
	Manipulate Data	00:30:00
	Activity – Manipulate Data	00:05:00
	Insert, Manipulate, and Delete Cells, Columns, and Rows	00:30:00
	Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows	00:05:00
	Search For and Replace Data	00:30:00
	Activity – Search For and Replace Data	00:05:00
	Spell Check a Worksheet	00:30:00
	Activity – Spell Check a Worksheet	00:05:00
	Modify Fonts	00:30:00
	Activity – Modify Fonts	00:05:00
	Add Borders and Colors to Cells	01:00:00
	Activity – Add Borders and Colors to Cells	00:05:00
	Apply Number Formats	00:30:00
	Activity – Apply Number Formats	00:05:00
	Align Cell Contents	00:30:00
	Activity – Align Cell Contents	00:05:00
	Apply Cell Styles	00:30:00
	Activity – Apply Cell Styles	00:05:00
	Define the Basic Page Layout for a Workbook	01:00:00
	Activity – Define the Basic Page Layout for a Workbook	00:05:00
	Refine the Page Layout and Apply Print Options	00:30:00
	Activity – Refine the Page Layout and Apply Print Options	00:05:00
	Format Worksheet Tabs	00:30:00
	Activity – Format Worksheet Tabs	00:05:00
	Manage Worksheets	00:30:00
	Activity – Manage Worksheets	00:05:00
	Manage the View of Worksheets and Workbooks	00:30:00
	Activity – Manage the View of Worksheets and Workbooks	00:05:00
	Customize General and Language Options	00:30:00
	Activity – Customize General and Language Options	00:05:00
	Customize Formula Options	00:30:00
	Activity – Customize Formula Options	00:05:00
	Customize Proofing and Save Options	01:00:00
	Activity – Customize Proofing and Save Options	00:05:00
	Customize the Ribbon and Quick Access Toolbar	00:30:00
	Activity – Customize the Ribbon and Quick Access Toolbar	00:05:00
	Customize the Functionality of Excel by Enabling Add-Ins	00:30:00
	Activity – Customize the Functionality of Excel by Enabling Add-Ins	00:05:00
	Customize Advanced and Trust Center Options	00:30:00
	Activity – Customize Advanced and Trust Center Options	00:05:00
	Activities and Exercise Files – Microsoft Excel 2016 for Beginners	00:00:00
Excel Intermediate
	Apply Range Names	00:30:00
	Use Specialized Functions	00:30:00
	Use Text Functions	00:30:00
	Use Logical Functions	00:30:00
	Use Lookup Functions	00:30:00
	Use Date Functions	00:30:00
	Use Financial Functions	00:30:00
	Create and Modify Tables	00:30:00
	Sort and Filter Data	00:30:00
	Use Subtotal and Database Functions to Calculate Data	00:30:00
	Create Charts	00:30:00
	Modify and Format Charts	00:30:00
	Create a Trendline	00:30:00
	Create Advanced Charts	00:30:00
	Create a PivotTable	00:30:00
	Filter Data by Using Slicers	00:30:00
	Analyze Data with PivotCharts	00:30:00
	Insert and Modify Graphic Objects	00:30:00
	Layer and Group Graphic Objects	00:30:00
	Incorporate SmartArt	00:30:00
	Customize Workbooks	00:30:00
	Manage Themes	00:30:00
	Create and Use Templates	00:30:00
	Protect Files	00:30:00
	Preparing a Workbook for Multiple Audiences	00:30:00
	Activities and Exercise Files – Microsoft Excel 2016 Intermediate	00:00:00