Excel 2016 Beginners

Learn the power of Excel 2016 the easy way. Master Excel to succeed at any workplace and get a deserved promotion.

4.20 (26 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel 2016 Beginners
259
students
3 hours
content
Feb 2016
last update
$19.99
regular price

What you will learn

An understanding of the Excel user interface, including changes to Excel since 2007

Efficiency tips on moving around worksheets and selecting large ranges

Efficiency tips on copying, cutting, and selecting formulas and ranges

How to manipulate rows, columns, and worksheets

How to take control of printing worksheets

How to format efficiently and effectively

How to work effectively with formulas, including auditing for correctness

How to create and modify charts effectively

How to use common but powerful Excel functions, including IF and VLOOKUP

Description

This introductory course covers the fundamentals of Microsoft Excel 2016. It assumes you have used Excel, at least at an elementary level, such as opening and saving an Excel file. This course will drastically increase your productivity and broaden your Excel skills.

The course begins with the Excel user interface: the tabs and ribbons, the backstage view, and the Quick Access Toolbar. It then teaches you methods for performing common Excel tasks, such as moving around large worksheets, selecting ranges, copying and pasting, working with formulas, creating and modifying charts, and printing. It also teaches you best spreadsheet practices for making your spreadsheets attractive and understandable by others. Throughout, the focus is not just on performing common tasks in Excel, but performing them efficiently.

***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****

***** CLEAR AND CRISP VIDEO RESOLUTION *****

***** COURSE UPDATED: February 2016 *****

“As an Accountant, learning the Microsoft Office Suite really helps me out. All of the accounting firms out there, whether Big 4 or mid-market, want their employees to be well-versed in Excel. By taking these courses, I become a stronger candidate for hire for these companies." - Robert, ACCOUNTANT

There are two questions you need to ask yourself before learning Excel. 1. Why should you learn Excel in the first place? 2. What is the best way to learn?

The answer for the first question is simple. Over 90% of businesses today and 100% of colleges use Excel. If you do not know Excel you will be at a distinct disadvantage. Whether you're a teacher, student, small business owner, scientist, homemaker, or big data analyst you will need to know Excel to meet the bare minimum requirements of being a knowledge worker in today's economy. But you should also learn Excel because it will simplify your work and personal life and save you tons of time which you can use towards other activities. After you learn the ropes, Excel actually is a fun application to use.

The answer to the second question is you learn by doing. Simple as that. Learn only that which you need to know to very quickly get up the learning curve and performing at work or school. Our course is designed to help you do just that. There is no fluff content and the course is packed with bite-sized videos and downloadable course files (Excel workbooks) in which you'll follow along with the instructor (learn by doing).

If you want to learn Excel quickly, land that job, do well in school, further your professional development, save tons of hours every year, and learn Excel in the quickest and simplest manner then this course is for you!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions.

We are so confident that you will get tremendous value from this course. Take it for the full 30 days and see how your work life changes for the better. If you're not 100% satisfied, we will gladly refund the full purchase amount!

Take action now to take yourself to the next level of professional development. Click on the TAKE THIS COURSE button, located on the top right corner of the page, NOW…every moment you delay you are delaying that next step up in your career…

Content

Introduction to Course

Welcome to Fundamentals Course
How to download Exercise Files and Handouts
REMINDER: Turn on HD
Intro to Optima Train Tutorial

Excel User Interface

Intro to Excel User Interface
Tabs and Ribbons
Customizing Ribbons
File Menu
Quick Access Toolbar
Opening Recent Files
Excel Options
File Extensions
Single Document Interface

Evolution of Excel

Changes in Excel

Excel Basics

Intro to Excel Basics
Intro to Moving and Selecting
Going Home to Cell A1
Splitting the Screen
Selecting a Range with Keys
Selecting a Range by Pointing
Selecting Multiple Ranges
Go To Options

Copying, Cutting, & Pasting

Intro to Copying, Cutting, Pasting
Copying and Pasting
Office Clipboard

Other Basic Tools

Intro to Other Basic Tools
Undoing Actions
Right-Clicking
Shortcut Keys
Number Formats
Manipulating Rows, Columns
Manipulating Worksheets

Formulas

Working with Formulas
Relative, Absolute Addresses
Calculation Options
Range Names 1

Charts

Intro to Charts
Creating a Chart
Chart Types

Functions

Intro to Functions
Function Help
Intro to Basic Summarizing Functions
SUM, AVERAGE, PRODUCT
COUNT, COUNTA, COUNTBLANK
SUMPRODUCT

Spreadsheet Best Practices

Intro to Spreadsheet Best Practices
Documenting Your Work
Themes
Styles
Conditional Formatting

Conclusion to Course

Conclusion to Fundamentals Course

Reviews

Kent
September 10, 2016
I purchased this course primarily for my wife and I to go through together, since she is an Excel novice. I have been using Excel myself for many, many years, and did not expect to learn much from a basic course. Boy was I wrong! This is packed, and I mean packed, with shortcuts and tips for navigating Excel more effectively and using it more efficiently. I hardly got through a single video segment without saying, "I did not know that...that will be useful almost every time I get into Excel". I would give this a five star rating for content. The reason I withheld the half-star deals with the quality of presentation. It wasn't bad, but the audio volume from segment to segment was inconsistent, and the trainer often kept the mouse cursor over a spot where he was typing so that we couldn't actually see what was going on. Do yourself a favor and take this course, even if you think you're a veteran Excel user.
Ari
May 12, 2016
Liking it so far, although i'm not learning much yet. Still wanted to start from the basics and then advance. I'm pretty sure the lecturer said "Excel 2013" few times, and i even had to double check that it's really 2016 course:)
Mohim
February 23, 2016
I have enjoyed the course very much. Very easy to understand and lots of new things that I have learnt about Excel.

Charts

Price

Excel 2016 Beginners - Price chart

Rating

Excel 2016 Beginners - Ratings chart

Enrollment distribution

Excel 2016 Beginners - Distribution chart

Related Topics

649184
udemy ID
10/23/2015
course created date
3/22/2020
course indexed date
Bot
course submited by