Microsoft Office Excel 2016: Part 1 Beginner Level
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
104 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office Excel 2016: Part 1 Beginner Level to your Wishlist.

Add to Wishlist

Microsoft Office Excel 2016: Part 1 Beginner Level

Create and develop Excel worksheets and workbooks in order to work with and analyze data.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
104 students enrolled
Last updated 11/2016
English
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
Requirements
  • 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.
Description

Microsoft Excel 2016 can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you or other decision makers in your organization steer you in the right direction. 

This course provides you with a foundation for Excel knowledge and skills, which you can build upon to become an expert in Excel 2016.

The instructor will explain all of the features and functionalities the application offers in an easy to understand, step-by-step method.

Exercise files are available to assist you. They can be downloaded and used to follow along with the trainer.

It’s easy to validate your knowledge with our end of chapter Quizzes.


Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
49 Lectures
02:05:59
+
Getting Started with Excel 2016
11 Lectures 31:16

Before you can effectively use Excel 2016 to store and manage your data, you need to become familiar with the application's environment. 

Preview 00:40

In this topic, you'll examine Excel's interface, including its various commands and options, so that you can quickly and efficiently work with your data in the ways you see fit. (Spreadsheets, Worksheets, and Workbooks, Cells and Ranges, Cell Regions, Cell and Range References, The Excel User Interface, Excel Window Commands, The Backstage View, Basic Data Entry) 

Navigate the Excel User Interface
06:18

You'll need to be familiar with where to look to find the commands you need. 

Use Excel Commands - Introduction
00:41

You'll need to be familiar with where to look to find the commands you need. (The Ribbon, Tell Me, ScreenTips, The Quick Access Toolbar, Dialog Box Launcher, The Mini Toolbar and Context Menus) 


Use Excel Commands
04:14

Learn how to save a workbook and how to save you workbook in previous excel versions, not everyone has Exycel 2016 and you want to provide a workbook in different file formats. 

Create and Save a Basic Workbook - Introduction
00:29

You'll find yourself creating a variety of different workbooks that you will need to save as separate items, as well as saving multiple versions of the same workbooks. (The New Tab, Excel 2016 File Formats, The Save and Save As Commands, Compatibility Mode, The Convert Option) 

Create and Save a Basic Workbook
05:01

In this topic, you'll use fundamental Excel features to help you enter data. 

Enter Cell Data - Introduction
00:29

Excel has an incredible array of information types that you can work with in your workbooks. You'll need to be familiar with what these data types are and how Excel deals with them. (Data Types, The Undo and Redo Commands, The AutoFill Feature, AutoFill Options, Flash Fill, The Clear Command)

Enter Cell Data
04:42

Learn more about time saving options you will apply every day. (Flash Fill, Auto Fill) 

Preview 04:42

Learn how to use Excel Help now could save you countless hours of research down the road and why you need help even after this training. 

Use Excel Help - Introduction
00:47

Learn how Microsoft Excel Help provides you with access to articles that can answer your Excel questions and show you how to perform various tasks within the application. (?, F1, The Excel 2016 Help Window) 

Use Excel Help
03:13

Answer these questions to test your understanding of what was learned in this lesson.

Quiz Chapter 1
5 questions
+
Performing Calculations
6 Lectures 19:22

Excel formulas perform simple or complex mathematical computations in worksheets.

Preview 00:35

You can use formulas to perform tasks such as adding up a row or a column of numbers, multiplying sales figures by commission rates, and applying tax to sales. (Excel Formulas, The Formula Bar, Elements of Excel Formulas, Common Mathematical Operators, The Order of Operations, Reference Operators)

Create Worksheet Formulas
05:54

Learn how to use the massive set of built-in formulas. 

Preview 01:09

Learn how to use functions will save you time, effort, and possibly a few headaches down the road. (Functions, Basic Function Syntax, The Function Library Group, The Function Arguments Dialog Box, Graphical Cell and Range Reference Entry, The AutoSum Feature, Other Commonly Used Functions, The Formula AutoComplete Feature) 

