Excel For Accounting & Finance

Comprehensive all in one training to Master Microsoft Excel for Data and Financial Analysis

What you'll learn

• Master Microsoft Excel and its advanced features

• Acquire financial modeling and data analysis skills

• Design professional advanced charts

• Become a proficient user with Excel functions, pivot tables, visualizations, and advanced features such as Power Query, Power Pivot and Dynamic Array Function

• Build dynamic reports using Excel PivotTables and visualizations

• Improve productivity with time-saving Excel shortcuts and best practices

• Gain the confidence to solve complex Excel tasks with ease

• Building organized and effective spreadsheets

• Managing and analyzing large data sets with ease

• Mastering essential and advanced Excel functions

• Cleaning and auditing formulas to ensure accuracy

• Automating tasks with Macros

Requirements

• No prior Excel knowledge required

• Knowledge of basic accounting and financial concepts

• Microsoft Excel 2016, 2019, 2021 or Microsoft Excel 365 (Microsoft Excel 365 is recommended to take advantage of the latest Excel functions and features covered in the course. You can also use the free web version)

Description

This course contains the use of artificial intelligence.Master Microsoft Excel: Beginner to Expert for Accounting and Finance All-in-One CourseUnlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros, Power Query, Power Pivot and Dynamic Array Functions. This course bundles three intensive classes into one powerful package.Do you want to learn how to use Excel in a real-life accounting and finance working environment?Are you about to graduate from a university/taking or finishing a professional accounting or finance qualification and look for your first job?Would you like to become your team's go-to person for financial/accounting or general tasks in Excel?Join thousands of successful students taking this course.Your instructors possess extensive experience in financial modelling and are fully qualified ACMA, CGMA and CFA professional qualification holders. They have years of experience in investment banking, corporate banking, accounting and corporate finance.Learn the subtleties of using Excel for financial data analysis from instructors who has walked the same path. Beat the learning curve and stand out from your colleagues with this course today.What We Offer:Well-designed and easy-to-understand materialsDetailed explanations with comprehensible scenarios based on real situationsDownloadable course materialsRegular course updatesProfessional chart examples used by major banks and consulting firms.Real-life, step-by-step examplesAccess to our innovative Excel learning App that plugs in directly to your Excel application to provide a unique and immersive learning experienceUpon completing this course, you'll be able to do the following:Work comfortably with Microsoft Excel and many of its advanced featuresBecome one of the top Excel users on your teamPerform regular tasks quickerDesign professional and advanced chartsAcquire Excel proficiency by learning advanced functions, pivot tables, visualizations, and Excel featuresBecome a competent data analyst with Power Query and Power Pivot expertiseBe ready for the age of AI with Copilot training included in the courseAbout the course:30-day money-back guaranteeNo significant previous experience necessary to understand the courseUnlimited lifetime access to all course materialsEmphasis on learning by doingTake your Microsoft Excel and financial data analysis skills to the next levelMake an investment that is rewarded in career prospects, positive feedback, and personal growth.This course is suitable for graduates and professional accounting and finance qualification holders and students aspiring to become finance and accounting professionals as it includes a well-structured financial data analysis syllabus with its theoretical concepts. Moreover, it motivates you to be more confident with daily tasks and gives you the edge over other candidates vying for a full-time position.People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.Take advantage of this opportunity to acquire the skills that will advance your career and get an edge over other candidates. Don't risk your future success.

Overview

Section 1: Course Introduction

Lecture 1 Course Introduction

Section 2: Excel Basics

Lecture 2 Launching Excel

Lecture 3 The Start Screen

Lecture 4 Exploring the Interface

Lecture 5 Getting Help

Lecture 6 Tabs, Ribbons and Menus

Lecture 7 The Quick Access Toolbar

Lecture 8 Backstage Area

Lecture 9 Workbooks and Worksheets

Lecture 10 Saving Workbooks

Lecture 11 Navigating and Selecting Cells, Rows and Columns

Lecture 12 Entering and Editing Data

Lecture 13 Applying Number Formats

Lecture 14 Applying Date and Time Formats

Lecture 15 Formatting Cells, Rows and Columns

Lecture 16 Format Painter

Lecture 17 Working with Rows and Columns

Lecture 18 Cut, Copy, & Paste

Lecture 19 Paste special

Lecture 20 Deleting and Clearing Cells

Lecture 21 Aligning Text and Numbers

Lecture 22 Introduction to formulas

Lecture 23 Understanding the order of operations

Lecture 24 Formula auditing with F2 and using F5 plus Enter

Lecture 25 Efficient data and formula entry

Lecture 26 Absolute and Relative cell referencing

Lecture 27 Excel's Golden rule

