Microsoft Excel for Your Business
David Casuto
Lessons
Day 1
1The Basics of Microsoft Excel: Customization
35:43 2Anatomy of Microsoft Excel
43:09 3Formatting: Making it User Friendly
39:05 411:30 am - Building a Document from Scratch
31:22 512:45 pm - Advanced Formating + Styles
43:30 61:30 pm - More Formatting, Transpose, & Alignments
38:34 72:30 pm - Basic Formulas
31:383:00 pm - Auto Sums & Inserting Rows
19:46 93:30 pm - Advanced Auto Fills
28:42Day 2
109:00 am - Working with Large Worksheets
39:16 119:45 am - Hiding Columns
41:50 1210:50 am - Tips and Tricks on Printing
31:53 1311:20 AM - Titles, Headers, Footers and More
35:37 1412:50 pm - Q & A
09:16 151:00 pm - The Magic of Sorting & Filtering
29:41 161:30 pm - Conditional Formatting
33:23 172:30 pm - Communicating with Charts
30:42 183:00 pm - Making Your Chart Pop
37:19Day 3
199:00 am - Working With Tables
36:01 209:45 am - PivotTables, PivotCharts & Subtotals
40:22 2110:45 am - Graphics: Shapes
30:45 2211:15 am - Graphics: Pictures
20:27 2311:45 am - SmartArt
14:31 241:00 pm - Text to Columns, Data Validation
41:14 251:30 pm - Data Validation: Date
20:59 262:30 pm - Working Between Programs
26:24 27Templates in Microsoft Excel
14:13Class 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 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®.
Class Materials
bonus material with purchase
Ratings and Reviews
Arlene Baratta
Even though it's 2021, this course is still amazing. I followed along just fine using the latest version (365). I watched thinking it was just going to be another "basic" overview of Excel. It's not. I learned a lot that could really help me keep track of my business, not just financial aspects either. I HIGHLY recommend this course.
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.