Insert Functions
05:44

By reusing your content, you can eliminate the hassle and reduce the likelihood of entering numerous errors in your workbooks. 

Reuse Formulas and Functions - Introduction
00:58

Excel provides you with a number of methods to reuse nearly any of your content, including formulas and functions, basically by using a variety of copy and paste techniques. (Formulas and the Cut, Copy, and Paste Commands, Drag-and-Drop Editing, The Paste Options, The Paste Special Options, Relative References, Absolute References, Mixed References, AutoFill and Formulas, Worksheet References, Excel Errors) 

Reuse Formulas and Functions
05:02

Answer these questions to test your understanding of what was learned in this lesson.

Quiz Chapter 2
2 questions
+
Modifying a Worksheet
7 Lectures 18:10

At some point in your data entry process, the amount of text you need to display in a cell may be more than the cell can hold or you may have to add a row or a column right in the middle of existing data. (The Insert and Delete Options, Width and Height Adjustments, The Hide and Unhide Commands)

Insert, Delete and Adjust Cells, Columns and Rows
04:48

Learn how to easily find and correct multiple errors in a worksheet contain thousands of rows' and columns' worth of data. (The Find Command, The Replace Command, The Go To Dialog Box) 

Search for and Replace Data
06:18

Many times you’ll need to add a new column or row to your worksheet. 

Preview 00:17

Learn how to make sure all of your content is correct before sharing some data with others. 

Use Proofing and Research Tools
00:17

Learn how proofing tools can help you make sure your worksheets are accurate and look professional. (The Spelling Dialog Box, The AutoCorrect Feature) 

Check the Spelling in a Worksheet
03:08

Learn how to find and correct mistakes throughout your workbooks quickly and easily. 

Preview 00:18

The Insights task pane uses the active cell's contents as a search query to run in Microsoft's Bing® search engine. (The Insights Task Pane, Smart Lookup) 

Insights Task Pane
03:04

Answer these questions to test your understanding of what was learned in this lesson.

Quiz Chapter 3
2 questions
+
Formatting a Worksheet
12 Lectures 30:36

Excel 2016 provides you with a number of options to help you create spreadsheets that are easy to read and interpret, and that allow the important information to stand out. 

Preview 00:36

Learn how to add a level of visual appeal, which can facilitate a greater level of engagement when you present your data to others. (Fonts, The Font Group, Live Preview, The Format Cells Dialog Box, The Colors Dialog Box, Hyperlinks, The Format Painter) 

Apply Text Formats
06:06

By applying number formatting to your worksheet cells, you can control the display of items such as currency figures, dates and times, fractions, decimal places, and negative numbers. 

Apply Number Formats - Introduction
00:57

By understanding how the different number formats work, and by knowing how and when to apply them, you'll have the flexibility needed to work with and analyze all of your numeric data. (Number Formats, Number Format Categories, Custom Number Formats) 

Apply Number Formats
03:15

Excel 2016 provides you with the ability to control where your content appears horizontally and vertically within your worksheet cells. 

Align Cell Contents - Introduction
00:27

Familiarizing yourself with the text alignment options available in Excel 2016 will allow you keeping your organizational data orderly, readable, and functional. (Alignment Options, The Indent Commands, The Wrap Text Command, Orientation Options, The Merge & Center Options) 

Align Cell Contents
03:32

Learn how to apply a variety of formatting options to your worksheet cells, will not only save you time and effort, but can also help you consistently present data to your audiences in ways that are clear and instantly recognizable. (Cell Styles, Galleries, The Merge Styles Dialog Box, Themes, Custom Themes Considerations, Guidelines for Using Themes) 

Apply Cell Styles and Themes
05:59

