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.
Learn the basic, intermediate, and advanced knowledge needed to make great spreadsheets in the program Microsoft Excel.
Build a strong foundation in Excel and amazing spreadsheet programming with this tutorial for intermediate and beginner people.
A Powerful Skill at Your Fingertips
Learning Excel will make your life much more easier. With Excel, you'll be able to create spreadsheets to make your life earier.
You can sell your spreadsheets on Ebay or Etsy to make money, as I do right now. Also, Excel knowledge will help you in your life.
Content and Overview
Suitable for mainly intermediate and beginner people, through this course of 34 lectures and 2 hours of content, you'll learn all of the Excel fundamentals and core knowledge, make spreadsheets, and establish a strong understanding of the concept behind making perfect spreadsheets, in only 2 hours of your time!
Starting with the basics such as saving, formatting, and all that, your knowledge builds as you program different stuff. Each new concept builds on the last one.
With these basics mastered, this course will take you through complex functions by teaching you how to use the IF, VLOOKUP, INDEX, and MATCH functions to add complexity and functionality to your programs.
Students completing the course will have the knowledge to create functional and useful Excel spreadsheets.
You'll be able to work alongside me as you work through each concept, so you won't get confused.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Fundamentals|
|Learn all about me.|
|Introduction. Learn what we'll learn in this course.|
|Learn what Excel is and what it does, as well as some history of the program.
|Learn how to move around in Excel.|
Learn the basic skills to use Excel: Undoing, Redoing, Saving, Adding Sheets
Learn how to merge cells.
Learn what the ribbon is and some of the features it contains.
|Learn what the quick access toolbar is, how it helps you, and how to customize it.|
Learn the differences of Workbook and Worksheet.
|Learn how to edit rows and columns in Excel and the differences they have.|
|Learn how to format cells so they show the format you want.|
|Learn how to protect workbooks/worksheets so only people with the password can access them.|
Learn the syntax for each of these functions and what each one does.
|Section 2: Intermediate Stuff|
|Learn how to sort data in Excel.|
Learn how to freeze rows and columns so that you can scroll down in 1 section and leave 1 section unscrolled.
Learn how to use these functions to sum only certain cells in a range.
Learn how to use these functions to count certain cells in a range.
Learn how to use this function to hide errors.
Learn how to use one of the mos widely used functions on Excel, the IF function.
Learn how to use the CONCATENATE function to join different cells.
|Learn how charts work and how to make them in Excel.|
Learn how to use conditional formatting so that cells format themselves based on a function.
Learn how to name ranges so you can refer to certain cells easier.
|Section 3: Advanced Stuff|
|Learn what Macros are and about the developer tab.|
|Learn how to use these functions to perform data lookups.|
Learn how to use the INDEX and MATCH functions as a substitute for VLOOKUP and when to use them.
Learn the value testing functions: ISNUMBER, ISODD, ISEVEN, ISBLANK, ISFORMULA functions
|Learn what , when ,and how to create nested IF functions in Excel.|
|Learn how to use Data Validation to restrict cell entries.|
|Section 4: Example Spreadsheets|
|Create a spreadsheet that adds up and averages school grades.|
Create a spreadsheet that creates a pie chart with data entered randomly.
|Create a spreadsheet, that automatically updates based on current date (eg. If it's 6/7/15, 4 cells on the spreadsheet will say .Mar-2015, Apr-2015,May-2015,Jun-2015. If it's 7/8/15, the dates will shift left.)|
|Create a spreadsheet that takes in a purchase and selling price, and with the push of a button, determines the selling price to make a $0 profit.|
|Section 5: Conclusion|
In case you wanted to leave a review for this course, this lecture will show you how.
I am a 13 year old residing in Colorado, United States. In my free time, I love to make spreadsheets. I'd like to share my knowledge with the world, as well as raise money for my college funds. I also find it fun and relaxing. That is why I teach on Udemy.