Excel Fundamentals for Office Administrators

0( 0 REVIEWS )
1 STUDENTS

Excel Fundamentals for Office Administrators

0( 0 REVIEWS )
1 STUDENTS

GET LIFETIME ACCESS TO ALL OUR COURSES FOR ONLY £199 £99 GET NOW

Excel Fundamentals For Office Administrators Take 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
Excel Fundamentals for Office Administrators

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Excel Fundamentals For Office Administrators Take This Course

Share Link on svg

Instructors

© Course Gate Edukite Ltd, Reg no: 11378092

0
Your Cart

Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49.00per year

ADD OFFER TO CART

No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.