Excel for Beginners: Learn Excel, Create a Budget, Have Fun!
4.2 (52 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.
569 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel for Beginners: Learn Excel, Create a Budget, Have Fun! to your Wishlist.

Add to Wishlist

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.2 (52 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.
569 students enrolled
Created by Damion Valencia
Last updated 6/2016
English
Current price: $10 Original price: $35 Discount: 71% off
2 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
01:40:14
+
Getting to Know Me and My Course
1 Lecture 02:54
+
Getting to Know Excel
3 Lectures 09:35

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

Preview 03:53

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

Preview 03:08

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.

Preview 02:34

Quiz on Section 2

Show Me What You've Learned
4 questions
+
Working with Data
11 Lectures 34:26

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

Preview 02:38

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

Adding Columns and Rows and then Deleting Columns and Rows
03:22

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.

Adding Life to your Project by Formatting
05:18

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.

Undo Can be Your Best Friend
02:34

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

Copy, Cut, and Paste - Scissors and Glue Not Required
02:05

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)

Autofill, It Shouldn't Be This Easy
02:53

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

Everyone Has a Filter, Most Forget to Use it - Don't Forget the Excel Filter
03:07

Another great way to look at your data is to sort it. In this lesson, I discuss how to sort data by multiple criteria.

Sort Your Life Out With Excel
03:18

This is all about how to print and print options

Show Your Kids Up, Print Your Work and Hang it on the Fridge
02:17

Practice Excercise Section 3: Show Me What You've Learned
1 page

Video Solution to Practice Excercise 3
06:54
+
Really Working With Data
7 Lectures 22:08

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

No One Can Do Math in Their Head Anymore, That's Why Excel Created Formulas
03:54

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

Functions are Just Easier Formulas
04:03

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

Cell References - Important Stuff!
03:52

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
+
Budget Time!
8 Lectures 28:04

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
+
Conclusion
1 Lecture 01:07
Conclusion
01:07
About the Instructor
Damion Valencia
4.2 Average rating
52 Reviews
569 Students
1 Course
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!