Microsoft Excel 2016 Beginners Training CPD & IAO Accredited -Special Discount Offer *NUS Extra Card Eligible*
Overview
If you really want to be the best at something, you need to have some strong basics. And given that Microsoft Excel is one of the most used spreadsheet programs in the world, with a large number of features allowing users to tabulate data and analyse them through charts and graphs, you need to know it’s basics as well. With the help of this Microsoft Excel 2016 Beginners Training course you can definitely work it out.
Who is it for
As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds.
Description
This course will help you learn the 2016 version of Excel and explore the new features available within. You first get started with familiarizing yourself with the user interface, learning to create a basic worksheet and using the help system. Next you will discover how to use formulas and functions in order to carry out calculations before moving onto modifying the data; columns and rows; utilizing search and replace; and carrying out spell checks. You will also learn about formatting the worksheet, printing the workbook contents, managing large workbooks and customizing Excel.

If you want to learn the basics of MS Excel, this is a great course as it can help you through various useful features. All of these reasons combined, you should definitely get this course now.

COURSE CURRICULUM

Identify the Elements of the Excel Interface
Activity – Identify the Elements of the Excel Interface
Create a Basic Worksheet
Activity – Create a Basic Worksheet
Use the Help System
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
Reuse Formulas
Activity – Reuse Formulas
Manipulate Data
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
Spell Check a Worksheet
Activity – Spell Check a Worksheet
Modify Fonts
Activity – Modify Fonts
Add Borders and Colors to Cells
Activity – Add Borders and Colors to Cells
Apply Number Formats
Activity – Apply Number Formats
Align Cell Contents
Activity – Align Cell Contents
Apply Cell Styles
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
Format Worksheet Tabs
Activity – Format Worksheet Tabs
Manage Worksheets
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

Activities

Activities – Microsoft Excel 2016 Beginners Training

Requirements
There are no prerequisites for this course and it is open to everyone.
Career Path
This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful in no time. You will be able to stand out in the crowd after completing this course. You will also be able to add our qualifications to your Resume and make yourself worthy in the competitive job industry.

People also viewed

Diploma in Marketing (Level 4):
  • Online
  • £249 (was £560)
Animal Psychology Course
  • Online
  • £29 (was £350)