Excel for the Absolute Beginner

Name: Excel for the Absolute Beginner
Rating: 4.4 (247 reviews)

Start knowing nothing about Excel and learn everything you need to become a productive Excel user by enrolling now

Created byThink Forward Online Training

Last updated 1/2016

English

What you'll learn

Use Excel 2013 with Confidence
Impress Employees and Coworkers with Excel Skills
Increase Your Marketability in the Increasingly Competitive Job Market

Course content

6 sections • 27 lectures • 1h 0m total length

Introduction2:16

Creating New Files and Exploring Templates1:16
After this lecture you will be able to create a new Excel Workbook and explore premade templetes.
Using the Menu System1:41
After this lecture you will be able to navigate the menu systems(Ribbon) in Excel.
Using the Quick Access Toolbar1:17
After this lecture you will be able to use and customize your quick access toolbar.
The Structure of a Worksheet and Workbook1:10
After this lecture you will understand how a spreadsheet works. You will learn the purpose of a column and row, as well as what a cell is.
Using the Formula Bar1:16
You will learn what the formula bar is used for and how to utilize it effectivley.
Context Menu and the MiniToolbar1:38
You will be able to use the shortcut/context menu and the Mini Toolbar to greatly improve your productivity in Excel.

Entering and Editing Data2:21
You will learn how to enter data in Excel as well as the different methods of editing data that is already entered.
Entering Data with AutoFill2:37
You will learn how to enter mass amounts of data in seconds!
Working with Dates and Times4:00
You will learn how datas and times are represented and formatted in Excel.
Using Undo and Redo2:55
You will learn how to fix minor and major mistakes with a click of a button.
Adding Comments1:49
You will learn the often ignored commenting feature in Excel.
Using Save and Save As1:36
You will learn to save your workbook for the first time, and save your workbook in a different location with a different name.

Creating Your First Formulas: Totals and Averages1:51
After this lecture you will be able to create your own formulas.
Copying a Formula to Another Cell1:19
Learn how to save time by copying formulas that you have already written.
Relative and Absolute References3:22
Learn about the different types of references that you can use when copying formulas in Excel.
Using the SUM and AVERAGE Functions2:37
You will begin using your first Excel functions. In this lecture we will cover using the SUM and AVERAGE fucntions.
Using other Common Functions3:35
You will learn to use even more function!

Font Styles and Effects2:07
Learn to make your Excel workbook look professional with font styles and effects.
Adjusting Row Heights and Column Widths1:57
Learn to make your data fit perfectly in your worksheet by adjusting row heights and column widths.
Using Alignment and Wrap Text2:42
Learn to make your data look even better with alignment and wrap text.
Designing Borders1:56
Learn to make important data stand out by using borders.
Using Numeric, Special, and Date Formatting4:06
Learn how to make your data look how you want it to look. In this lecture we explore the variety of formatting options for numeric data.
Using Conditional Formatting1:56
If this .... then that! Learn how to use conditional formatting. Want to highlight a cell only if it is greater than a certain number? Watch this lecture!
Creating and Using Tables4:58
Get a peek at some of the intermediate functions of Excel. In this lecture we will learn to create a table and use many of its useful features.

How to Leave a Review0:52
Please take the time to leave your thoughts about the course in the form of a review. I like bad reviews just as much as good review because I like the feedback. This video will show you how to leave a review.
How to Get a Refund if you Were Not Satisfied1:07
If you were not satisfied with this course, I encourage you to request a refund from Udemy after leaving a review with your feedback. This video will show you how to request a refund.

Requirements

How to use a computer
Install Excel 2013

Description

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

What students are saying:

"Awesome course, really simple and easy to follow thanks for an amazing course." - Melvar Miranda

"These guys definitely know what they are talking about. Very knowledgeable and they offer a lot of helpful lectures that make excel easier and more easier!" - Cryed Talle

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Update: More than 1000 students enrolled in the first week!

Study after study concludes that Excel skills are the hot commodity in today's job market. The fact is that you need Excel to survive in the workplace. This course will give you the skills that you need to use and discuss Excel confidently with your coworkers and bosses. The best part is that it only takes 1 hour, and you keep the skills for a lifetime. I have cut out all the fluff so you can quickly learn Excel and move on with your busy life!

In this course you will learn:

The Excel interface.
Quick tricks to improve your Excel productivity 5x or more.
To create formulas and use functions
To make your Excel workbook look professional and presentable.
Much more - I will be updating this course regularly for the next year with free content!

In addition to the video courses and exercise files, you will have access to me! Come visit me during my office hours on Tuesdays & Thursdays from 10am - 12pm EST. This will give you a chance to ask any questions that you may have, or just stop by to say hello! All you have to do is go to the discussion section of the course and post whatever you'd like me to see.

Who this course is for:

This course is meant for complete beginners who have never used Microsoft Excel. You don't even have to have experience with any Microsoft Office product, we start from the very beginning.
You should not take this course if you are already familiar with Excel, and want to learn more advanced topics. Check the curriculum before enrolling.

Excel for the Absolute Beginner

What you'll learn

Explore related topics

Course content

Getting Started1 lecture • 2min

The Excel Interface6 lectures • 8min

Entering Data6 lectures • 15min

Functions and Formulas5 lectures • 13min

Formatting Techniques7 lectures • 20min

Was this course worth your money?2 lectures • 2min

Requirements

Description

Who this course is for: