Excel for Office Administrator
Course Overview
You’ll have an arsenal of skills to lock down your desired career after completing this Excel for Office Administrator course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.
With this comprehensive Excel for Office Administrator course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this Excel for Office Administrator course to the basket and take your expertise up a notch!
Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.
Why Choose Thames College?
Thames College offers you the benefit of —
- Learn with engaging voice-over and visual elements to facilitate your learning process.
- Receive round-the-clock access to expert assistance.
- Participate in quick assessments and get instant feedback on your progress.
- Study at your own schedule from the convenience of your own home.
Who Is This Course For?
Those who want to strengthen their professional skills while training for the desired job should take advantage of the Excel for Office Administrator training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this Excel for Office Administrator course if you want the best training available.
Certificate of Achievement
CPD Certification
After successfully completing the assessment of this Excel for Office Administrator course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.
Requirements
No formal entry requirements! No prerequisites or relevant experience is required!
This course is accessible to anyone with an eagerness to learn. All you require is—
- A smart device with a stable internet connection
- A keen interest in this subject
- And being over the age of 16.
Career Path
Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.
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 – Spreadsheet Specialist Training | 00:00:00 | ||
Certificate of Achievement
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
Access
Level
Number of Units
Number of Quizzes
Duration
