MICROSOFT EXCEL:

Microsoft Excel is the most widely used software within the business community. Whether it is bankers or accountants or business analysts or marketing professionals or scientists or entrepreneurs, almost all professionals use Excel on a consistent basis. So given how Excel is so widespread in workforce, it helps to be proficient at it. Having Excel skill set on your resume can greatly increase your employability.

WHAT IS FINANCIAL MODELING AND VALUATION ANALYSIS (FMVA)

The Most Important Skills required to become a world-class financial analyst include Finance, Accounting, Financial Modeling, Valuation, Forecasting, and strategy.

• Financial Analysis Fundamentals
• Building a Financial Model
• Business Valuation Model
• Budgeting and forecasting
• Forecast model
• Quantitative Forecasting – Moving average, Simple and multiple linear regression
• Variance analysis
• Budgeting Tools – Goal seek, solver, consolidation, pivot tables
• Scenarios and Sensitivity analysis
• Excel VBA for Finance
• Solver and Macros
• Advanced Financial Modeling and valuation
• Solver and Macros

MICROSOFT POWER BI:

Are you looking for new ways to find and visualize data and to share your discoveries? Power BI can help. This collection of tools and features from Microsoft transforms your company’s data into rich visuals for you to collect and organize, so you can spot trends, collaborate in new ways, and make sense of your data.

Microsoft Power BI allows end-users to store, analyze, and visualize big data. Learn these game-changing technologies to analyze huge business data with ease. This course is designed with a practical, easy-to-learn approach towards unleashing the clout of Microsoft Power BI.

Microsoft Power BI is making its mark in the self-service BI world—because it can quickly create visually stunning, interactive reports, and dashboards. Power BI provides a straight forward way to combine data from a wide range of sources into a single dataset, and then work with that data to create cohesive reports. The Self-Service BI trend is driven by Microsoft’s commitment to improving Excel and Power BI, both products having seen many enhancements over recent years.

MASTER DATA ANALYTICS WITH THIS MASTERING IN EXCEL & POWER BI COURSE BUNDLE

Microsoft Power BI is one of the most widely used Business intelligence and data analytics platforms in the world. Power BI is cloud-based and delivered on the Azure Cloud. On-perm capabilities also exist for individual users or when power users are authoring complex data smashups using in-house data sources. Power BI is unique because it enables users to do data preparation, data discovery, and dashboards with the same design tool. The platform integrates with Excel and has a very active user community that extends the tool’s capabilities. With this in mind, we’ve compiled this list of the best Power BI training and courses to consider if you’re looking to grow your data analytics skills for work or career advancement.

In this course, you will learn why Power BI offers you a comprehensive set of business intelligence tools for your data analysis goals. Imagine being able to quickly structure your data, easily add calculations to it, and create and publish nice-looking charts in just a few minutes.

You’ll start out by seeing how you can quickly and easily gather data from a variety of sources, and then cleanse and transform that data with just a few clicks. Next, you’ll also learn how you can enhance the results by integrating disparate data sources and adding simple calculations. Then, you’ll learn how to explore your data with visualizations and simple dashboards. Finally, you’ll learn what steps are necessary to keep your data up-to-date.

Effective Reporting with Power BI, you will learn knowledge for creating effective and engaging reports. First, you will learn how to integrate basic visualizations into a report. Next, you will discover how to enhance the visualizations to build compelling reports. Finally, you will explore how to create interactive reports and dashboards. When you’re finished with this course, you will have the skills and knowledge in Power BI needed to communicate data stories through clear and compelling visualizations.

You’ll go from zero to hero, as you discover how to use this popular business intelligence platform through hands-on exercises. You’ll first learn how to confidently load and transform data using Power Query and the importance of data models, before diving into creating visualizations using Power BI’s drag-and-drop functionality. You’ll also learn how to drill down into reports and make your reports fully interactive.

Power BI Desktop is a free business intelligence application from Microsoft that lets you load, transform, and visualize data. You can create interactive reports and dashboards quite easily, and quickly. We will learn Power BI by importing, transforming, and visualizing the data.

