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