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.
*** Lifetime access and a 30 day, 100% money back guarantee ***
Welcome to the Ultimate Microsoft Excel Course, which has over 190 short and precise tutorials. This course was created by a hand-pick of Udemy's best Excel instructors, so you are sure to benefit from their unique Excel skills.
The course covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features and keyboard shortcuts!
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in Microsoft Excel.
The course is designed for Excel 2007, 2010, 2013 or 2016. There are 23 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.
In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to work with various time saving Formulas, create automated reports with the press of a button, WOW your boss with stunning Excel Charts and get noticed by top management & prospective employers.
The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!
In this course there are FREE downloadable Excel workbooks for each tutorial and a BONUS video section as well as each instructor's favorite Excel shortcuts.
We have collectively been helping over 45,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way.
These tutorials will give you career-building skills that you can use to become better and more efficient at your job.
If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc....then this course is for YOU!
You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and we will answer them personally within the day!
We are so confident that you will get lots of value from this course that you can take it for the full 30 days, download all the workbooks, watch all the videos and apply it to your work to see the results. If you're not 100% satisfied, we will be more than happy to refund the full purchase amount!
So go ahead and learn from the following in depth Excel subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Overview|
|Section 2: Excel Basics|
This lecture introduces you to what you're going to learn in the first few sections of the course.
This lecture is a complete tour of the various Excel dashboards and
interfaces. It will show you how to use the tabs and ribbons at the top
of an Excel workbook, how to navigate the file menu to save, print and
customize documents in Excel. And it gives you a tour of the many
features and tools available to you in Excel 2016.
Using Excel Templates to Save Time and Effort
The first step to successfully creating your first spreadsheet is opening and saving a document. This lecture will show you how to do that and how to save it to a place where you can find it later.
|Quickly learn how to enter data into cells in your worksheet and move from cell to cell.|
Learn how to create simple but powerful addition and multiplication formulas. These will prepare you to do the calculations neccessary for the Kitchen Remodeling Cost worksheet later in the course.
|In this lecture I'll show you the difference between a workbook and a worksheet. I'll also teach you various ways of moving, copying, renaming and managing your worksheets within, and between different workbooks.|
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.
Activity. Now it's time to put what you have learned into practice.
|Quiz 1||3 questions|
Review what you've learned about the basics of Excel.
|Section 3: Create Your First Excel Spreadsheet From Scratch|
First, in this lecture I'll give you a quick tour of the finished product of the Kitchen Remodel Costs Worksheet. Then I'll show you how to create and format your heading.
Note: You can download the finished worksheet here so you can practice creating and changing the formatting and formulas used in this section.
|In this lecture, first, you'll learn how to add subheadings to your columns and format them. Then you'll learn how to enter your list of materials into your first column and sort the list alphabetically.|
|Now it's time to enter your quantities and costs and format them to look like numbers and dollar amounts.|
In this lecture I'll show you how to use the multiplication and addition formulas that we learned earlier to calculate your total costs for each of your materials, as well as a grand total for the entire remodeling project.
In this lecture I'll show you how to do some final formatting to your worksheet. I'll show you how to add a few more colors and add grid lines to your worksheet to define your data a little bit more.
|Quiz 2||3 questions|
Let's review what you've learned.
|Section 4: Charts - How to Create Bar, Column and Pie Charts|
|Charts take boring data and turn it into a visual story. In this lecture I'll show you some of the possibilities of what you can do with charts and then we'll dive right into creating a chart from our Kitchen Remodel Costs worksheet.|
Now that you've created a chart, let's do some formatting to make it look awesome!
In this lecture I'll show you how to resize your chart, change
the color and width of your columns, add and delete different elements
from your chart and how to change the title. At the end of this lecture
you'll be able to create a beautiful, professional looking chart from
Use this download to compare what is happening in the lectures with the real thing in Excel.
A bar chart in Excel is basically a column chart turned on it's side. The benefit of a bar chart is that it adds emphasis to differences in values because the bars stretch farther across the page.
In this lecture we'll create a bar chart and we'll do some additional formatting to it to make the data really stand out.
Pie charts are great for showing percentages and how each individual part relates to the whole. In this lecture I'll show you how to create a pie chart in Excel from scratch. I'll also show you how you can easily convert an existing chart, such as the bar chart we created in the previous lecture, into a pie chart to save on formatting.
|Line charts are best used to represent the change in a value over time. A good example of this is monthly sales numbers for a whole year. In this lecture I'll first show you how to quickly change our existing bar chart into a line chart. Then I'll show you how to use a new spreadsheet containing dates and sales numbers so you can see the best use of a line chart in Excel.|
|Quiz 3||3 questions|
Let's review what you've learned about charts.
|Section 5: Introduction to Excel Formulas and Functions|
|This lecture defines a formula and shows you how a formula can help you do calculations in Excel.|
|A function is a piece of predefined code that you can use as part of your formula to increase the power of your calculations. This lecture shows you the power that a function has over simple formulas. It also shows you where to find functions and how to use them.|
In this lecture I break down a basic formula into 6 main parts and show you how each part behaves as part of a formula.
The anatomy of an Excel formula is all of the numbers, words and symbols that make up a formula. These are all very important to understand because it enables you to create, modify or correct formulas to do the big calculations for you, saving you lots of time and effort.
This lecture will answer these questions:
|This lecture will show you some strategies and shortcuts to quickly and easily select cells for use in your formulas.|
Most formulas that you create in Excel reference relative cells by default. However, by creating absolute cell
references you can incorporate a fixed cell into your equation while
still being able to copy the formula to other cells. This lecture
will show you the difference between absolute and relative cell
references, and it will show you
useful ways to use them in formulas.
|Quiz 4||3 questions|
Let's review what you've learned about formulas and functions.
|Section 6: Top 50 Excel Formulas|
A quick introduction on the Excel Formulas and Vlookup topics with your instructor Bryan Hong.
Download this Exercise File
Quick Tips on how to master these formulas with no need to memorize them.
|Section 7: Text Formulas|
TEXT: Concatenate FormulaPreview
TEXT: Find FormulaPreview
TEXT: Left Formula
TEXT: Len Formula
TEXT: Lower Formula
TEXT: Mid Formula
TEXT: Proper Formula
TEXT: Rept Formula
TEXT: Substitute Formula
TEXT: Trim Formula
TEXT: Upper Formula
TEXT: Value Formula
|Section 8: Mathematical Formulas|
MATHEMATICAL: Average FormulaPreview
MATHEMATICAL: Int FormulaPreview
MATHEMATICAL: Mod Formula
MATHEMATICAL: Rand Formula
MATHEMATICAL: Round Formula
MATHEMATICAL: Sum Formula
|Section 9: Date and Time Formulas|
DATE AND TIME: Day FormulaPreview
DATE AND TIME: Hour FormulaPreview
DATE AND TIME: Minute Formula
DATE AND TIME: Month Formula
DATE AND TIME: Networkdays Formula
DATE AND TIME: Now Formula
DATE AND TIME: Second Formula
DATE AND TIME: Today Formula
DATE AND TIME: Weekday Formula
DATE AND TIME: Year Formula
|Section 10: Logic Formulas|
LOGIC: And FormulaPreview
LOGIC: Countblank FormulaPreview
LOGIC: Countif Formula
LOGIC: If Formula
LOGIC: Large Formula
LOGIC: Max Formula
LOGIC: Min Formula
LOGIC: Not Formula
LOGIC: Or Formula
LOGIC: Small Formula
LOGIC: Sumif Formula
LOGIC: Vlookup Formula
|Section 11: Financial Formulas|
FINANCIAL: Fv FormulaPreview
FINANCIAL: Npv Formula
FINANCIAL: Pmt Formula
FINANCIAL: Ppmt Formula
|Section 12: Informational Formulas|
INFORMATIONAL: Column FormulaPreview
INFORMATIONAL: Isblank FormulaPreview
INFORMATIONAL: Iserror Formula
INFORMATIONAL: Isnumber Formula
INFORMATIONAL: Istext Formula
INFORMATIONAL: Row Formula
Excel Formula Review
|Section 13: VLOOKUP Deep Dive|
Download this Exercise File
We will learn how to search across a Starbucks menu using vlookup
Two lists can be easily compared using vlookup to find out the differences between them.
Learning is easier if you are given the right tools and instruction. In every one of my courses I take my students step-by-step through the tools and knowledge they need to accomplish their goals.
Whether I am teaching How to Publishing Kindle eBooks, How to Learn Excel, or How to Create Killer Content for the Web I always share an inside view of my knowledge about the subject. You get access to all of my secrets.
For over 10 years I have studied strategies to create passive income and how to use passive income to vastly improve the quality of your life.
I have tested many different strategies from investing in rental real estate to building niche websites about my hobbies to publishing Kindle eBooks. I have studied what works and what doesn't work, and I have narrowed my research down to the strategies that work the best for creating financial freedom and an improved quality of life.
Each of my courses is designed to share my hard-earned secrets with you.
I hold nothing back. I won't bore you with all of the strategies that didn't work. I'll get right into the exact steps that I have taken to be successful so that you have the opportunity to replicate them.
Of course, it's no secret that one of my favorite ways to generate truly passive income is through publishing Kindle eBooks. I have published over 100 eBooks and published five of those in print. Many of my books have been bestsellers including my own pottery book The Despicable Five.
Once I developed my Kindle publishing system, learned some formatting secrets, and learned how to use some simple SEO skills, publishing eBooks became remarkably simple.
Even hiring writers, which would seem scary at first, is really easy and even fun when you follow my system.
Using my system, you can publish one or two books and then roll the profits from them into hiring people to write more books for you, so you aren't taking any money out of your pocket.
It starts out as a little passive income snowball and as you add the profits back into the snowball it grows and grows until you are seeing a surprising and exciting amount of passive income.
I retired in 2014 thanks to my eBook publishing success. Now, I'm using my spare time to find the best ways to create passive income. As I find great ways to make money from home I'm more than happy to share what I learn with you.
You'll notice that my new favorite way to create passive income is teaching courses on Udemy. Check out my Udemy Course Creation course to see why I love it so much!
I am here to guide you on your way to success. You can contact me at any step of the way for assistance, even if you're unsure whether my course is the perfect fit for you. Let me know your concerns and I'll point you in the right direction, even if it's to someone else's course.
I'm always happy to help.
Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy for you.
Sign up for a course today! I'll see you in there.
Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;
Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.
Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.
Some of the clients Kyle has provided training for include:
What Students have said about Kyle:
In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.
Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.
In His Spare Time:
Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!
Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.
I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)
My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!
My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!
I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline. I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!
I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.
Join one of my courses and get ready to change your life!