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
source
