Excel for the Real World I: Gain the Basic Skills of Microsoft Excel in 1 Hour Premium class

Al Chen, Excel Developer & Trainer

10 Videos (1h 2m)
  • Using the Ribbon

    • Trailer

      00:54
    • Using the Ribbon

      04:17
  • Workbook Structure

    • Workbook Structure

      04:21
  • Formatting

    • Formatting

      05:16
    • Formatting Continued

      06:15
  • Selecting Data

    • Selecting Data

      1
      1
      07:02
  • Writing Formulas

    • Writing Formulas

      05:54
    • Writing Formulas Continued

      1
      1
      08:30
  • Lists & Sorting

    • Lists & Sorting

      1
      1
      09:07
  • Paste Special

    • Paste Special

      1
      1
      10:11

About This Class

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 Project Assignments tab. 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.

Also see: Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts, & Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

moneyball.jpg

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.

98% Positive Reviews 117 See All

It's a good beginner class.
Al really made Excel easy to understand. Highly recommended!
Excellent Beginner breakdown of the great key uses of Excel. I like the fact that this is a beginner level of information without insulting the intelligence of the user. I would recommend including the PC shortcut sequences as well as the MAC. I use both, but am much more familiar with PC. Also, when the relative reference is being explained, it may be helpful to explain the relationship of 'moving around the sheet'. You could clarify by saying that it continues to reference the two cells to the left (or whatever formula you are using in the copied cell) of the cell into which the copied formula is entered. I'm sure you can put it much more eloquently and understandably - as you have for this class. Regardless of your skill level, I think it's always useful to refresh from time to time and this course would be a great source.

5

Projects

2,070

Students

Al Chen

Excel Developer & Trainer

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 with Excel were the anti-social data nerds who thought a fun weekend meant writing formulas in spreadsheets! He was very wrong...

Little did he know, his job required him to learn Excel to efficiently analyze data. He started to understand the power that data analysis has for making decisions. He founded KeyCuts, an Excel training company where or main product is a silicone keyboard cover teaching you Excel keyboard shortcuts for Excel on the Mac.

He is an instructor at NYU Stern and Columbia Business School in NYC teaching MBA students how to be faster in Excel