Excel provides you with a number of options for quickly applying a variety of formatting options to your worksheet cells. This will help you consistently present data to your audiences in ways that are clear and instantly recognizable. 

Preview 00:23

An Excel template is a file that contains a number of preconfigured or pre-entered workbook elements, such as formatting, formulas, themes, and functions, that you can use to create and work with new workbooks. 

Create and Use Templates - Introduction
00:31

Using conditional formatting, Excel displays data that meets specified criteria with the specified formatting applied.

Preview 00:50

Conditional Formatting can transform enormous sets of seemingly random bits of data into useful organizational intelligence that you can use to make sound decisions. (Conditional Formatting, The Highlight Cells Rules, The Top/Bottom Rules, Data Bars) 

Preview 03:38

Excel enables you to leverage your existing workbooks to create similar new workbooks. By taking advantage of this functionality, you can save a lot of effort, and research that went into creating your workbooks for future use. (Templates, Templates and the Backstage View) 

Create and Use Templates
04:22

Answer these questions to test your understanding of what was learned in this lesson.

Quiz Chapter 4
5 questions
+
Printing Workbooks
6 Lectures 10:33

Although most information these days exists digitally, you will likely still, on occasion, require hard copies of a document. But spreadsheets are not the same as most other documents. 

Preview 00:30

Learn to use the variety of printing options that can save your document recipients from having to sift through mounds of irrelevant data. (The Print Tab, The Print Settings, Page Orientation, Margins, Print Preview) 

Configure and Preview a Print Job
03:02

Excel 2016 has many options for printing. Knowing what configurations are available and how to set them will allow you to create more visually helpful and appealing printouts. 

Set Up the Page Layout - Introduction
00:21

Learn what configurations are available and how to set them will allow you to create more visually helpful and appealing printouts. (The Page Setup Dialog Box, The Print Area, The Print Titles Command, Page Breaks, The Page Break Preview View) 

Set Up the Page Layout
03:59

Learn hot to add print-only elements quick and easy through the use of headers and footers. 

Configure Headers and Footers - Introduction
00:28

There's plenty of other identifying information you might want to include on all or most of your printed pages—like numbering each individual page, your company's name, the date the workbook was printed, and so on. (Headers and Footers, The Page Layout View, The Header & Footer Tools Contextual Tab, Header and Footer Options) 

Configure Headers and Footers
02:13

Answer these questions to test your understanding of what was learned in this lesson.

Quiz Chapter 5
2 questions
+
Managing Workbooks
7 Lectures 16:02

Learn how to manage the overall structure of your workbooks. 

Preview 00:17

Workbooks with just a few worksheets are fairly easy to manage without much effort. But what if you're developing a workbook with dozens of worksheets or more? (Tab Formatting Options, Methods of Repositioning Worksheets, Methods of Inserting and Deleting Worksheets, The Hide and Unhide Worksheets Options) 

Manage Worksheets
05:13

Learn how to leverage Excel's different view options, to be able to easily review data from different sources simultaneously. 

Manage Workbook and Worksheet Views - Introduction
00:46

With the View Options you can e.g. copy and paste data to the correct location without risking error, and save yourself time and headaches by avoiding scrolling through endless rows and columns of data. (Custom Views, The Add View Dialog Box, The Split Command, Syncronous Scrolling The Freeze Panes Options) 

Manage Workbook and Worksheet Views
04:35

Workbook Properties can help you search through numerous workbook files to find precisely the one you need. 

Manage Workbook Properties - Introduction
00:27

A workbook property is, quite simply, a bit of information about a workbook file. Learn how workbook properties can help you to manage numerous workbook files. (Workbook Properties, Workbook Properties in the Backstage View, The Properties Dialog Box, Custom Workbook Properties) 

Manage Workbook Properties
03:15

Course Follow-Up
01:29

Answer these questions to test your understanding of what was learned in this lesson.

Quiz Chapter 6
1 question
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.3 Average rating
361 Reviews
6,242 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.