Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel for Beginners: Learn Excel, Create a Budget, Have Fun!

Name: Excel for Beginners: Learn Excel, Create a Budget, Have Fun!
Rating: 4.5 (106 reviews)

Have fun learning 2010, 2013 Excel & 2016 Excel starting with the basics; Also learn how to create a budget in Excel!

Created byDamion Valencia

Last updated 6/2016

English

What you'll learn

Learn how to add, edit, and manipulate data to create powerful projects
Take control of your finances by building your own fantastic professional looking personal budget after following my step by step instructions
Enhance your skills and take your job to the next level by learning Excel

Course content

6 sections • 31 lectures • 1h 38m total length

Introduction2:54

The Essentials: Opening, Closing, and Most Important - Saving3:53
I am starting with the very basics of how to open, close and most importantly saving.
Worksheets, Columns, and Rows, Oh My!3:08
In this lesson, I will go over what you are looking at when you first enter Excel. I will be discussing worksheets, columns, rows, and cells
Command the Ribbon2:34
The command ribbon is where you will find your commands to help you do calculations, insert tables, formatting, sort, etc. This is just a brief overview of where you will find these commands.
Show Me What You've Learned

Entering Data for the First Time2:38
In this lesson, you will see how to enter data in cells and how to edit that data.
Adding Columns and Rows and then Deleting Columns and Rows3:22
There will be times you need to add rows and columns and this lesson will show you how to do that.
Adding Life to your Project by Formatting5:18
This lesson will go over a lot of the formatting tools you can use to make your projects or reports stand out. This will help turn a plain looking project into something engaging for the user.
Undo Can be Your Best Friend2:34
Everyone makes mistakes, but in Excel, those mistakes don't have to be permanent. I will be discussing how to undo mistakes your mistakes and also redo if you didn't really make a mistake.
Copy, Cut, and Paste - Scissors and Glue Not Required2:05
Another essential function is copy and paste. Often times you will use the same material in your spreadsheet or you may want to move some material. This lesson covers the basics of copying and pasting
Autofill, It Shouldn't Be This Easy2:53
Autofill is a quick and easy way to copy information from one cell to another. It's also a quick way to complete a series (i.e. 1,2,3...10, or January, February....December)
Everyone Has a Filter, Most Forget to Use it - Don't Forget the Excel Filter3:07
Filtering is a great way to look at a portion of your data set.
Sort Your Life Out With Excel3:18
Another great way to look at your data is to sort it. In this lesson, I discuss how to sort data by multiple criteria.
Show Your Kids Up, Print Your Work and Hang it on the Fridge2:17
This is all about how to print and print options
Practice Excercise Section 3: Show Me What You've Learned1:00
Video Solution to Practice Excercise 36:54

No One Can Do Math in Their Head Anymore, That's Why Excel Created Formulas3:54
This lesson will show you how to write basic formulas in Excel.
Functions are Just Easier Formulas4:03
This lesson will discuss Excel Functions which are predefined Excel formulas. Functions are a quick and easy way to do calculations.
Cell References - Important Stuff!3:52
An important aspect of Excel and doing formulas in Excel is understanding cell references and absolute references.
Copying Formulas and a Very Special Paste2:39
Who Wants to Learn a Shortcut...or Two?3:38
Practice: Show Me What You've Learned1:00
Video Solution to Practice Excercise 44:02

Requirements

You need to have Excel 2007 or later
You should be ready to learn and have fun

Description

Course updated February 2017

Why not learn a new skill for 2017 and get ahead of those New Year's resolutions!

"You don't know what's going to happen when you try, but if you don't try nothing will happen!"

Master Microsoft Excel easily even as a total beginner with our comprehensive course:

Excel for Beginners: Learn Excel, Create a Budget, Have Fun!

We take the boring out of numbers, in a fun, engaging and interactive course, that takes you step-by-step to becoming a Microsoft Excel pro.

No Previous Knowledge Needed

Complete beginners are welcome, there’s no need to have experience using Excel previously and certainly no requirement of any technical qualification. All you need is Microsoft Excel 2007 and we can get started.

Who Likes Numbers Anyway?

Most of us aren’t good with numbers and that’s exactly why Excel was created. This powerful software will work the figures and charts for you. What we do at Not Your Average Courses is make it as easy as A, B, C to navigate Excel to create financial budgets, overviews, spreadsheets, lists and so much more, in no time.

We’ll be revealing secrets that make it so easy you’ll be shocked you never learnt to use Excel sooner.

What Make This Course Different?

We make learning fun, unlike most online Excel courses that are complicated, time-consuming, confusing and just plain boring. We like to make our Excel for Beginners Course fun, simply because it’s the best way to learn.

We believe in keeping it simple. Over complicated and exhaustive explanations that bury the student in technicalities just cause confusion, distress and the desire to retreat. With our Excel for Beginners Course we break the details down to bite sized piece and keep the information to exactly what you need to know to get the job done.

We encourage and motivate our students. Our students are encouraged to ask as many questions that they like, which can be general or related to specific projects. We’re happy to help you work through practical examples and will ensure you’re motivated and encouraged from start to finish.

Lively and interactive learning is key. This Excel for Beginners Course doesn’t use conventional textbook methods for learning but instead real live examples by assisting you prepare your own financial budget in Excel. This relevant reference point will improve your memory of the formulas and commands used in Microsoft Excel.

What You’ll Learn on this Excel for Beginners Course

How the main components of Microsoft Excel work
Entering, editing, and copying data in Excel
Sorting, filtering, and organizing data
Writing formulas and creating calculations
Shortcuts to make your project easier
Using graphs to represent data in Excel
How to build your own personal budget

What you will get from this course?

With this Excel for Beginners Course You’ll

Learn to create powerful projects
Take control of your finances by creating and editing your personal budget spreadsheet
Enhance your skills for jobs that require a working knowledge of Microsoft Excel

Ideal for complete beginners or those who want to brush up on their skills, our Excel for Beginners Course is an excellent way to master a new skill and your finances all at once.

Who this course is for:

This course is designed for anyone who has the desire to learn Excel and has little or ZERO prior experience
If you want to have fun while learning then this is the course for you
This course is not for advanced Excel users or people who don't want to have fun and are looking for a boring mundane course

Excel for Beginners: Learn Excel, Create a Budget, Have Fun!

What you'll learn

Explore related topics

Course content

Getting to Know Me and My Course1 lecture • 3min

Getting to Know Excel3 lectures • 10min

Working with Data11 lectures • 35min

Really Working With Data7 lectures • 23min

Budget Time!8 lectures • 28min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: