Coursera Plus Annual is 50% Off — Ends June 17.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CreativeLive

Financial Analyst Program (Self-Paced)

via CreativeLive

Go to class Write review

Overview

In this financial analyst program, you'll build foundational and intermediate Excel skills, brush up on corporate finance and financial accounting concepts, and construct a comprehensive valuation model for a public company. It's one of the most effective and affordable ways to pick up the skills...

Syllabus

  • Interface
  • Rows and Columns
  • Autofill
  • Data Entry
  • Calculations
  • Autosum Functions
  • Text Functions
  • True False
  • Absolute Cell References
  • Multi Input Functions
  • Formatting
  • Conditional Formatting
  • Line Chart
  • Column Chart
  • Trendlines
  • Pie Chart
  • Tables
  • Printing
  • Worksheets
  • Freeze Panes
  • Excel Tricks
  • Tips and Fundamentals
  • Navigation
  • Paste Special
  • Paste Special Values
  • Splitting Text
  • Joining Text
  • Named Ranges
  • Data Validation
  • Remove Duplicates
  • VLOOKUP
  • HLOOKUP
  • Sort and Filter
  • Pivot Tables New
  • Pivot Grouping Timelines
  • Multiple Pivot Tables
  • If Statements
  • And Or
  • COUNTIFS and SUMIFS
  • Combo Charts

Reviews

Start your review of Financial Analyst Program (Self-Paced)

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.