Excel

Master Excel Like a Pro: From Basics to Advanced Techniques

Hi, I'm Ankit Khatri, a Director with over 15 years of experience in capital markets and technology. I specialize in the valuation of fixed income securities, automation, and data visualization using powerful tools like Excel, SQL, Power BI, Tableau, Jaspersoft, and Python. I am passionate about sharing my knowledge and training both students and professionals to help them gain the skills needed to land their dream jobs.

Are you ready to elevate your Excel skills to the next level? Whether you're a beginner or looking to master advanced Excel functionalities, I’m here to guide you through an in-depth exploration of Excel’s powerful features. Here's what you'll uncover in my comprehensive Excel walkthrough:

Excel Basics

1. Understanding Excel's use and scope
2. Columns, rows, cells & ranges fundamentals
3. Different types of data in Excel
4. Mastering Autofill & Flash Fill for efficiency
5. Essential shortcut & hotkeys
6. Data formatting & alignment techniques
7. How to remove duplicates effortlessly
8. Utilizing different views & reviews
9. Differences between comments & notes
10. Merge & wrap text functions
11. Sorting & filtering data like a pro
12. Splitting text into columns

Advanced Data Sorting, Formatting & Validation

1. Custom formatting for unique data sets
2. Applying conditional formatting
3. Data validation to ensure accuracy.

Functions & Formulas

Enhance your data analysis skills with powerful functions and formulas:

1. Logical Functions: AND, OR, NOT, IF, IFERROR, IFS, LAMBDA
2. Text Functions: CONCATENATE, CONCAT, TEXTJOIN, FIND, SEARCH, SUBSTITUTE, LEN, LEFT, RIGHT, MID, LOWER, UPPER, PROPER, TRIM, TEXTSPLIT
3. Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP, ROW, OFFSET, MATCH, INDEX, INDEX-MATCH, INDIRECT
4. Mathematical Functions: SUM, AVG, COUNT, COUNTA, COUNTBLANK, SUBTOTAL, CEILING, FLOOR, ROUND, SUMIF, SUMIFS, SUMPRODUCT, COUNTIF, COUNTIFS, MIN, MAX, LARGE, SMALL, RANK
5. Information Functions: ISERROR, ISEVEN, ISTEXT, ISODD
6. Evaluating formulas and error-checking mechanisms

Data Visualization & Reporting

Transform your data into insightful visuals with advanced charting techniques:

1. Creating and formatting charts: Column, Bar, Pie, Line, Combo, Scatterplot, Funnel, Waterfall
2. Mastering pivot tables and pivot charts

Imagine becoming so proficient in Excel that you can automate tasks, create dynamic dashboards, and visualize data effortlessly. With my expert guidance, that's exactly what you'll achieve. Start your journey towards Excel mastery today and take control of your data like never before.

Why hesitate? Embark on this learning adventure now and unlock the full potential of Excel.