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.
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 the differences of Workbook and Worksheet.
Learn the syntax for each of these functions and what each one does.
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 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.
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
Create a spreadsheet that creates a pie chart with data entered randomly.
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.