EXCEL FOR CREATIVES

Excel for Creatives

Microsoft Excel is not just a fancy accounting application (although it does an excellent job of that). Excel has a variety of uses, and for the budding creative artist, it’s typically utilized as a database for easy access to their library of films, photos, music or fine art. Excel allows you to see a quick overview of assets in an easily shareable format. At the end of this course you will be able to perform advanced functions with ease. Update and manage excel spreadsheet and books as well as create charts with a push of a button!

The Course

Registration fee: $235 (donation)

Course fee:  n/a

Duration: 4 weeks

Class time: 2 hours

Next available dates:

October 2019

November 2019

 

Topics Discussed

    • Introduction to Excel
    • Operations with formulas and functions
    • Charts and Objects
    • Working with large and multiple worksheets
    • Managing Your Data
Week One
  • Perform operations with formulas and functions
  • Calculating with Functions
  • Logical Operations
Week Two
  • Create Charts and Objects

  • Creating and Formatting charts

  • Inserting and formatting objects

Week Three

 

  • Working with large and multiple worksheets

  • Working with Large Worksheets

  • Working with multiple worksheets

Week Four

 

  • Managing and Finalizing Your Data
  •  Introduction to Pivot Tables
  •  Introduction to Macros
Materials, Resources & Prerequisites

 

 

  • Students should bring a laptop
  • There will be a pre-assessment