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