Skip to main content

Watch Preview

Microsoft Excel for Your Business

with David Casuto

Log in or Sign up for FREE and get full access to these and thousands of other Open Lessons in our catalog! Watch 1 Lesson For Free

  •   01 The Basics of Microsoft Excel: Customization

    35:43

Class duration: 14h 5m

See all 27 lessons
  • 6K students

    100% satisfaction guaranteed

  • 100% recommended

    2 student reviews

  • Access anytime

    OFFLINE SYNC WITH iOS APPS

Get the Pass

starting at $25/month*

$299/year or $39/month

Unlock this class plus 1500+ more >

Watch Now

You already have access!

Buy Class

$49

About The Class

a complete guide to Microsoft Excel

Microsoft® Excel® is not just for boring spreadsheets anymore! Join Dave Casuto for an introduction to everything this powerful software program has to offer. The many functions of Microsoft Excel are particularly valuable to freelancers — from invoicing clients to archiving your work, and much more.

This course will start with an in-depth walk through of the Microsoft Excel interface. You’ll learn how customize the workspace and understand the overall anatomy of the program to make Microsof® Excel work for you! Dave will also explain how to control and edit your spreadsheets by resizing columns, aligning text, formatting numbers/text, Styles and working with colors, shadings and borders. You’ll also learn to perform core tasks such as Sorting/Filtering, Charts/Graphs, Autofill techniques, Conditional Formatting, working with large spreadsheets, Graphics/Shapes, Pivot Tables, Microsoft Excel templates, simple formulas and much more! A large focus all throughout will be on tips, tricks and shortcuts to make your journeys though Microsoft Excel seamless and trouble-free, so you can focus more of your time on your other work!

Whether you’re a freelancer, business professional or a creative designer (or even an accounting pro ready for a deeper understanding of this newest iteration of the software), this course will teach you everything you need to know to harness the power of Microsoft® Excel®.

Topics Covered


Lesson Plan

  1. 01

    The Basics of Microsoft Excel: Customization

    Learn the anatomy of Microsoft® Excel® and how you can customize it to make it function for the way you work.

    35:43
  2. 02

    Anatomy of Microsoft Excel

    43:09
  3. 03

    Formatting: Making it User Friendly

    39:05
  4. 04

    Building a Document from Scratch

    31:22
  5. 05

    Advanced Formating + Styles

    43:30
  6. 06

    More Formatting, Transpose, & Alignments

    38:34
  7. 07

    Basic Formulas

    31:38
  8. 08

    Auto Sums & Inserting Rows

    19:46
  9. 09

    Advanced Auto Fills

    28:43
  10. 10

    Working with Large Worksheets

    39:17
  11. 11

    Hiding Columns

    41:50
  12. 12

    Tips and Tricks on Printing

    31:53
  13. 13

    Titles, Headers, Footers and More

    35:38
  14. 14

    Q & A

    09:16
  15. 15

    The Magic of Sorting & Filtering

    29:41
  16. 16

    Conditional Formatting

    33:23
  17. 17

    Communicating with Charts

    30:42
  18. 18

    Making Your Chart Pop

    37:19
  19. 19

    Working With Tables

    36:01
  20. 20

    PivotTables, PivotCharts & Subtotals

    40:23
  21. 21

    Graphics: Shapes

    30:46
  22. 22

    Graphics: Pictures

    20:28
  23. 23

    SmartArt

    14:31
  24. 24

    Text to Columns, Data Validation

    41:15
  25. 25

    Data Validation: Date

    21:00
  26. 26

    Working Between Programs

    26:25
  27. 27

    Templates in Microsoft Excel

    14:13

Meet Your Expert

David Casuto

David Casuto teaches technology courses at UC Berkeley, SFSU, Synergy School, AcademyX, UC Santa Cruz and various corporate entities. He has two Master's Degree in Instructional Technology (Education) and Industrial/Organizational Psychology. His emphasis of instruction includes office software, web design, ... read more

See instructor's Classes

Bonus Material

Access your course materials here!

Get access to exclusive bonus content when you purchase this class.

  • pdf Exercises 1
  • pdf Exercises 2
  • pdf Exercises 3
  • pdf Beyond the Basics (PC-Mac)
  • pdf Mac Quick Reference-Custom Guide
  • pdf Mac Booklet Part 1
  • pdf Mac Booklet Part 2
  • pdf PC Quick Reference-Custom Guide
  • pdf PC Booklet
  • pdf Pivot Tables (PC-Mac)
  • pdf Mac Shortcut Keys
  • pdf Windows Shortcut Keys

100% of students recommend this class.
See what some of them have to say.

  • Creativelive Student

    December 2015

    Great class and highly recommended but now out of date. Surely an update is planned?

  • Przemek Janus

    March 2017

    This is Excel for Mac. I think real Excel work is done in Excel for PC as that version offer much more compared to Mac version. Apart from that shortcuts are quite different between versions. Just a note.

    Similar classes you might like

    You know who’d love this class...?

    When gift-spiration strikes, grab it. Give this class to a friend who’d love it. For their birthday or just because. (Or just because you missed their birthday.)

    GIFT THIS CLASS