I know learning Excel can be overwhelming.
It's a program that can do so much.
Each feature serves a purpose and there's so much information out there.
What's important and what's not.
I've designed this course with the corporate professional in mind.
I've carefully picked out the essentials and designed practical real world examples to help you understand
the full potential of each feature.
What you're going to be able to do is to use Excel to find answers from your data.
It's also going to act as your problem solving tool.
You're going to be able to present your analysis in a compelling organized manner.
Let me give you a quick overview of how we're going to do that.
You're going to start off learning how to input data including some hidden features that will save you
a ton of time.
You're going to learn how to navigate large data and how you can protect your workbook and worksheets
so the information isn't intentionally or unintentionally changed.
There are some rules you need to follow and understand when you write Excel formulas.
We're going to be covering these before we move on to the important Excel functions section that will
help you automate your analysis.
If you want to work smarter instead of harder, it's important to start with proper datasets.
You're going to learn what these are and the tools you can use to get your messy data to become a proper dataset.
To create compelling reports you need to follow a set of spreadsheet design principles.
We're going to cover these with examples as well as printing and formatting to bring attention to your
analysis.
You're going to be equipped with different ideas to visualize your data.
So if you get a task to present results, you're going to have options to choose from.
You're going to be able to impress your managers with interactive charts and tables which you can design
the pivot tables and find better ways to import and transform data with tools like Power Query.
It's going to be easy and fun.
Let's enjoy the process together.
Go through the quiz questions.
Take part in the challenges.
Try to solve them on your own before you see my version.
This is going to embed the concept in your mind so you can apply it when you come across a similar scenario
at your work.
If you're a beginner I strongly suggest that you follow the lectures in order.
If you're looking to fill in the gaps in your knowledge, feel free to jump through the different sections
as you see fit.
I've included a downloadable course outline at the end of this section.
It has the complete list of all the lectures.
Use it as a quick reference.
You can also print it out to check off the topics you've mastered or add your notes
If you need to revisit a topic later on. Next, let me show you how you can download the course files.