Description

Duration

1 Days

6 CPD hours

This course is intended for

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.

Overview

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.

This course is intended for those who wish to gain the foundational understanding of Excel that is necessary to create and work with electronic spreadsheets. Excel can help you organise, calculate, analyse, revise, update, and present your data.

Getting Started with Excel

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter and Edit Cell Data

Fill Cells with Series of Data (AutoFill and Flash Fill)

Use Excel Help

Performing Calculations

Create Worksheet Formulas

Insert Functions and use Autocomplete

Reuse Formulas and Functions

Create an Absolute Reference

Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows

Move and Copy Data between Cells

Search for and Replace Data

Use Spellcheck and Proofing

Formatting a Worksheet

Apply Text Formats

Apply Number Formats

Align Cell Contents

Apply and Copy Cell Styles

Apply Basic Conditional Formatting

Printing Workbooks

Preview and Print a Workbook

Controlling Page Layout

Adding Headers and Footers

Set Print Titles and Print Ranges

Managing Workbooks

Manage Worksheets

Insert and Delete Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

Course Images

Excel - Excel Essentials and Formulas

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews