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