Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Excel Tutorial for Beginners: Learn it FAST
Play lesson

FREE Microsoft Excel Course - Excel Tutorial for Beginners: Learn it FAST

4.0 (3)
22 learners

What you'll learn

This course includes

  • 5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

FAQs

Course Hive
Download CourseHive
Keep learning anywhere