Excel Tutorial for Beginners: Learn it FAST

Chandoo β€’ October 5, 2021
Video Thumbnail

About

πŸ‘‹ Hello. I make you AWESOME at your work 😎 I make videos on Excel, Power BI & Data Analytics so that you can be awesome at your work. βœ… Excel ~ Power BI ~ SQL ~ Python ~ Interview Prep βœ… New Video Every Week ~ Subscribe πŸ’»πŸ“— My courses Advanced Excel πŸ‘‰ https://chandoo.org/wp/excel-school-program/ Advanced Power BI πŸ‘‰ https://chandoo.org/wp/power-bi-course/ Everything πŸ‘‰ https://chandoo.org/mdac ~ KNOW πŸ˜€ About me: https://chandoo.org/wp/about/ What I'm doing now: https://chandoo.org/wp/now/ Stuff I use: https://chandoo.org/wp/about/what-we-use/ FOLLOW πŸšΆβ€β™€οΈπŸšΆβ€β™‚οΈ 🌐 Website - https://chandoo.org/wp/ πŸ“ƒ FREE Data tips newsletter - https://chandoo.org/wp/subscribe/ πŸ“š Courses - https://chandoo.org/wp/training-programs/ πŸ“· Instagram - https://www.instagram.com/chandoo.xlsx/ πŸ’₯ఀెలుగు Telugu Channel - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw/

Video Description

New to Excel and not sure where to begin or how to know all the basics in one place? You have come to the right place. In this concise yet in-depth video, learn: 1) What is Excel and how to use it? 2) How to enter and format data in Excel? 3) Understanding Excel's ribbon UI 4) How to set up filters & sort data? 5) How to add totals or averages with formulas? 6) How to create a chart from your data 7) How to highlight values below a certain number, automatically? 8) Example file & homework problems for you Video topics & timestamps β±πŸ‘‰ ========================== 0:00 - Introduction to Excel (Tanvi's tracking troubles) 1:15 - Starting Excel 1:38 - Understanding the Excel Screen (ribbon, formula bar, grid and status bar) 4:09 - Setting up the sales tracker 7:35 - Exploring Excel Ribbons 8:21 - Formatting the data so it looks nice 11:37 - Using filters to understand data (which customers paid by cash)? 13:05 - Formatting currency values 13:57 - Sorting data so highest amount shows on top 15:46 - Writing formulas to add up values 21:01 - Clearing away things in your spreadsheet 21:29 - Calculating average of values with formulas 22:39 - Visually representing data with Excel charts 24:08 - Formatting and adjusting Excel charts 27:27 - Special charting tip: Showing just selected data in the graph 28:26 - Highlighting values that are below 1200 (conditional formatting) 29:57 - Homework problems & closing remarks Sample file πŸ“—πŸ‘‡ ============= You can download the sample file for this course from here: https://chandoo.org/wp/wp-content/uploads/2021/10/Tanvis-Sales-Tracker.xlsx FREE Excel Tips Book πŸ“–πŸ’₯ ======================= Download your copy of 50 Excel Tips book from here - https://chandoo.org/wp/subscribe Learn more πŸ’»β© =============== Now that you finished the basic Excel course, here are the next learning stops for you. 1️⃣ Beginner to PRO Data Analysis course - 45 minute video - https://youtu.be/v2oNWja7M2E 2️⃣ Create your first pivot table and 7 more in 10 minutes - https://youtu.be/aofsdpjvK7w 3️⃣ How to use Excel's cell references to write better formulas - https://youtu.be/4MVNjzsGokc 4️⃣ Excel Basic Skills - Article - https://chandoo.org/wp/excel-basics/ 5️⃣ Complete Excel Course (Paid program by me) - https://chandoo.org/wp/excel-school-program/ Happy learning πŸŒΌπŸŒžπŸ˜€ #excel #spreadsheets

You May Also Like

Upgrade Your Travel Kit

AI-recommended products based on this video

Loading...
NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

(24)
$25.99
FREE delivery Thu, Jun 19 on your first order
Loading...
SmallRig ZV-E10 II Base Plate for Sony Alpha ZV-E10 II, Bottom Mount Plate with Quick-Release Plate for Arca, QD Socket, Hand Strap Hole, 1/4"-20 Threaded Hole - 4950

SmallRig ZV-E10 II Base Plate for Sony Alpha ZV-E10 II, Bottom Mount Plate with Quick-Release Plate for Arca, QD Socket, Hand Strap Hole, 1/4"-20 Threaded Hole - 4950

(13)
$37.99
FREE delivery Sat, Jun 21
Loading...
SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

(85)
$38.24
FREE delivery Thu, Jun 19
Loading...
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN

(71,074)
$21.99$16.59
FREE delivery Sun, Aug 10 on your first order
500+ bought in past month
Loading...
SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN
Best Seller

SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN

(71,074)
$29.99$26.61
FREE delivery Sun, Aug 10 on your first order
4K+ bought in past month
Loading...
llano RGB Laptop Cooling Pad with Powerful Turbofan Gaming Cooler Radiator with Infinitely Variable Speed, Touch Control, LCD Screen, 3-Port USB Hub, Seal Foam for Notebook Computer 15-19in

llano RGB Laptop Cooling Pad with Powerful Turbofan Gaming Cooler Radiator with Infinitely Variable Speed, Touch Control, LCD Screen, 3-Port USB Hub, Seal Foam for Notebook Computer 15-19in

(1,404)
$129.99
Prime
200+ bought in past month
Loading...
Jhcztrk 17.3 Inch Portable Monitor HDMI Type-C Laptop Gaming Monitor, 1600X900 with Built-in Speakers and Tripod External Slim Travel Monitors Second Monitors for Mac Smartphone PS4/PS5/ Gaming

Jhcztrk 17.3 Inch Portable Monitor HDMI Type-C Laptop Gaming Monitor, 1600X900 with Built-in Speakers and Tripod External Slim Travel Monitors Second Monitors for Mac Smartphone PS4/PS5/ Gaming

(32)
$161.69$161.68
FREE delivery Aug 11 - 13