Lean how to use Microsoft Excel from the beginning by creating 6 real-world projects. Most of the content applies to Google Sheets as well.
You will learn how to
– enter data,
– navigate through a spreadsheet,
– create formulas to solve problems,
– create charts and graphs,
– understand relative vs absolute references,
– import and export data,
– implement VLOOKUP,
– use pivot tables,
– split and concatenate text,
– and more.
?? Course developed by Shad Sluiter. Check out his YouTube channel: https://www.youtube.com/user/shadsluiter
?? Course Contents ??
?? (0:00:00) Intro
?? (0:04:14) Payroll
?? (0:39:35) Gradebook
?? (0:57:22) Decision Factors
?? (1:04:40) Sales Database
?? (1:23:13) Car Inventory
?? (1:59:29) Problem Solving Templates
?? Special thanks to our Champion supporters! ??
? Loc Do
? Joseph C
? DeezMaster
—
Learn to code for free and get a developer job: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news
And subscribe for new videos on technology every day: https://youtube.com/subscription_center?add_user=freecodecamp
