In this class you will learn how to structure, prepare and analyze data in a simple yet efficient way when you use tables and conditional formatting together.
After taking this class you will be able to structure data by using tables, change the formatting of a cell or add descriptive content to it with conditional formatting and you will be able to analyze data by sorting and filtering a table using its conditional formatted cells.
WHY YOU SHOULD TAKE THIS CLASS
We often need to structure and analyze data in a short period of time. So, we need a simple yet effective way to do this.
Excel gives us the possibility to combine related data in a range of cells with tables. And you can change the appearance of certain cells by highlighting them with conditional formatting based on rules which are pre-defined by you.
If you want to learn how to structure, prepare and analyze data in a simple yet efficient way when you use tables and conditional formatting together, you should definitely take this class.
As an Engineer, I am using Excel every day at work. With my knowledge, I will help you saving your time by focusing on the relevant parts of this topic.
WHO THIS CLASS IS FOR
This class is for everyone who knows the basics of Excel. If you do not know the basics yet, go check out my Excel Basic Training.
WHAT YOU’LL LEARN
I have divided this class into three main learning goals:
Structure data
Combine related data in a range of cells with tables.
Format an area as a table.
Change the table design to adjust the appearance of the table.
Fill the table with data.
Prepare data
Change the formatting of a cell or add descriptive content to it with conditional formatting.
Create new conditional formatting rules.
Manage existing conditional formatting rules in the Conditional Formatting Rules Manager.
Analyze data
Sort and filter the data in the table using its conditional formatted cells.
Sort the data in the table.
Filter the data in table to concentrate on the relevant content.
WHAT YOU’LL NEED
Needed:
Microsoft Excel
Provided:
You will get example sales data to create your own table.
Drake University Doctoral Capstone by Kirstan DuBree
Understand crypto, create your portfolio and make your first transactions
A beginner Java course covering all of the basics you need to know for the AP Computer Science A Exam.
A Non-Specialist's Guide to Apocalyptic Painting
Hi there, I'm Jan-Philipp. I am an Engineer from Germany.
ABOUT ME
I am very curious and a fan of lifelong learning, so I self-teach me things which benefits me in my life.
My favorite question is: Why and how did you do that? That's sometimes annoying for my surroundings but I cannot fight my nature. Maybe, that is why I became an Engineer. :-)
Because of my profession, I have learned how to cut big tasks into little actionable steps. I have worked in the aerospace industry and taught people how to build parts of an aircraft engine. Furthermore, I am experienced in designing and optimizing business processes.
In short, I am good at explaining the steps you need to know to achieve the learning goals of my classes.
MY TOPIC: SOFTWARE TEACHING
This is the topic I love to cover in my classes: How to use software and what to do with it.
As you may have guessed, I am interested in many topics. But I realized, that I am good in Software Teaching. I am the go-to-guy, if my friends and colleagues have any software related question.
I scroll through all of the settings in a software when an update is released. It is a little bit nerdy but someone has to do it. Don't you think so? :-)
LET'S START LEARNING
If you you are interested, you can check out the courses I am already teaching.
Have fun learning, it is a lifelong journey!
- Jan-Philipp
