- MS Excel for everyone! Learn Excel for the first time, Know the basics with projects and challenges. Build spreadsheets!
- Free tutorial
- Rating: 4.1 out of 54.1 (213 ratings)
- 5,875 students
- 1hr 4min of on-demand video
- Created by The TechSkills
English
What you’ll learn
- Build Excel Apps.
- Write functions and formulas to make calculus.
- Make tables with automatic calculus.
- Understand basic excel technical concepts.
- Make line chart.
- Conditional formatting.
- Commonly used functions.
Requirements
- Willingness to learn.
- A computer with MS Excel software.
- No previous experience is required. You’ll learn everything you need to know
Description
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.
Who this course is for:
- Beginner Excel.
- If you look to take your Excel skills from beginner to master the basics, then this course is for you.
- Everyone curious about MS Excel or spreadsheets.
Show less
Course content
5 sections • 16 lectures • 1h 5m total lengthCollapse all sections
Welcome!2 lectures • 4min
- Introduction to MS Excel03:20
- Welcome!00:15
The Basics7 lectures • 37min
- Basics Functions of in Excel16:43
- Basics Functions of – Challenge00:08
- Basics Functions – Challenge03:46
- Relative and Absolute Reference in Excel08:02
- Relative and Absolut Reference in Excel – Challenge04:00
- Operating with SUMIF and COUNTIF functions in Excel04:18
- Relative and Absolute Reference – Challenge00:08
Formatting3 lectures • 13min
- Formatting as Table in Excel04:24
- Conditional Formatting in Excel05:14
- Conditional Formatting in Excel – Challenge03:28
If, Chart and Concat3 lectures • 11min
- Working with IF function in Excel04:17
- Working with Line Chart in Excel04:08
- Making Concatenation in Excel02:42
Congrats1 lecture • 1min
- Congratulations, You’re done!00:14
