Microsoft Excel: Basics and beyond (productivity demo)

Sign in to queue

Description

Brian Moring, productivity trainer with Microsoft IT Showcase, demonstrates how to use Excel for collaboration and increased productivity in the cloud. Find out how to create an Excel workbook, save it to OneDrive, use formulas and functions, and visualize your data in charts and graphs. See how to insert PivotTables and learn how to access Excel from your Windows, iOS, or Android device.  

These questions — and more — are discussed during this session:

  • [02:26] Create an Excel workbook
  • [04:27] Working with your data
  • [10:20] Formatting numbers.
  • [16:05] Using functions.
  • [29:18] Building charts and tables.
  • [40:50] Storing your workbook securely to OneDrive.
  • [42:46]  Sharing and collaborating your workbook.

Access additional technical content, discover new and exciting career opportunities in IT, and much more:

Embed

Download

Download this episode

Download captions

The Discussion

  • User profile image
    SSDH

    Good refresher on Excel. What about next level such as Pivot tables Etc....!

  • User profile image
    Ernest

    I have been using Excel for years and was happy to learn a number of new tools and techniques from the video. I am looking forward to viewing more videos. Please keep them coming!

  • User profile image
    Willem

    Hi,

    1. What are the benefits of using a table? It is an extra step, but is their also extra functionality?

    2. Pitty that the important subtotal function failed.

    3. Make the video 15 minutes shorter.

  • User profile image
    TeamDepends

    More Excel videos

  • User profile image
    glnz

    Looks good - will view soon.  Two Qs:

    1)  Anything similar for Access (which I've never used)?

    2)  Is there a next episode for this video, maybe pivot tables?

    Thanks.

Add Your 2 Cents