Relative references change when a formula is copied, while absolute references, such as $A$1, remain fixed.
Duration of the online course: 54 minutes
Build job-ready Excel skills fast with this free online course—learn formulas, formatting, and spreadsheets basics to work smarter and earn a certificate.
Excel is one of the most in-demand workplace tools, and getting comfortable with it can instantly boost your productivity, confidence, and opportunities. This free online course is designed for true beginners who want a clear, practical path from opening a spreadsheet to working with it efficiently. Whether you’re studying, managing personal budgets, supporting a small business, or stepping into an office role for the first time, you’ll learn to navigate Excel without feeling overwhelmed.
Instead of relying on memorized steps, you’ll build a solid foundation that helps you understand how spreadsheets are structured and why common features work the way they do. You’ll practice working with ranges, selecting and editing cells, and using the interface smoothly, including tools that make viewing and organizing data easier. Along the way, you’ll pick up time-saving habits for resizing columns quickly, applying consistent formatting across multiple cells, and keeping your worksheets readable as they grow.
You’ll also learn the logic behind formulas, focusing on a skill that separates confident users from frustrated ones: cell references. Understanding when references change automatically and when they should stay fixed makes it much easier to create reliable calculations you can reuse. You’ll apply key spreadsheet functions to analyze values, including finding high points in a dataset, and you’ll see how small choices in structure can make your work more flexible and accurate.
Because spreadsheets are often shared or printed, the course also helps you prepare work that looks professional beyond the screen. You’ll discover how different workbook views support layout decisions and why previewing page breaks matters when you need clean, well-organized printed output. By the end, you’ll be equipped with practical Excel fundamentals you can apply immediately in real tasks, giving you a strong starting point for more advanced skills.
54 minutes of online video course
Digital certificate of course completion (Free)
Exercises to train your knowledge
100% free, from content to certificate
What is the difference between relative and absolute cell references in Excel?
Relative references change when a formula is copied, while absolute references, such as $A$1, remain fixed.
How can I quickly resize multiple columns in Excel?
Select the columns, then double-click the boundary of any selected column header to AutoFit them to their contents.
Why use Page Break Preview in Excel before printing?
Page Break Preview shows how the worksheet will split across printed pages, so you can adjust page breaks and layout.
Ready to get started?Download the app and get started today.
Install the app now
to access the courseOver 5,000 free courses
Programming, English, Digital Marketing and much more! Learn whatever you want, for free.
Study plan with AI
Our app's Artificial Intelligence can create a study schedule for the course you choose.
From zero to professional success
Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.
You can also use the QR Code or the links below.

Free CourseExcel for Beginners: 2-Hour Crash Course in Formulas, Charts and Pivot Tables
2h09m
30 exercises

Free CourseExcel Intermediate to Advanced: Formulas, PivotTables, Power Query, Dashboards and VBA
18h53m
28 exercises

Free CourseMS Excel Beginner to Advanced: Formulas, Charts, Pivot Tables and Shortcuts
10h08m
26 exercises

Free CourseMicrosoft 365 Fundamentals MS-900 Certification Prep Course
3h16m
14 exercises

Free CourseGoogle data studio
3h42m
11 exercises

Free CourseExcel Basics: Formulas, Functions, PivotTables and Power Query for Work
12h14m
22 exercises

Free CourseWord for beginners
43m
8 exercises

Free CourseWord
1h46m
25 exercises

Free CoursePowerPoint
2h15m
22 exercises

Free CourseExcel basic to advanced
12h34m
19 exercises
+ 10 million
students
Free and Valid
Certificate
60 thousand free
exercises
4.8/5 rating in
app stores
Free courses in
video and ebooks
Course comments: Excel for beginners
Students found the free course excellent, concise, easy to understand, and effective for learning the basics. Many expressed gratitude and appreciation, though one student noted that two questions lacked correct answers.
Ramzan Ranja
nice appreciate you
ALVERIAS JERRY IDACHI
excel
David
im so grateful, your video/course is better than others courses videos in my country (brazil), thank you so much.
Amit verma
amazing
Abenezer Beneyam Mesfin
concise, very easy to understand, and covers most of the basic.
Priya Orissa Larlchun
Explanation was good and very easy to learn
David Charles (Prof)
Thank You So So Much.
Lucas Mateo Sanchez
2 questions without correct answer
Akshit Thakur
awesome