Excel for Office Administrator
Course
Online
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Class hours
10h
-
Duration
1 Year
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
Become an Excel expert in a matter of hours and manage everyday office tasks faster and more efficiently with the Mastering MS Excel. This course is ideal for professionals in administrative and IT-based roles who want to improve their proficiency in Microsoft Office.
Throughout this Microsoft Excel training course, you will develop valuable administrative skills which will assist you in automating everyday work tasks, collaborating on spreadsheets, and data management. Taking you from beginner to advanced levels, you will learn how to create a basic spreadsheet, perform a financial analysis, insert tables, record macros and much more.
On successful completion, you will have a solid knowledge of how to utilise the world’s leading spreadsheet program for business administration and master basic and complex work tasks.
Facilities
Location
Start date
Start date
About this course
Learn how to navigate the Excel User Interface
Understand how to perform commands equations in excel
Learn how to modify your Excel worksheet
Develop skills in creating tables and applying conditional formats
Understand and execute pivot tables
Learn how to use LookUp functions and audit work
Learn how to use sparklines and map your data
Learn how to forecast data using Data Tables and Scenarios
The Excel for Office Administrator is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Upon successful completion you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 5 years
Subjects
- Excel
- Office IT
- Spreadsheet
- Ms Office
- MS Excel
- Microsoft Office
- Calculations
- Functions
- Managing
- Workbooks
- Performing
Course programme
- Getting Started with Microsoft Office Excel 2016
- Performing Calculations
- Modifying a Worksheet
- Formatting a Worksheet
- Printing Workbooks
- Managing Workbooks
- Working with Functions
- Working with Lists
- Analyzing Data
- Visualizing Data with Charts
- Using PivotTables and PivotCharts
- Working with Multiple Worksheets and Workbooks
- Using Lookup Functions and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Forecasting Data
- Resources
Excel for Office Administrator