Microsoft Excel Tutorial for Beginners - Full Course

freeCodeCamp.org October 28, 2020
Video Thumbnail
freeCodeCamp.org Logo

freeCodeCamp.org

View Channel

About

Learn math, programming, and computer science for free. A 501(c)(3) tax-exempt charity. We also run a free learning interactive platform at freecodecamp.org

Video Description

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 ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp ⭐️ 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

You May Also Like

Excel Mastery Starter Kit

AI-recommended products based on this video

Loading...
Lenovo IdeaPad 15.6” FHD Touchscreen Laptop, 40GB RAM 2.5TB Storage (2TB SSD+512GB Docking Station Set), 6-Cores Intel Core i3, Windows 11 Pro with Microsoft Office Included, Plusera Earphones

Lenovo IdeaPad 15.6” FHD Touchscreen Laptop, 40GB RAM 2.5TB Storage (2TB SSD+512GB Docking Station Set), 6-Cores Intel Core i3, Windows 11 Pro with Microsoft Office Included, Plusera Earphones

(94)
$599.99
FREE delivery Tue, Jun 17
300+ bought in past month
Loading...
Lenovo 2025 New Touchscreen Laptop • 6-Cores Intel Core i3 • 40GB RAM • 2TB SSD • 15.6 inch FHD (1920 x 1080) Display • Long Battery Life • WOWPC Recovery USB • Windows 11 Pro with Microsoft Office

Lenovo 2025 New Touchscreen Laptop • 6-Cores Intel Core i3 • 40GB RAM • 2TB SSD • 15.6 inch FHD (1920 x 1080) Display • Long Battery Life • WOWPC Recovery USB • Windows 11 Pro with Microsoft Office

(2)
$1,159.99$469.99
FREE delivery Jun 23 - 25
300+ bought in past month
Loading...
acer Nitro V 15 Gaming Laptop, 15.6" 144Hz FHD Display, Intel 10-Core i7-13620H, NVIDIA GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Microsoft Office Lifetime License, Windows 11 Pro

acer Nitro V 15 Gaming Laptop, 15.6" 144Hz FHD Display, Intel 10-Core i7-13620H, NVIDIA GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Microsoft Office Lifetime License, Windows 11 Pro

(827)
$1,659.99
FREE delivery Jun 17 - 20
Loading...
acer Nitro V16 Gaming Laptop, Microsoft Office 2024 Lifetime License, 16" WUXGA 165Hz, AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Win 11 Pro

acer Nitro V16 Gaming Laptop, Microsoft Office 2024 Lifetime License, 16" WUXGA 165Hz, AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Win 11 Pro

(0)
$1,769.99
FREE delivery Jun 17 - 20
Loading...
Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

(4,883)
27.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
200+ bought in past month
Loading...
Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

(132)
$14.99
FREE delivery Jul 2 - 6 on $35 of items shipped by Amazon
2K+ bought in past month
Loading...
UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

(12,070)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
400+ bought in past month
Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
UGREEN Uno 6 in 1 USB-C Hub with 10Gbps USB-C & USB-A Data Ports 4K@60Hz HDMI for MacBook Pro/Air, iPad Pro, Surface, XPS, Thinkpad and More.

UGREEN Uno 6 in 1 USB-C Hub with 10Gbps USB-C & USB-A Data Ports 4K@60Hz HDMI for MacBook Pro/Air, iPad Pro, Surface, XPS, Thinkpad and More.

(1,196)
22.49
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
100+ bought in past month
Loading...
USB C Car Charger, 3-Port 67W Dual USB-C & USB-A Car Power Adapter PD/QC Fast Charging Cigarette Lighter for iPhone 17/16/15/14/13/12/11 Pro Max, iPad, Samsung Galaxy S25 S24/S23/S22, Pixel, Android

USB C Car Charger, 3-Port 67W Dual USB-C & USB-A Car Power Adapter PD/QC Fast Charging Cigarette Lighter for iPhone 17/16/15/14/13/12/11 Pro Max, iPad, Samsung Galaxy S25 S24/S23/S22, Pixel, Android

(5,196)
$9.89
FREE delivery Sun, Sep 21 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
Stylus Pen for iPad(2018-2025)-13 Mins Fast Charge with Tilt Sensitivity & Palm Rejection for iPad 11/10/9/8/7/6th Gen, Air 7/6/5/4/3/M3/M2, Pro 13"/12.9"/11"/M4, Mini 7/6/5th, White

Stylus Pen for iPad(2018-2025)-13 Mins Fast Charge with Tilt Sensitivity & Palm Rejection for iPad 11/10/9/8/7/6th Gen, Air 7/6/5/4/3/M3/M2, Pro 13"/12.9"/11"/M4, Mini 7/6/5th, White

(2,294)
$9.98
FREE delivery Fri, Nov 14 on $35 of items shipped by Amazon
10K+ bought in past month
Loading...
Mini Mic Pro (Latest Model) - Professional Wireless Microphone for iPhone, iPad, Android, Lavalier Microphone for Video Recording - iPhone Mic Crystal Clear Recording with USB-C for Content Creators
Best Seller

Mini Mic Pro (Latest Model) - Professional Wireless Microphone for iPhone, iPad, Android, Lavalier Microphone for Video Recording - iPhone Mic Crystal Clear Recording with USB-C for Content Creators

(4,360)
$24.99$24.74
FREE delivery Thu, Sep 4 on $35 of items shipped by Amazon
10K+ bought in past month