XLS Basics

SS_ExcelBasicsXLS Basics is designed for creative entrepreneurs who want to harness the power of database software for billing, organizing client contacts, managing expenses, and creating visual communications.  This is an introductory course designed for someone with minimal experience writing formulas in Excel.

 

Why Take This Course?

  • Because someone once described Excel as “magical.”
  • Because you are pretty sure it can do more than add numbers.
  • Because listing your expenses on paper isn’t cutting it anymore.
  • Because your grant applications keep getting rejected.
  • Because you can use it to track your time and your money. (Really.)
  • Because this is the year to make your accountant shed tears of joy.
  • Because you want to track submissions, contacts, and marketing efforts.
  • Because it wasn’t invented when you were in high school.
  • Because you have no idea where your money goes.
  • Because organizing numbers in Excel feels easier than organizing your life.

 

Course Outcomes

After completing this course, students will be able to:

  • Write basic formulas in appropriate contexts including SUM, SUMIF, COUNT, COUNTIF, and TODAY.
  • Format alpha-numerical information in Excel, including adjusting column width and wrapping text.
  • Design spreadsheet layouts that communicate numerical information effectively.
  • Build custom charts to express numerical data visually.

 

Delivery Mechanisms

In addition to video-guided exercises designed to build these Excel skills, this course includes a short-cut reference guide and a series of Expert Tips to incorporate these skills in a creative setting.

At the end of the course, you may submit your own workbook to the Minerva Financial Arts team for feedback and review.

 

Details

The course kicks off on January 18, 2016. You have six weeks to complete the course based on your own time and schedule.

Your investment is $49 and about four hours of time.

Register Now

 

 

You May Also Like…

 

SS_XLSpartyExcel Party Tricks

This course goes a bit deeper into Excel tricks, including filters, data validation, and hidden sheets.

 

SS_SingleCurrencyBudgeting Basics

Now that you’ve mastered Excel, put those skills to use in building a budget that complements your creative career.