Microsoft Excel for Your Business

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

• 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