LIM College

Excel Spreadsheet Analytics

business analytics business skills data visualization LIM Microsoft Excel reporting
Online course
Start for free

course info

Download brochure

This course examines the applicable use of Microsoft Excel to solve common business problems through example cases of routine issues and contingency planning. Students will gain an in-depth understanding of the importance of these financial tools and how they empower or cripple a business depending on the user’s ability to properly execute, review and report findings.

Intermediate
6 hours
$90
Provides access to the course and all its updates for 1 year from date of purchase.
Buy course now
Buy for a team
Or
Share this course

Who, How & What

Who is it for?

This course is geared for mid to senior level individuals and teams looking to refresh their Excel skills and learn new ways to organize, construct and analyze data with spreadsheets.
A basic understanding of how to navigate through Excel (create, format and present worksheets, workbooks, tables and filter select data) is required to take this course.

How will you learn?

The course is self-paced and includes a pre-assessment test and modules of interactive instruction based on videos, animations, case studies, discussion questions and knowledge assessments.

All participants who successfully complete the course will receive a MOTIF Certificate of Completion.

What will you learn?

By the end of this course, you will be able to:

1. Create advanced financial reporting tools.
2. Construct and manipulate data in PivotTables through grouping techniques, modified field settings, sorting, and filtering options to assemble data for high level decision-making.
3. Export, import, and link data from external data sources.
4. Use advanced Excel tools to analyze industry scenarios and solve complex business problems.

Online course Detailed outline

Expand all modules Collapse all modules

Module 1: The Basics Free trial

In this module, we will cover basic navigation of Excel, basic filtering, and introductory formulas.

  • Basic Overview
  • Import/Export
  • Filtering, Sorting & Subtotals
  • End of Module Practice
Show 4 topics Hide

Module 2: Pivot Tables

In this module, we will review all aspects of the Pivot Table including creation, filtering, adjusting, and standard options.

  • Pivot Tables & Recommended Pivot Tables
  • Adjusting and Sorting
  • Values and Drill Down
  • Layouts
  • Slicers
  • Timelines and Sparkline
  • Excel Dashboard using Pivot Charts
  • End of Module Practice
Show 8 topics Hide

Module 3: Formulas

In this module, we will discover the use of formulas and how to create them in your spreadsheet. We will focus on the use of SUMIF, HLOOKUP and VLOOKUP fomulas.

  • Concatenate
  • SUMIF(s)/COUNTIF(s)
  • HLOOKUP/VLOOKUP
  • End of Module Practice
Show 4 topics Hide

Module 4: Conditional Formatting

In this module, we will review the purpose of conditional formatting and its use in fashion

  • Data bars/ Color Scales/ Icon Sets
  • Creating Rules
  • End of Module Practice
Show 3 topics Hide

Module 5: Spreadsheets

In this module, we will cover formulas to create automated spreadsheets.

  • Sales Comparison – Month to Month & Quarterly
  • Sales Comparison – Current Year to Prior Year
  • Annualization
  • Forecast Sheet Option
  • End of Module Practice
Show 5 topics Hide

Conclusion

Review the knowledge and key concepts seen in this course.

  • Final assessment
  • End of course survey
Show 2 topics Hide
Start for free

Christopher Truhan

Course Instructor

Christopher teaches Finance as an adjunct professor at LIM College, a private college in midtown Manhattan focused on the business of fashion. He is also a Finance Manager at Northwell Health, a nonprofit integrated healthcare network that is New York State’s largest healthcare provider and private employer.

 

About LIM College

Fostering a unique connection between academic study and its application in the workplace, LIM College has been at the forefront of educating fashion’s future business leaders since 1939.

Based in New York City – the heart of the global fashion industry – LIM offers both online and on-campus associate, bachelor’s, and master’s degree programs in a variety of fashion-focused majors. Classes are taught by industry professionals and veterans who are experts in their fields. Areas of study include Fashion Marketing, Fashion Merchandising, Retail Management, Global Fashion Supply Chain Management, International Business, Visual Studies and Fashion Media.

With over 800 industry partners, and a community of alumni with thriving careers in every aspect of fashion and its related fields, LIM College is recognized worldwide for its specialized and immersive approach to fashion education. Our online degree offerings were included in U.S. News & World Report’s ranking of 2020’s “Best Online Graduate Business Programs” and “Best Online Bachelor’s Degree Programs,” and in 2019 we were named as one of “The Best Fashion Schools in the World” by the BoF (Business of Fashion).

Share this course