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

Have fun learning 2010, 2013 Excel & 2016 Excel starting with the basics; Also learn how to create a budget in Excel!
4.4 (14 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.
505 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 31
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

Course updated November 2015

Why not learn a new skill for 2016 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.

What are the requirements?

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

What am I going to get from this course?

  • 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

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting to Know Me and My Course
Introduction
Preview
02:54
Section 2: Getting to Know Excel
03:53

I am starting with the very basics of how to open, close and most importantly saving.

03: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

02: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.

4 questions

Quiz on Section 2

Section 3: Working with Data
02:38

In this lesson, you will see how to enter data in cells and how to edit that data.

03:22

There will be times you need to add rows and columns and this lesson will show you how to do that.

05: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.

02: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.

02: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

02: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)

03:07

Filtering is a great way to look at a portion of your data set.

03: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.

02:17

This is all about how to print and print options

Practice Excercise Section 3: Show Me What You've Learned
1 page
Video Solution to Practice Excercise 3
06:54
Section 4: Really Working With Data
03:54

This lesson will show you how to write basic formulas in Excel.

04:03

This lesson will discuss Excel Functions which are predefined Excel formulas. Functions are a quick and easy way to do calculations.

03:52

An important aspect of Excel and doing formulas in Excel is understanding cell references and absolute references.

Copying Formulas and a Very Special Paste
02:39
Who Wants to Learn a Shortcut...or Two?
03:38
Practice: Show Me What You've Learned
1 page
Video Solution to Practice Excercise 4
04:02
Section 5: Budget Time!
This is Your Budget
Preview
02:57
Let's Get Started Creating Your Budget
01:36
What's a Budget Without Income
01:00
Gotta Pay My Bills and Put in Expenses
01:10
The Easiest Way to do Formulas for Your Budget - The Excel Way
05:03
Goals - You Need Them
02:11
Graphing - It's Fun
05:01
Formatting, Some More Formatting, After that...More Formatting
09:06
Section 6: Conclusion
Conclusion
01:07

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Damion Valencia, Financial Analyst, Trainer, Entrepreneur

I've always had a passion for numbers and finance from an early age. One of my most vivid memories as a kid is around 3 or 4 is having my own play cash register and playing banker. Most kids wanted to be a fireman, or a police officer. I wanted to be a banker. I didn't become a banker but instead went into Finance and financial analysis.

After graduating from Arizona State University with a degree in Finance, I went on to work in financial analysis. I started at a fortune 500 corporate office in Arizona and went on to work for two other large corporations. I love telling a story through numbers, whether, good, or bad, and giving direction to either get out of the bad, or to move towards even better. I've created hundreds of financial models and reports, performed countless other types of analyses, and have given dozens of presentations. I've advised managers, including executive management, on strategic decisions based on my analysis. All this analysis was done in Excel.

I've been heavily using Excel for over 10 years and I wasn't satisfied just having the basic knowledge of what I needed for my job. I now have advanced knowledge of Excel because I never stopped learning. I still study Excel to learn as many tips and tricks I can. This not only makes me a better analyst and my job easier, but I've learned to create more thorough analyses, and more intuitive financial models. In addition, I learn so I can pass this knowledge on to my colleagues, and now on to you.

I've always been the go to guy within my colleague group to help with Excel questions. That's when it hit me. Although, I love being a financial analyst, I knew something was missing. At the time, I was trying to fill some career void through self-improvement and started taking online classes in every subject and discovered Udemy. That's when I thought to myself that I can do that. I worked my way through college as a trainer for an answering service. I truly loved that job and I felt they really liked me as a trainer. People look forward to my presentations now for the same reason, I'm fun.

I'm a big proponent of learning should be fun. I truly believe that it makes for a better learning environment and the students end up being more successful in that environment. Learning objectives should always come first but there is no reason it can't be fun. Learning should not be a dreaded chore. It should be something you look forward to, enjoy, all while getting the benefit of learning a new subject, skill, or topic. I love laughing and making people laugh. Everything is so much more fun for myself and my students when we can add some humor.

That brings me to my courses and what sets my courses apart. Not only do I have the expert knowledge to teach, but my courses are fun and engaging!

If you are interested in Excel, I'm confident I'm the right person to teach you. I'm also confident that you will crack at least a few smiles throughout my course.

See you soon!

Ready to start learning?
Take This Course