Easy Excel Basics for Beginners - Get Started with Excel

Name: Easy Excel Basics for Beginners - Get Started with Excel
Rating: 4.5 (4228 reviews)

Learn Microsoft Excel basics from the beginning. Spreadsheets, shortcuts and formulas. Good for Excel 2010, 2013 & 2016.

Created bySteve McDonald

Last updated 10/2019

English

What you'll learn

Navigate through Excel quickly and easily
Create a simple, effective spreadsheet
Use Excel formulas for automating repetetive math calculations
Format text and arrange it alphabetically
Format numbers into currency
Adjust column and row size quickly and easily
Get your feet wet with the basics of Excel in an easy, stress free way

Course content

4 sections • 14 lectures • 40m total length

Introduction1:33
Welcome to Easy Excel Basics!
This course is a gentle introduction to the wonders of Excel. It's enough to get your feet wet and help you to feel comfortable creating spreadsheets and math formulas in Excel.
Excel is an amazing tool and once you learn to use it, it can drastically increase your efficiency at work or at home.
The Power and Possibilities of Excel Templates3:17
At the end of this lecture you'll be able to pull up a wide variety of useful Excel Templates that are included with Excel. These range from personal or business budgets, time sheets, invoices and much, much more.

Saving Your Excel File Where You Can Find It2:14
At the end of this lecture you'll be able to create a folder on your desktop and save your Excel file to that folder so you can find and use it later.
Entering Data Into Your Worksheet1:34
The basic component of Excel is the cells. At the end of this lecture you'll know how to enter your all important data into those cells. Whether it is a list of business expenses, or kitchen remodeling costs, like in our example you'll know how and where to put those numbers.
Easy Ways You Can Select Cells in Your Worksheet1:24
Being able to select a number of cells or different groups of cells is important for saving time. At the end of this lecture you'll know how to select cells in a variety of ways to speed up your workflow.
How You Can Use Simple Formulas to Add and Multiply4:27
The magic of Excel is the ability to use formulas to do calculations on your numbers. At the end of this lecture you'll know how to add a multiplication formula and a sum formula to a list of numbers to produce totals in your spreadsheets.
Creating a Document from Scratch Quiz

Adding and Formatting a Heading2:50
You don't have to just use the cells exactly how you see them. At the end of this lecture you'll know how to rearrange cells by merging them so you can add a heading to your spreadsheet.
Entering and Alphabetizing Words In Your Worksheet2:54
The benefit of Excel is the ability to keep your information organized. At the end of this lecture you'll be able to enter a list of kitchen remodeling costs and format and sort them alphabetically.
Entering and Formatting Numbers In Your Worksheet2:22
At the end of this lecture you'll be able to enter and format the numbers for your kitchen remodel costs.
Using Formulas to Multiply and Add Your Data4:57
This is where the Excel Magic begins. At the end of this lecture you'll be able to create and use simple formulas for addition and multiplication to create totals automatically from the numbers you have entered into your spreadsheet.
Final Formatting - Add Borders and Color2:23
Presentation is important if you are sharing your work with others. At the end of this lecture you'll know how to quickly and easily add borders and color to your spreadsheet to make your spreadsheet clean looking and easy to read.
Printing Your Work6:51
In this lecture I'll show you how to print your work. I'll also show you how to adjust your page layout, page orientation, margins, centering and more so you can make your printed work appear just how you would
like it.
Creating a Kitchen Remodel Cost Worksheet

Thank You2:17
Thank you for taking this course and following it through to the end. That is the kind of commitment and determination that defines successful people. Now that you have a basic understanding of how you can use Excel, dive into some of those pre-formatted templates and start manipulating them to suit your needs best. Experiment with formulas, ask questions in the discussions, and keep learning. Good luck!
Learn More - Other Courses by Steve McDonald (bonus lecture)1:00
Check out my complete Excel Mastery Course for Beginners. Get huge discounts with the included coupon link.

Requirements

You just need to have a working copy of Microsoft Excel 2010 or later and the willingness to learn about the magic of Excel

Description

Learn the basics of Excel quickly and easily.

This course is for you if you know that you need to get started learning Excel, but have just been too busy or felt too overwhelmed by the idea of studying.

This course will show you the basics of how to use Excel, how to create a basic spreadsheet, how to navigate quickly through a spreadsheet, how to create simple mathematical formulas and some shortcuts and keystrokes to save you lots of time.

You can go through this course in about 30 minutes. At the end you'll know how to create a sample spreadsheet that can calculate estimated kitchen remodeling costs automatically.

If you're ready to get your feet wet quickly and painlessly, take this easy introduction to Excel course and you'll see that using Excel can be easier than you think.

Who this course is for:

Any beginner who is new to Excel or has tried to learn Excel in the past and found it to be difficult
This course is NOT for intermediate or advanced users who already feel comfortable with the basics

Easy Excel Basics for Beginners - Get Started with Excel

What you'll learn

Explore related topics

Course content

Welcome to Excel Basics2 lectures • 5min

Excel Basics - Creating a Document From Scratch4 lectures • 10min

Excel Spreadsheet Tutorial - Create Kitchen Remodel Costs Worksheet6 lectures • 22min

Conclusion - Thank You and Bonus2 lectures • 3min

Requirements

Description

Who this course is for: