
Discover how Microsoft Excel functions as a spreadsheet to record and analyze numerical data. Learn about columns, rows, and cells, cell addresses, and basic table and graphics capabilities.
Learn the basics of Excel functions and formulas, create and format tables, and perform core calculations including addition, subtraction, multiplication, division, averages, and min/max with cell ranges and dynamic results.
Tackle a hands-on challenge in Microsoft Excel to apply basic functions, using formulas to perform addition, subtraction, multiplication, and division across a cell range, plus average, minimum, and maximum.
Learn how relative and absolute references work in Excel by building a unit-based total calculator, showing how drag-copy changes relative values while keeping fixed units and prices.
Practice relative and absolute references in Excel with a challenge that models monthly payments at 120 percent of the previous month and fixes prices using dollar signs.
Use sumif and countif in excel to sum prices by a criteria and count item occurrences, with a pencil box example and a total column.
Learn how to format data as a table in Excel, convert a range to a table, apply styles, enable headers, and use the total row and filters to analyze data.
Learn to apply conditional formatting in Excel by creating rules that format cells when conditions are met, using data bars, color scales, and icon sets to highlight sales data.
Apply conditional formatting in Excel by coloring a temperature table with three rules: 0–14 blue with white text, 15–28 bold black text, and above 28 red background with red text.
Learn to use the if function in Excel to classify students as pass or fail by average score, and apply conditional formatting with green for pass and red for fail.
Create and customize a line chart in Excel by selecting data, inserting a line chart, adjusting colors and styles, and adding data labels, legend, trend lines, and a chart title.
Learn how to concatenate text in Excel by joining different text strings into one string, using quoted literals and spaces, and practice with the concatenate function.
Are you willing to build your first spreadsheets? You want to build a solid base relationship with the data records and analysis?
If YES, you are in the right place - The rapid formula course! MS Excel is the best spreadsheet program in the world for you to learn at this moment.
Getting started with MS Excel is easy.
You are gladly welcome to the Course That Gives You The Solid Basics of MS Excel in 1hour, Fast Track.
You will learn technical concepts, tables, style, format, conditional formatting, conditional statement, chart, formula, functions, and build Excel apps.
You will build projects in every lesson, and you will have challenges that will teach you, motivate you, and leave you ready to start building some spreadsheets on your own.
This course is for absolute beginners, so you do not need any previous experience because it was designed for you - Beginner. For an experienced, this course has something meaningful that you'll gain, you will remember concepts that you might have forgotten.
After finishing this course, you will:
1) Know how to write formulas and use functions;
2) Know how to style cells, and apply styles using conditions;
3) Know how to make a chart and join texts;
4) Know how to make tables that update automatically in response to any data change;
5) Fell confident to build small spreadsheets to automate your daily tasks.
Here is in detail what you will learn:
Basics functions (Addition, Subtraction, Multiplication, Division, Average, Maximum, Minimum) using formulas and functions.
Relative and absolute reference.
The functions SUMIF to add values in cells if a condition is met and COUNTIF to count cells if a condition is met.
Format cell value types.
Convert cells into a table.
Conditional formatting.
IF function.
Concatenation.
Line Chart.
And challenges.
Why should you take this course?
Should you take this course? Undoubtedly YES!
I wrapped the course with the content that every beginner should know. In just 1hour you'll end up becoming familiar with MS Excel and feel confident to build some spreadsheets.
Watch the promotional video to have a more overview of the course, including the projects that you will be making during 1hour, You'll be excited!
After that, I hope to welcome you as a new student in my course. I'm sure you're gonna love it!
Now, what are you waiting for, enroll now, and take the next step in Excel.