Microsoft Excel 2016 Training for Beginners
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.
1 student enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 Training for Beginners to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 Training for Beginners

Get Familiar with the Excel UI and Learn How to Perform Simple Day to Day Operations and Calculations in Excel 2016.
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.
1 student enrolled
Created by Ms. Adeline Gear
Last updated 6/2016
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?
  • Familiarize yourself with the UI, create and save workbooks, enter data, do basic math, format your worksheet and prepare it for printing.
View Curriculum
Requirements
  • Excel 2016 and Windows 10
Description

Microsoft Excel 2016 Training for Beginners is designed for newbies and anyone wanting to become familiar with the user interface and perform basic day to day operations in a comfortable manner, with confidence.

This course covers the following topics:

  • Introduction to the Excel UI

  • Creating and Navigating a Workbook

  • Entering and Editing Data in a Worksheet

  • Building Simple Formulas

  • Formatting and Aligning Data

  • Managing Workbooks and Worksheets

  • Printing Worksheets

The course materials includes exercises at the end of every lesson that will help you practice what you have learned in the topics and become more confident in performing them later in your workplace or at your home. Solutions are also provided in case you have trouble performing the activities.

If you want to build a good foundation to becoming a power user of Excel, this course will offer you all the skills you need to get started with the software.

Who is the target audience?
  • This Excel training course is for beginners who have little or no experience in using Excel and who wish to become comfortable with the Excel UI, learn how to enter data, write simple formulas, perform simple calculations, and manage worksheets and workbooks and have them reay for printing.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
39 Lectures
01:47:07
+
Introduction to the Excel UI
6 Lectures 09:50

An introduction to the topics that you will be learning in Microsoft Excel 2016 Training for Beginners.

Preview 01:55

Explore the Quick Access Toolbar and learn how to use and customize it to find the commands you frequently use in your day to day work quickly.

Preview 01:29

Explore the Ribbon and learn how to navigate the Ribbon and find all the commands you need to work in Excel.

The Ribbon
02:56

Explore the commands in the Formula bar and learn how you can use it when performing calculations in Excel.

The Formula Bar
00:52

Explore the various options in the worksheet area and learn how to navigate between different parts of a worksheet.

The Worksheet Area
01:21

Explore the various options and commands available in the Status bar so you can see at a glance information inside the worksheet on it.

The Status Bar
01:17
+
Creating and Navigating a Workbook
3 Lectures 08:58

You will learn how to create a workbook from scratch or create one using a template and save it in a location on your computer.

Preview 02:51

You will learn how to navigate within a worksheet and navigate when the workbook has multiple worksheets.

Navigating an Excel Workbook
03:23

You will learn how to add more worksheets to a workbook and delete them when not necessary.

Using Worksheets in a Workbook
02:44
+
Entering and Editing Data in a Worksheet
7 Lectures 19:55

You will understand the rules for data entry and learn to enter different types of data in cells.

Preview 03:44

You will learn how to edit data in cells without losing the information that is already available in the worksheet. 

Editing Data
01:05

You will learn how to use Excel's commands to undo and redo entries you created in your worksheet.

Undo and Redo Entries
01:16

You will learn how to copy and paste data in Excel or move data from one location to another within a worksheet or within worksheets.

Moving Data Around
03:40

You will learn how to copy a range of cells in Excel using the Autofill feature.

Working with Autofill
03:38

You will learn how to insert new rows and columns in Excel and how to hide them when you want to take a print.

Working with Rows and Columns
04:21

You will learn how to find and replace text quickly in a large worksheet using the Find and Replace dialog box.

Finding and Replacing Text Values
02:11
+
Building Simple Formulas
4 Lectures 13:19

You will learn how Excel uses the basic operators in Excel to perform addition, subtraction, multiplication and division functions.

Preview 04:09

You will learn the BODMAS rule and how Excel uses it to make computations.

Order of Operators
01:52

You will learn different ways in which to sum up values in your worksheet.

Working with Sum Functions
03:37

You will earn how to apply the formulas you created to other cells.

Working with Formulas
03:41
+
Formatting and Aligning Data
8 Lectures 26:58

You will learn how to change the font and font sizes; add font colors and background colors; and bold format, italicize and underline text.



Applying Basic Formatting Options
04:42

You will learn how to align data in Excel to give it a uniform and neat appearance.

Aligning Cell Data
01:56

You will apply number formats in Excel to display the data according to your needs.

Working with Number Formats
06:58

You will apply date formats to display dates in a short form, long form or custom format as per your requirements.

Working with Date Formats
02:58

You will add different types of borders to your data to give it a neat appearance when printing.

Adding and Removing Cell Borders
02:02

You will use the Format Painter to copy and paste formatting styles in your worksheet.

Using the Format Painter
02:53

You will find formatting styles in your worksheet quickly and instantly replace them with different styles.

Finding and Replacing Formats
03:36

You will clear multiple formatting styles applied to a worksheet so you can start from afresh.

Clear Formatting
01:53
+
Managing Workbooks and Worksheets
4 Lectures 10:29

You will format worksheets by adding a color to them.

Formatting Worksheets
01:47

You will copy and move worksheets within a workbook and between workbooks.

Copying and Moving Worksheets
02:15

You will arrange workbooks in different styles so you can quickly switch between them when needed.

Arranging Workbooks
03:28

You will group worksheets so you can make changes to all of them simultaneously and ungroup them when required.

Grouping and Ungrouping Worksheets
02:59
+
Printing Worksheets
7 Lectures 17:38

You will set up print titles and print areas for printing select data.

Working with Print Titles and Area
02:43

You can set the margins and orientation before printing a worksheet.

Setting the Margins and Orientation
04:31

You can create headers and footers for printing in a worksheet.

Printing Headers and Footers
04:12

You can set page breaks in a worksheet to optimize the space used in the printing paper.

Making Use of Page Breaks
01:36

You will select different ranges of cells for printing.

Printing a Range of Cells
01:31

You will access all the options available for setting the print conditions or a worksheet or workbook.

Accessing All Print Settings
02:25

A quick look at everything we learned so far in Microsoft Excel 2016 Training for Beginners.

Conclusion
00:40
About the Instructor
Ms. Adeline Gear
0.0 Average rating
0 Reviews
1 Student
1 Course
Blogger at TheAppTimes.com

I’m Adeline Gear, an instructional designer and blogger at TheAppTimes. I’ve spent many years creating Microsoft courses at ElementK and after I moved on I realized that there's no better way to impart education than through visual and activity based training. 

I am glad to be a part of Udemy that offers an excellent opportunity for me to continue to provide such a rich learning experience for students.

I hope you will take up my courses to learn new skills and reach out to me with your questions and feedback.

Looking forward to hearing from you and wishing you all an exciting and engaging learning experience!