Description
Overview
This course will teach students about information systems risk. Topics covered include risk identification, assessment, evaluation, response, and monitoring, as well as information systems control design and implementation.
Series Taught By: John Glover
Available CEUs for Course Series Completion: 6
Students can earn up to 6 CEUs for fully completing this course series. This information will be displayed on the certificate of completion. Learn More
Course Details
- 08:24:00 Hours
- 12 Months Access
- Presented by highly qualified, industry leading experts
About this Course
Excel 2016 is the powerful spreadsheet application in the Office suite. It seems every organization, large and small, uses Excel to organize and analyze data. However, many users are intimidated by Excel and confused by how it behaves as an application. The Excel 2016 Essentials series strives to empower users by learning the foundations to conquer this program. We begin with basic skills such as navigating the interface, identifying items in a spreadsheet, selecting cells, and inputting data. The series also covers formatting text and numbers, modifying a worksheet layout, printing and page layout, and managing worksheets in a workbook. While this series is designed for beginner users, it has lots of great tips and tricks for experienced users as well.
Objectives
- Insert rows and columns
- Merge and split cells
- Select data
- Use Find and Replace
- Hide and unhide cells
- Create a new workbook
- Save a workbook
- Enter and delete data
Audience
This course is designed for those who wish to gain the necessary skills to create, edit, format and print basic Microsoft Excel 2016 / 365 worksheets.
Prerequisites
- Type and use a keyboard
- Navigate through Windows files and folders
- Work with windows – minimise, maximise, open and close
Course Outline
Top of Form
Introduction
- Overview
- Introduction To Excel
- Excel Basics
- Excel Interface
- Navigate A Workbook
- Select Cells
- Insert Data
- Fill Series And Flash Fill
- Export And File Types
FORMAT WORKBOOKS
- Modify A Worksheet
- Format A Worksheet
- Format A Worksheet Part 2
- Number Formats: Introduction
- Number Formats: Common Number Formats
- Number Formats: Text, Special, Custom
- Number Formats: Date And Time
- Proof, Print And Page Layout
- Proof, Print And Page Layout Part 2
- Manage Sheets And Workbooks