Power BI and Excel Combination is perfect for professionals. You’ll become confident in working with data, creating data visualizations, and preparing reports and dashboards. The good news is that data wranglers have access to more tools than ever. In this golden age of information, it’s a small wonder that Microsoft Excel has evolved from a boring spreadsheet program to an essential tool for handling big data. And now there’s Power BI, a business analytics platform that gives users even more options.

MASTERING IN EXCEL FINANCIAL

FINANCIAL MODELING & VALUATION ANALYSIS (FMVA) PROGRAM

• MASTER FEATURES Using Array Formulas, Working with Named Ranges, Using Multi-sheet Formulas, Using Advanced Filters, Data Validation & Protection, Consolidation & List Management, Automating with Macros, VBA Coding, Using Form Controls, Macro Recorder versus VBA, Using Subtotal, Conditional Formatting, Using Advanced Filter, Pivot Table, Using Conditional Formatting Advanced, Consolidation, Data Validation Simple, Data Validation Advanced, Using Linking, Auditing, Transpose, Managing External Data Connections
• MASTER FUNCTIONS Sum, Average, Maximum, Minimum, Large, Small, Count, Count,  Count blank, Today, Now, Hour, Minute, Second, Rept, Dollar, Exact, Upper, Lower, Proper, Replace, Roman, Address, Cell, Sumproduct, Trim, Mean, Median, Mode, Rank, Concatenate, Averagea, Days360, Datedif, Choose, Indirect,
• IF CONDITIONS Simple If, Nested If, If With And, If With Or, Countif, Sumif, Sumif Advanced, Countif Advanced, LOOKUP FUNCTIONS Vlookup With Commission, Vlookup With Account Number, Vlookup With Customer Comparison, Hlookup With Commission, Hlookup With Monthly Sales, Multiple Vlookup, Match & Index, DATABASE FUNCTIONSDSUM, DAVERAGE, DMAX, DAMIN, DCOUNT, FINANCIAL FUNCTIONSPMT, PV, NPER , RATE, FV, PPMT, IPMT, NPV, DDB, SLN, SYD, DB, D FUNCTIONS,  ARRAY FUNCTIONS, ACCOUNTING FUNCTIONS, TEXT FUNCTIONS, COMPLEX EXCEL FUNCTIONS,
• MASTER REPORTING & BI IN EXCEL Data Analyzing, Business Intelligence, Business Modeling Stats, Business Reporting with Pivot Tables, Working with Slicers, Advanced Charting and visualizations, Using Quick Charts Dynamic Charts Spark line Charts, Creating Interactive Dashboard Reports, and Using Power View & Power Pivot Features
• MASTER FINANCIAL MODELING Attendance Register – Electricity Bills – Textile Company Sales & Commission – Car Loan Calculator With Macros – Invoice With Vlookup – Macros – Goal Seek – Match & Index (Advanced) – If With Other Functions – Creation Of General Journal – Creation Of Trial Balance – Creation Of Income Statement–Sales Report, Payroll sheet, Creation Of Sales Invoice With Sales Tax–Loan Payment Calculator With VBA Macros–Loan amortization schedule, SumIfs – Solver & Scenario – Data Table With PMT “4 Approaches”- Loan Amortization Table – Simple Way Of Debit & Credit – VBA Macros, Currency Rate Calculator – Create Custom Excel Functions

COURSE CONTENTS:

INTRODUCTION TO MS-EXCEL

• Why MS Excel Is Used?
• What Is Spreadsheet?
• What Are Rows, Columns And Cells?

BASIC FORMULAS

Sum, Average, Maximum, Minimum, Large, Small, Count, Counta, Countblank, Today, Now, Hour, Minute, Second, Rept, Dollar, Exact, Upper, Lower, Proper, Replace, Roman, Address, Cell, Sumproduct, Trim, Mean, Median, Mode Etc….

IF CONDITIONS

• Simple If
• Nested If
• If With And
• If With Or
• Countif
• Sumif
• Sumif Advanced
• Countif Advanced
• Payroll sheet

LOOKUP FUNCTIONS

• Vlookup With Commission
• Vlookup With Account Number
• Vlookup With Customer Comparison
• Hlookup With Commission
• Hlookup With Monthly Sales
• Multiple Vlookup
• Match & Index (Simple)

ADVANCED COMMANDS

• Charts/Graphs
• Auto Filter
• Sorting
• Subtotal
• Conditional Formatting Simple

