Master the basic & essential operations for Excel analysis
Spend less time formatting and manipulating data, and more time analyzing results and presenting insights.
Excel is an essential tool for organizing and understanding data about the world you live in! This is the first part of a 3-part series on learning to use Excel from the producers of KeyCuts. In this first class, Excel I, we will walk through the interface to help you become familiar. You will learn to navigate your way through all necessary functions of the software, understand practical applications, and gain the confidence to use it for your information needs.
Excel is a tool for analyzing data, and after taking this series you will be able to organize, analyze and provide meaningful insights about business, social/economic trends, and other data that interests you. Whether you are new to Excel or are looking for a refresher on how to use Excel to analyze data, this 3-part series is for you.
What You'll Learn
Part I of this series is all about getting familiar with the Excel interface and knowing the basics. We'll write some basic formulas, do some formatting, and cover 90%-100% of what analysts use Excel for every day.
What You'll Do
You'll follow along with me in the Excel file I have provided to learn the most common uses for Excel. The menus, formulas, and data organization techniques are the operations data analysts use 90% of the time to get their job done.
Deliverable. Create a versatile workspace for research, statistics and organization in Excel.
Brief. Create a workspace that will benefit any project you execute within the software.
Specs. Use the workspace to accomplish any task within the software.
Data drives all decisions, regardless of the business or industry you work on. You need to know how to organize it! Data is power! This Excel series will not only develop your technical skills, but also help you work with data in an efficient, smart way.
Al didn't know how to use Excel at all until he became a financial analyst at Google. He used to think that people who were efficient at Excel were the anti-social data nerds who thoug...
Really great class. Some stuff I knew already, some I didn't. Was a good refresher