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
All prices in USD. Provides access to the course and all its updates for 1 year from date of purchase.
Buy course now
Buy for a team
Or

Flexible Subscription plans

Gain access to multiple or all courses and get the flexibility you need to gain skills and take your career forward!
More info on

Discovery Plan

A month long taster
$ 99 / month
  • Access 1 new course per month for free*
    + extend access to all previously purchased courses
  • Event Pass Taster
    Free access to any open Learning Series event**
     
  • Completion Certificate awarded for all completed courses
     
     
     
     
Subscribe & Pick Your Course!
NEW!

6-Month All-Access

Focus your learning
$ 399 / 6 months
  • Access ALL 15+ courses
    + instant access to every new course
  • ½ Event Pass
    6 month's worth of Learning Series events
     
  • Completion Certificate awarded for all completed courses
  • Everything else on motif.org
Gain Instant Access
New!

1-Year All-Access

Grow with the MOTIF Community
$ 680 / year
  • Access ALL 15+ courses
    + instant access to every new course
  • Full Event Pass
    A year's worth of Learning Series events
    MOTIF's Sustainability Book Club
  • Completion Certificate awarded for all completed courses
  • Everything else on motif.org
Gain Instant Access
Best value

Notes, Terms & Conditions

You can cancel your subscription at any time during your plan term and deactivate its auto-renewal.
The discovery plan is not eligible to corporate team packages & volume discounts.
* During the first 3 months of subscription under this plan, you may choose any available course under $200. From the 4th month onward, you choose from any available course in the catalogue.
** MOTIF will organize at least 8 Learning Series events per year but cannot guarantee one will be opened for registration during every single discovery plan month. Free tickets are also subject to seat availability and event capacity.
The Discovery Plan is non-refundable and non-transferable. By purchasing the Discovery Plan, you agree to MOTIF’s Privacy and Terms & Conditions of Use.
You can cancel your subscription at any time during your plan term and deactivate its auto-renewal.
The discovery plan is not eligible to corporate team packages & volume discounts.
* Free tickets are subject to seat availability and event capacity.
The All-Access Pass is non-refundable and non-transferable. By purchasing the All-Access Pass, you agree to MOTIF’s Privacy and Terms & Conditions of Use.
You can cancel your subscription at any time during your plan term and deactivate its auto-renewal.
* Free tickets are subject to seat availability and event capacity.
The All-Access Pass is non-refundable and non-transferable. By purchasing the All-Access Pass, you agree to MOTIF’s Privacy and Terms & Conditions of Use.

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