XLS 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.
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.
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.
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.
You May Also Like…
Excel Party Tricks
This course goes a bit deeper into Excel tricks, including filters, data validation, and hidden sheets.
Now that you’ve mastered Excel, put those skills to use in building a budget that complements your creative career.