One of the most compelling tools that an administrator or executive assistant required to master is Microsoft Excel since they need to perform varied tasked with many complex assignments every day.
The Excel Essentials for Office Administrators course will enhance your skills and understanding to collect and present valuable data to management, and you will consider how data can import from text files, databases, or even from web sources and how collected information can analyse, organise and present in such a way to make decisions based on facts and data analysis. Besides, learning shortcuts and using macros from this course will help you to process information quickly and decrease manual workloads and pressure.
Benefits of studying Excel Essentials for Office Administrators:
24/7 access to the course for 12 months
No hidden fees or exam charges
CPD endorsed certification on successful completion
Full Tutor support on weekdays (Monday – Friday)
Efficient exam system, assessment, and instant results
Improve your chance of gaining professional skills and better earning potential.
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
This course is designed with the following modules:
Identify the Elements of the Excel Interface
Activity – Identify the Elements of the Excel Interface
Activity – Create a Basic Worksheet
Activity – Use the Help System
Create Formulas in a Worksheet
Activity – Create Formulas in a Worksheet
Insert Functions in a Worksheet
Activity – Insert Functions in a Worksheet
Activity – Reuse Formulas
Activity – Manipulate Data
Insert, Manipulate, and Delete Cells, Columns, and Rows
Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
Search For and Replace Data
Activity – Search For and Replace Data
Activity – Spell Check a Worksheet
Add Borders and Colors to Cells
Activity – Add Borders and Colors to Cells
Activity – Apply Number Formats
Activity – Align Cell Contents
Activity – Apply Cell Styles
Define the Basic Page Layout for a Workbook
Activity – Define the Basic Page Layout for a Workbook
Refine the Page Layout and Apply Print Options
Activity – Refine the Page Layout and Apply Print Options
Activity – Format Worksheet Tabs
Activity – Manage Worksheets
Manage the View of Worksheets and Workbooks
Activity – Manage the View of Worksheets and Workbooks
Customize General and Language Options
Activity – Customize General and Language Options
Customize Formula Options
Activity – Customize Formula Options
Customize Proofing and Save Options
Activity – Customize Proofing and Save Options
Customize the Ribbon and Quick Access Toolbar
Activity – Customize the Ribbon and Quick Access Toolbar
Customize the Functionality of Excel by Enabling Add-Ins
Activity – Customize the Functionality of Excel by Enabling Add-Ins
Customize Advanced and Trust Center Options
Activity – Customize Advanced and Trust Center Options
Use Specialized Functions
Use Subtotal and Database Functions to Calculate Data
Filter Data by Using Slicers
Analyze Data with PivotCharts
Insert and Modify Graphics Objects
Layer and Group Graphic Objects
Preparing a Workbook for Multiple Audiences
How is the course assessed?
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
