# 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)
• 1. Trailer

0:54
• 2. Using the Ribbon

4:17
• 3. Workbook Structure

4:21
• 4. Formatting

5:16
• 5. Formatting Continued

6:15
• 6. Selecting Data

7:02
• 7. Writing Formulas

5:54
• 8. Writing Formulas Continued

8:30
• 9. Lists & Sorting

9:07
• 10. Paste Special

10:11
975 students are watching this class

## Project Description

Apply essential Excel operations to your list of data

ASSIGNMENT

Take some data you have from a project you are working on and prepare the data to be analyzed. The data could be a list of your monthly expenses, a list of names and e-mails you need to contact, anything! Make sure to anonymize the data in case anything is senstive information!

DELIVERABLE

Here's what I want you do with your data:

• Filter and/or sort it by a column
• Apply fill and font colors to your data
• Write a SUM() and/or CONCATENATE() formula in a blank cell to summarize and clean up your data

Skillshare doesn't let you upload Excel files to the Project Gallery, so upload a screenshot orÂ videoÂ of your Excel file and send me your Excel file at [email protected]

RESOURCES

• Download the Excel for the Real World IÂ Workbook in the attachmentsÂ to follow along with the class videos (see full syllabus in the file)
• If you don't have any data to play with for your project upload, I attached some sample data for you to apply the skills you learn in this class (one file shows TV shows that are available on DVD, and the other file is a monthly budget template)
• For more detailed tutorials about how to write formulas, read this article about the SUM() formulaÂ and this article about theÂ CONCATENATE() formula

434 KB

28 KB

Sebastian Lopez
5 comments
Venkataraman N.
4 comments
4 comments
Kester Avila
1 comment
Chris P.
2 comments
Sarah Boyle
1 comment
1 comment
2 comments
Adam Casteel
1 comment
2 comments
2 comments