Money & Life > Microsoft® Excel® For Your Business

Microsoft® Excel® for Your Business

 

Microsoft® Excel® for Your Business

 

Class Description

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 Microsoft® 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®.

Lessons

  1. 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.

  2. Anatomy of Microsoft® Excel®
  3. Formatting: Making it User Friendly
  4. Building a Document from Scratch
  5. Advanced Formating + Styles
  6. More Formatting, Transpose, & Alignments
  7. Basic Formulas
  8. Auto Sums & Inserting Rows
  9. Advanced Auto Fills
  1. Working with Large Worksheets
  2. Hiding Columns
  3. Tips and Tricks on Printing
  4. Titles, Headers, Footers and More
  5. Q & A
  6. The Magic of Sorting & Filtering
  7. Conditional Formatting
  8. Communicating with Charts
  9. Making Your Chart Pop
  1. Working With Tables
  2. PivotTables, PivotCharts & Subtotals
  3. Graphics: Shapes
  4. Graphics: Pictures
  5. SmartArt
  6. Text to Columns, Data Validation
  7. Data Validation: Date
  8. Working Between Programs
  9. Templates in Microsoft® Excel®

Reviews

a Creativelive Student
 

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

Przemek Janus
 

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.