Navigation & Data in Excel

Simplifying Excel for navigation and data: learn to use Excel like the pros in a few easy steps

Led by CFA charterholder Daniel Jassy View Instructor Bio

See what other students are saying
$19.95 $19.95 USD
Lifetime Access
  • One time payment, money back guarantee
  • Self-paced online course, lifetime access
  • Interactive content and downloadable materials
FAQs

Course Description

This online course is for beginners to get started using Excel to navigate large data sets with speed and ease. You’ll

  • Benefit from expert advice, in simple language, from an accomplished financial analyst
  • Save hours every week by mastering keyboard shortcuts for formatting and navigation
  • Discover which Excel functions financial experts use daily (and which ones they don’t)

Course Curriculum

Welcome!
  • Mac Shortcuts
  • Introduction
  • Welcome
Navigation & Data
  • Navigation and Data Workbook Part 1
  • Navigation and Data Workbook Part 2
  • Introduction to Navigation & Data
  • A Glimpse into Your Life as an Excel Pro
  • Navigation, Arrow Keys, SHIFT & CTRL
  • Inserting & Editing Cells, Rows and Columns
  • Deleting Cells & Commenting
  • Freezing Rows & Splitting the Screen
  • Special Paste: Your New Best Friend
  • Sorting 
  • Filtering
  • Conclusion to Navigation & Data

About the Instructor

Daniel Jassy
Daniel Jassy CFA®

Daniel Jassy, CFA, worked on idea generation, due diligence and modeling as a portfolio manager for a long-only equity fund. He attended the Charles W. Lamden School of Accountancy at San Diego State University. Daniel was awarded the Chartered Financial Analyst® designation in August of 2016 after passing levels I, II and III of the CFA ® exam. He currently designs and develops trading-analysis software, which provides an edge to portfolio managers by lowering execution costs.