GET LIFETIME ACCESS TO ALL OUR COURSES FOR ONLY £199 £99 GET NOW
Take This Course
- £21.00
- 1 year
- Intermediate
- Course Certificate
- Number of Units80
- Number of Quizzes0
- 1 day, 6 hours Gift this course
Course Overview
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Excel Fundamentals for Office Administrators will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time.
The Excel Fundamentals for Office Administrators will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently.
This course is designed to provide an introduction to Excel Fundamentals for Office Administrators and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area.
Learning Objectives
- Learn the fundamental skills you require to be an expert
- Explore different techniques used by professionals
- Find out the relevant job skills & knowledge to excel in this profession
- Get a clear understanding of the job market and current demand
- Update your skills and fill any knowledge gap to compete in the relevant industry
- CPD accreditation for proof of acquired skills and knowledge
Who is this Course for?
Whether you are a beginner or an existing practitioner, our CPD accredited Excel Fundamentals for Office Administrators is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further.
It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects.
Entry Requirement
Anyone interested in learning more about this subject should take this Excel Fundamentals for Office Administrators. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject.
The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day.
CPD Certificate from Course Gate
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22.
Career path
The Excel Fundamentals for Office Administrators will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market.
Course Curriculum
| Excel Basics | |||
| 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 | ||
| Certificate and Transcript | |||
| Order Your Certificates or Transcripts | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
Take This Course
- £21.00
- 1 year
- Intermediate
- Course Certificate
- Number of Units80
- Number of Quizzes0
- 1 day, 6 hours Gift this course
Gift this courseShare Link on 
Instructors
Buying more than one of the same courses?
- 45% discount for orders of 10+ courses
- 55% discount for orders of 50+ courses
- 65% discount for orders of 100+ courses
Looking for a more personalised package?
contact us now