MORE ADVANCED COMMANDS

• Advanced Filter
• Pivot Table
• Conditional Formatting Advanced
• Consolidation

DATABASE FUNCTIONS:

• DSUM
• DAVERAGE
• DMAX
• DAMIN
• DCOUNT

OTHER VALUABLE FUNCTIONS

• Rank, Concatenate, Averagea
• Days360, Datedif, Choose, Indirect

FINANCIAL FUNCTIONS

• PMT, PV , NPER , RATE
• FV, PPMT, IPMT, NPV
• DDB, SLN, SYD, DB

MORE VALUABLE TOPICS

• Data Validation Simple
• Data Validation Advanced
• Auto Fills / Flash Fill / Custom Lists
• Text To Column
• MS Excel Linking With MS Word
• Protecting Worksheet
• Paste Special
• Cell Comment
• Auditing
• Freeze Panes
• Transpose
• Working with Excel Addins
• Printing Options

FINANCIAL PROJECTS

• Macros
• Automating with Macros
• Writing Customized Macros
• VBA Coding
• Using Form Controls
• Goal Seek
• Match & Index (Advanced)
• Currency Rate Calculator
• If With Other Functions
• Creation Of General Journal
• Creation Of Trial Balance
• Creation Of Income Statement
• Creation Of Sales Invoice With Sales Tax
• Loan Calculator With VBA Macros
• Sum IFS
• Solver & Scenario
• Data Table With PMT “3 Approaches”
• Data Table With PV “3 Approaches”
• Loan Amortization Table
• Simple Way Of Debit & Credit
• Saving Certificate
• Attendance Register
• Electricity Bills
• Textile Company Sales & Commission
• how to write custom VBA
• Complete real-world Macro/VBA projects from beginning to end
• Car Loan Calculator With Macros
• Invoice With Vlookup
• Dynamic Graphs Connected With Financial Models
• Creating Interactive Dashboards using Form Controls
• Create Custom Excel Functions
• Cricket Match Forecasting Project
• And many more…

MASTERING IN MICROSOFT POWER BI

CLEAN & AUTOMATE | ANALYZE | VISUALIZE

COURSE CONTENTS:

INTRODUCING POWER BI TOOLS

• Excel vs. Power BI Desktop & Service
• Power BI Key Features
• The Self-Service BI Model

USING POWER QUERY

• Editing Quires
• Data Types
• Fix Dates
• Columns – Move, Remove, Rename & Duplicate
• Splitting Column
• Merging Column
• Filtering Rows
• Removing Duplicates and Errors
• Sorting
• Transforming Data with Power Query
• Getting Data with External Sources
• Merging & Appending Queries
• Visualizing Data with Power View
• Color Formatting
• Setting Sort Order
• Types of Charts & Play with Axis
• Tooltips
• Slicer & Timeline Slicers
• Cross Filtering & Highlighting
• Visual, Page & Report Level Filters
• Drill Down/Up
• Hierarchies
• Reference/Constant Lines

MODELING DATA WITH POWER PIVOT

• Introduction to Modeling
• Setup and Manage Relationships
• Analyzing Big Data Using Power Pivot
• Creating Calculated Columns
• Creating Measures & KPIs
• Custom Visuals
• Managing & Arranging

POWER VIEW FOR EXCEL

• Creating Power View Reports
• Understanding Table Visualizations
• Chart Visualizations

POWER MAP

• Plotting Spatial Data Over Power Map
• Formatting & Customizing Map
• Creating Power Map

APPENDING DATA FROM DIFFERENT WORKSHEETS

• Merging Databases from Different Sources
• Replace & Fill
• Transforming Text & Numbers
• Transforming Dates
• Adding Custom Calculated Columns

POWER BI DESKTOP

• Creating Charts Visualizations
• Tables, Matrices, Gauges, KPI’s & Cards
• Slicers & Timeline Slicers
• Scatter & Bubble Charts & Play Axis
• Drill Down/Up Charts
• Creating Power View Reports
• Power View Interface Components
• Understanding Table Visualizations

TOOLS & TERMINOLOGY

• Dashboard in Minutes
• Refreshing Power BI Service Data
• Interacting with your Dashboards
• Sharing Dashboards and Reports