Lecture 28 Introduction to Excel Functions

Section 3: Useful tips and tricks

Lecture 29 Mixed cell referencing

Lecture 30 Circular references

Lecture 31 Text to columns

Lecture 32 Flash Fill

Lecture 33 AutoFill

Lecture 34 Creating drop-down lists with data validation

Lecture 35 Custom Sort

Lecture 36 Select Special

Lecture 37 Freeze panes

Lecture 38 Conditional Formatting

Lecture 39 Introduction to Custom Formatting

Lecture 40 Custom Formatting

Lecture 41 Hyperlinks

Lecture 42 Find and replace data and references

Lecture 43 Find and replace formatting

Lecture 44 Removing (automatic) green arrows

Lecture 45 Filter

Lecture 46 Creating dynamic names

Lecture 47 Named Ranges

Lecture 48 Set Print Area

Lecture 49 3D Formulas

Section 4: Keyboard Shortcuts

Lecture 50 Data Manipulation shortcuts

Lecture 51 Data Selection and Navigation shortcuts

Lecture 52 Formatting shortcuts

Lecture 53 Editing shortcuts

Lecture 54 File and Application Related shortcuts

Section 5: Excel's key Functions

Lecture 55 SUM Function and AutoSum

Lecture 56 AVERAGE Function

Lecture 57 COUNT Function and related functions

Lecture 58 MIN and MAX Functions

Lecture 59 LARGE and SMALL Functions

Lecture 60 RANK Function and New RANK Functions

Lecture 61 AGGREGATE Function

Lecture 62 ROUND Function

Lecture 63 INDEX Function

Lecture 64 MATCH Function

Lecture 65 XMATCH Function

Lecture 66 INDEX & MATCH combination

Lecture 67 PRODUCT & SUMPRODUCT Functions

Lecture 68 IF Function

Lecture 69 IFS Function

Lecture 70 CHOOSE Function

Lecture 71 SUMIF, AVERAGEIF and COUNTIF Functions

Lecture 72 SUMIFS, AVERAGEIFS, COUNTIFS, MINIFS and MAXIFS Functions

Lecture 73 Database Functions

Lecture 74 Error types and Error Functions

Lecture 75 Text Functions

Lecture 76 Date Functions

Lecture 77 VLOOKUP and HLOOKUP Functions

Lecture 78 XLOOKUP Function

Lecture 79 Formula Auditing

Section 6: Excel's key Functionalities

Lecture 80 Goal Seek

Lecture 81 Sensitivity analysis with Data Tables

Lecture 82 Creating Subtotals

Lecture 83 Tables

Lecture 84 Consolidate Command

Section 7: Financial Functions in Excel

Lecture 85 PV and other related financial functions

Lecture 86 NPV Function

Lecture 87 XNPV Function

Lecture 88 IRR Function

Lecture 89 XIRR Function

Lecture 90 MIRR Function

Lecture 91 Payback period

Lecture 92 Depreciation Functions

Section 8: Pivot Tables

Lecture 93 Introduction to Pivot Tables

Lecture 94 Creating Pivot Tables

Lecture 95 Formatting Pivot Tables

Lecture 96 Modifying and pivoting fields

Lecture 97 Slicers

Lecture 98 GETPIVOTDATA Function

Section 9: Excel Charts

Lecture 99 How to insert a chart

Lecture 100 Editing charts

Lecture 101 Chart formatting

Lecture 102 Doughnut charts

Lecture 103 Area Charts

Lecture 104 Area and Line Charts

Lecture 105 Column stacked chart with a secondary line axis

Lecture 106 Bullet Charts

Lecture 107 Gantt Charts

Lecture 108 Bridge charts

Lecture 109 Football Field Charts

Lecture 110 Treemap charts

Lecture 111 Sparklines

Section 10: Power Query

Lecture 112 Introduction to Power Query

Lecture 113 Power Query

Section 11: Power Pivot

Lecture 114 Introduction to Power Pivot

Lecture 115 Power Pivot

Section 12: Macro Recorder

Lecture 116 Introduction to Macros and the Macro Recorder

Lecture 117 Recording and running Macros

Section 13: Dynamic Array Functions

Lecture 118 Introduction to Dynamic Array Functions

Lecture 119 SORT Function

Lecture 120 SORTBY Function

Lecture 121 FILTER Function

Lecture 122 UNIQUE Function

Lecture 123 SEQUENCE Function

Lecture 124 RANDARRAY Function

• If you’re looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.,• Graduate students and professional accounting and finance qualification holders and students who aspire to become investment bankers, accountants, bankers, financial advisory professionals, consultants etc.,• Business and finance professionals who are eager to improve their Excel and Financial data analysis and modeling skills to progress further in their career