Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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
What you will get from this course?
With this Excel for Beginners Course You’ll
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting to Know Me and My Course|
|Section 2: Getting to Know Excel|
I am starting with the very basics of how to open, close and most importantly saving.
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
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.
|Quiz 1||4 questions|
Quiz on Section 2
|Section 3: Working with Data|
In this lesson, you will see how to enter data in cells and how to edit that data.
There will be times you need to add rows and columns and this lesson will show you how to do that.
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.
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.
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 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)
Filtering is a great way to look at a portion of your data set.
Another great way to look at your data is to sort it. In this lesson, I discuss how to sort data by multiple criteria.
This is all about how to print and print options
Practice Excercise Section 3: Show Me What You've Learned
Video Solution to Practice Excercise 3
|Section 4: Really Working With Data|
This lesson will show you how to write basic formulas in Excel.
This lesson will discuss Excel Functions which are predefined Excel formulas. Functions are a quick and easy way to do calculations.
An important aspect of Excel and doing formulas in Excel is understanding cell references and absolute references.
Copying Formulas and a Very Special Paste
Who Wants to Learn a Shortcut...or Two?
Practice: Show Me What You've Learned
Video Solution to Practice Excercise 4
|Section 5: Budget Time!|
This is Your BudgetPreview
Let's Get Started Creating Your Budget
What's a Budget Without Income
Gotta Pay My Bills and Put in Expenses
The Easiest Way to do Formulas for Your Budget - The Excel Way
Goals - You Need Them
Graphing - It's Fun
Formatting, Some More Formatting, After that...More Formatting
|Section 6: Conclusion|
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!