Microsoft Office Excel 2016: Part 1 Beginner Level

Microsoft Office Excel 2016: Part 1 Beginner Level, available at $39.99, has an average rating of 4.7, with 49 lectures, 6 quizzes, based on 14 reviews, and has 145 subscribers.

You will learn about Navigate the user interface. Perform calculations, create formulas. Search for and replace data. Format a worksheet. Apply Conditional Formatting. Print workbooks. Use and create Templates Manage Workbook Properties. This course is ideal for individuals who are This course is intended for those who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets. or This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam. It is particularly useful for This course is intended for those who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets. or This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

Enroll now: Microsoft Office Excel 2016: Part 1 Beginner Level

Summary

Title: Microsoft Office Excel 2016: Part 1 Beginner Level

Price: $39.99

Average Rating: 4.7

Number of Lectures: 49

Number of Quizzes: 6

Number of Published Lectures: 49

Number of Published Quizzes: 6

Number of Curriculum Items: 55

Number of Published Curriculum Objects: 55

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Navigate the user interface.
Perform calculations, create formulas.
Search for and replace data.
Format a worksheet.
Apply Conditional Formatting.
Print workbooks.
Use and create Templates
Manage Workbook Properties.

Who Should Attend

This course is intended for those who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

Target Audiences

This course is intended for those who wish to gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.
This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.

COURSE DESCRIPTION

Do you want to finally understand the concept of Excel 2016 and learn basic skills? In this basic course you will learn to understand, in which scenarios the use of Excel 2016 makes sense. Create error-free tables and master the first calculations. You will also learn how data, values and formulas are stored in cells and how you can do more calculations from here. Excel 2016 is one of the most used office programs. However, users without training support usually only use 10% of the functionality of Excel 2016.

METHOD

The trainer explains step by step all important and useful functionalities and features for working with Microsoft Excel. Benefit from the extensive additional materials that are integrated into the training. Look forward to practice files, handouts and quizzes. The training starts with the absolute basics of creating your very first worksheet and progresses through learning numerous capabilities of this very powerful program. Practice files will help you follow the step-by-step training and you can check what you’ve learned with our quizzes. This course will help you to prepare for the official Microsoft Office Specialist exam.

THIS COURSE IS SUITABLE FOR YOU IF

you are an Excel beginner
you wish to gain foundational understanding of Excel 2016
you need to create and work with electronic spreadsheets

COURSE PREREQUISITES

To ensure success, you need to be familiar with using personal computers and should have experience using a keyboard and mouse. You should also be comfortable working in the Windows environment.

COURSE OBJECTIVES

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

You will:

Perform calculations
Modify a worksheet
Format a worksheet
Print workbooks
Manage workbooks

Course Curriculum

Chapter 1: Getting Started with Excel 2016

Lecture 1: Navigate the Excel User Interface – Introduction

Lecture 2: Navigate the Excel User Interface

Lecture 3: Use Excel Commands – Introduction

Lecture 4: Use Excel Commands

Lecture 5: Create and Save a Basic Workbook – Introduction

Lecture 6: Create and Save a Basic Workbook

Lecture 7: Enter Cell Data – Introduction

Lecture 8: Enter Cell Data

Lecture 9: Flash Fill and Auto Fill

Lecture 10: Use Excel Help – Introduction

Lecture 11: Use Excel Help

Chapter 2: Performing Calculations

Lecture 1: Create Worksheet Formulas – Introduction

Lecture 2: Create Worksheet Formulas

Lecture 3: Insert Functions – Introduction

Lecture 4: Insert Functions

Lecture 5: Reuse Formulas and Functions – Introduction

Lecture 6: Reuse Formulas and Functions

Chapter 3: Modifying a Worksheet

Lecture 1: Insert, Delete and Adjust Cells, Columns and Rows

Lecture 2: Search for and Replace Data

Lecture 3: Insert, Delete and Adjust Cells, Columns and Rows – Introduction

Lecture 4: Use Proofing and Research Tools

Lecture 5: Check the Spelling in a Worksheet

Lecture 6: Search for and Replace Data – Introduction

Lecture 7: Insights Task Pane

Chapter 4: Formatting a Worksheet

Lecture 1: Apply Text Formats – Introduction

Lecture 2: Apply Text Formats

Lecture 3: Apply Number Formats – Introduction

Lecture 4: Apply Number Formats

Lecture 5: Align Cell Contents – Introduction

Lecture 6: Align Cell Contents

Lecture 7: Apply Cell Styles and Themes

Lecture 8: Apply Cell Styles and Themes – Introduction

Lecture 9: Create and Use Templates – Introduction

Lecture 10: Apply Basic Conditional Formatting – Introduction

Lecture 11: Apply Basic Conditional Formatting

Lecture 12: Create and Use Templates

Chapter 5: Printing Workbooks

Lecture 1: Preview and Print a Workbook

Lecture 2: Configure and Preview a Print Job

Lecture 3: Set Up the Page Layout – Introduction

Lecture 4: Set Up the Page Layout

Lecture 5: Configure Headers and Footers – Introduction

Lecture 6: Configure Headers and Footers

Chapter 6: Managing Workbooks

Lecture 1: Manage Worksheets – Introduction

Lecture 2: Manage Worksheets

Lecture 3: Manage Workbook and Worksheet Views – Introduction

Lecture 4: Manage Workbook and Worksheet Views

Lecture 5: Manage Workbook Properties – Introduction

Lecture 6: Manage Workbook Properties

Lecture 7: Bonus Lecture

Instructors

SONIC Performance Support – E-Learning Experts
Training Company

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 4 votes
5 stars: 9 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu