Excel for the Real World: Gain the Basic Skills of Microsoft Excel | Al Chen | Skillshare

# Excel for the Real World: Gain the Basic Skills of Microsoft Excel

#### Al Chen, Excel Trainer & Coda Evangelist

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
10 Lessons (1h 2m)

0:54

4:17

4:21

5:16

6:15

7:02

5:54

8:30

9:07
• ### 10. Paste Special

10:11
313 students are watching this class
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

27,383

Students

36

Projects

Spend less time formatting and manipulating data, and more time presenting insights.

Microsoft 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 with Excel. 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.Â WhetherÂ you are new to Excel or are looking for a refresher on how to use Excel to analyze data, this class is for you.Â

Learn by doing.

You'll follow along with me in the Excel for the Real World fileÂ I have provided under the "Projects & Resources" tab (in this tab see the "Resources" section).Â Then, it's your turn to submit a project! Find some data from a project you are working on (or someone sent you some data in Excel) and filter/sort the data, write some formulas, andÂ apply the techniques that data analysts use every day!

What You'll Learn

• Using the Ribbon.Â Use the Ribbon to your advantage by clicking on different buttons and customizing the ribbon to fit your needs.
• Structuring Your Workbook. We'll cover cells in a worksheet and how worksheets fit into a workbook.
• Formatting. Get a little artsy in Excel!
• Selecting Data. Select the data and smartly "autofill" data.
• Writing Formulas.Â Write basic formulas and do a deep dive on the popular VLOOKUP formula.
• Listing and Sorting. Organize your data so that it's easier to analyze.
• Using Paste Special. We will see how the Paste Special menu lets you do things above and beyond copy-and-paste.

The next 2 classes in this series:

Ready to go to the Intermediate Excel class?

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.

Note: The version of Excel used in this classÂ is Max Excel 2011, but the concepts apply to both PC and Mac.

## Meet Your Teacher

#### Al Chen

Excel Trainer & Coda Evangelist

Teacher

I have been an Excel power user for 10+ years. I started learning Excel when I was a financial analyst at Google. 30,000+ students have taken my online Excel classes and I have facilitated in-person workshops to over 5,000 MBA students around the the U.S.

I founded KeyCuts, an Excel training and consulting company to Fortune 500 companies. If it isn't clear I'm addicted to Excel, perhaps my podcast about Excel and data analysis (Dear Analyst) will convince you :).

Outside of Excel and spreadsheets, I'm experimenting with different productivity tools to help people be more productive at work. I have become an active user of (and currently work for) Coda, an all-in-one doc for teams. If you would like to read my full journey with spreadshee... See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

# Your creative journey starts here.

• Supportive online creative community
• Learn offline with Skillshareâ€™s app

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

## Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.