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

YouTube

Excel Features Every Accountant and Financial Analyst Needs to Know

Simon Sez IT via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
This tutorial series from Simon Sez IT provides essential Excel skills specifically designed for accountants and financial analysts in just over an hour. Master critical Excel functionalities including data importing techniques, implementing the powerful FILTER function, utilizing slicers for dynamic data visualization, setting up data validation for accuracy, creating and manipulating PivotTables, performing what-if analysis with Goal Seek, developing forecast sheets for financial projections, building specialized charts (waterfall, gauge, and pivot charts), and more. Navigate easily through different sections using the provided timestamps to focus on specific skills needed for financial analysis and reporting. The comprehensive guide systematically walks through ten crucial Excel features that will enhance productivity and analytical capabilities for finance professionals.

Syllabus

00:00:00 - How to Import Data into Excel
00:07:46 - How to Use the FILTER function in Excel
00:17:51 - How to Use Microsoft Excel Slicers
00:20:15 - How to Use Data Validation in Excel
00:26:44 - How to Create a PivotTable in Excel
00:33:40 - How to Use the Excel Goal Seek Function
00:35:26 - How to use Forecast Sheets in Excel
00:41:22 - How to Create a Waterfall Chart in Excel
00:44:44 - How to Create a Gauge Chart in Excel
00:50:07 - How to use Pivot Charts in Excel

Taught by

Simon Sez IT

Reviews

Start your review of Excel Features Every Accountant and Financial Analyst Needs to Know

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.