Excel for the Real World: Gain the Basic Skills of Microsoft Excel skillshare originals badge

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
222 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 of your Excel file and send me your Excel file at [email protected]  The most creative projects will receive a free KeyCuts Excel keyboard cover!

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

6c10e562

Student Projects

project card
4 comments
project card
Sebastian Lopez
5 comments
project card
Venkataraman N.
4 comments
project card
Kester Avila
1 comment
project card
Chris P.
2 comments
project card
2 comments
project card
Adam Casteel
1 comment
project card
2 comments
project card
Siyu Hou
1 comment
Know Alergies
Luke Chapman
1 comment