MBA Excel

Hi I would like to know the topics which one need to have capabilities that are most important to being good at Excel?

[Rajkumar Agarwal]

The larger part of individuals who are better than average at Microsoft Excel will let you know that they picked up their insight essentially through experience.

the procedure of concocting an Excel arrangement was what truly settled the establishment of the Excel information and also general trust in spreadsheets.

Books like John Walkenbach's Excel Bible are complete and truly extraordinary from that point of view, however the association of the book peruses like a lexicon and it acts more as a source of perspective aide than a real lesson arrangement.

Recorded underneath are the abilities that are most essential to being great at Excel:

Database Theory
Visual Design
Model Building
Formula Writing
Excel Analysis
Error Checking
Excel Shortcuts
File Administration
VBA
Arrays
Database Theory

How to Use VLOOKUP
How to Use HLOOKUP
How to Use INDEX MATCH
How to Use VLOOKUP MATCH
How to Use INDEX MATCH MATCH
How to Use OFFSET MATCH MATCH
How to Use VLOOKUP HLOOKUP
Why INDEX MATCH is Better Than VLOOKUP
How to Use Pivot Table
How to Use Pivot Charts
Primary Key Creation
Troubleshooting your Lookup Formula
Visual Design

Three Key Principles of Visual Design in Excel
How to Make Your Excel Bar Chart Look Better
How to Make Your Excel Line Chart Look Better
Excel Visual Design Tricks
How to Add Selective Highlighting to Your Excel Chart Background
How to Use Excel Custom Number Formatting
How to Paste Excel Chart Formatting
Model Building

How to Build an Excel Model: Key Principles
How to Build an Excel Model: Tab Structure
How to Build an Excel Model: Step by Step
MBA Excel Sample Model
Business Case Template
Linked Balance Sheet, Cash Flow, and Income Statement
Pricing Model Template
Homework Tracking Template
Recruiting Template
Project Management Template
Formula Writing

Excel Criteria Statements
Nested IF Statements
Excel Analysis

Distribution Analysis
Regression Analysis
Optimization Analysis: How to Use Excel Solver
Simulation Analysis: How to Run a Simulation in Excel
Sensitivity Analysis
Error Checking

How to Remove Duplicate Values in Excel
How to look for Duplicates
The Eight Things You Should Always Check Whenever You Receive an Excel File
Top 3 Reasons VLOOKUP is Not Working
Top Mistakes Made When Using INDEX MATCH
Why You Should Be Cautious About Using Excel’s IFERROR Formula
Shortcuts

The Eight Most Impactful Excel Shortcuts
File Administration

How to work on a file together
How to Lock Cells
VBA

How to Learn VBA for Excel
Arrays

Most Useful Excel Arrays