MS Excel for everyone! Learn Excel for the first time, Know the basics with projects and challenges. Build spreadsheets!
Learn Excel for the first time
Are you willing to build your first spreadsheets? You want to build a solid base relationship with the data records and analysis?
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.
What you’ll learn
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.
Course main points
- Basics Functions of in Excel.
- Relative and Absolute Reference in Excel.
- Operating with SUMIF and COUNTIF functions in Excel.
- Relative and Absolute Reference – Challenge.
- Formatting as Table in Excel.
- Conditional Formatting in Excel.
- Working with IF function in Excel.
- Working with Line Chart in Excel.
- Making Concatenation 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.
Requirements
- Willingness to learn.
- A computer with MS Excel software.
- No previous experience is required. You’ll learn everything you need to know.
Rating:
4.4 ( 145 ratings) 4,290 students enrolled
| Author | The TechSkills |
| Categories | Excel |
| Instructor Rating | 4.4 |
| Reviews | 33,001 |
| Students | 4,380 |
| Courses | 3 |
