Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CreativeLive

Microsoft Excel for Your Business

via CreativeLive

Overview

Microsoft Excel isn't just for boring spreadsheets anymore. Join Dave Casuto for an introduction to everything this powerful software program has to offer. Excel's many functions are particularly valuable to freelancers, from invoicing clients to archiving your work, and much more.

This course starts with an in-depth walkthrough of the Microsoft Excel interface. You'll learn how to customize the workspace and understand the overall anatomy of the program, so Microsoft Excel works for you. Dave will also explain how to control and edit your spreadsheets by resizing columns, aligning text, formatting numbers and text, using Styles, and working with colors, shadings, and borders. You'll also learn how to perform core tasks such as sorting and filtering, creating charts and graphs, using Autofill techniques, applying Conditional Formatting, working with large spreadsheets, adding graphics and shapes, building Pivot Tables, using Excel templates, writing simple formulas, and much more. Throughout the course, there's a strong focus on tips, tricks, and shortcuts to make your experience in Microsoft Excel seamless, so you can spend more time on everything else.

Whether you're a freelancer, business professional, creative designer, or even an accounting pro ready for a deeper understanding of this version of the software, this course will teach you everything you need to harness the power of Microsoft Excel.

Syllabus

  • The Basics of Microsoft Excel: Customization
  • Anatomy of Microsoft Excel
  • Formatting: Making it User Friendly
  • 11:30 am - Building a Document from Scratch
  • 12:45 pm - Advanced Formating + Styles
  • 1:30 pm - More Formatting, Transpose, & Alignments
  • 2:30 pm - Basic Formulas
  • 3:00 pm - Auto Sums & Inserting Rows
  • 3:30 pm - Advanced Auto Fills
  • 9:00 am - Working with Large Worksheets
  • 9:45 am - Hiding Columns
  • 10:50 am - Tips and Tricks on Printing
  • 11:20 AM - Titles, Headers, Footers and More
  • 12:50 pm - Q & A
  • 1:00 pm - The Magic of Sorting & Filtering
  • 1:30 pm - Conditional Formatting
  • 2:30 pm - Communicating with Charts
  • 3:00 pm - Making Your Chart Pop
  • 9:00 am - Working With Tables
  • 9:45 am - PivotTables, PivotCharts & Subtotals
  • 10:45 am - Graphics: Shapes
  • 11:15 am - Graphics: Pictures
  • 11:45 am - SmartArt
  • 1:00 pm - Text to Columns, Data Validation
  • 1:30 pm - Data Validation: Date
  • 2:30 pm - Working Between Programs
  • Templates in Microsoft Excel

Taught by

David Casuto

Reviews

Start your review of Microsoft Excel for Your Business

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.