YoVDO

Microsoft Excel for Your Business

Offered By: CreativeLive

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses PivotTables Courses

Course Description

Overview

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


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

Related Courses

Using Covid-19 Data to Make Supply Chain Logistics Decisions in Spreadsheets
Coursera Project Network via Coursera
Microsoft Excel - Excel from Beginner to Advanced
Udemy
Excel Shortcuts, Excel Tips, Excel Tricks - Excel Skills!
Udemy
Learn Excel 2016 Intermediate Level - Beyond the Basics
Udemy
Microsoft Excel Mastery: From Beginner to Pro
Udemy