Lavdeep Sharma Excel,Power Bi Expert-Power BI Consultant in Adobe
7 Reviews

Hi, I'm Lavdeep Sharma, a Senior Power BI Dev @ Adobe Ex-Info Edge | Microsoft Certified BI Consultant & 𝗖𝗵𝗶𝗲𝗳 𝗠𝗲𝗻𝘁𝗼𝗿 𝗮𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝘁𝗺𝗮𝘁𝗲 𝗔𝗰𝗮𝗱𝗲𝗺𝘆 ⚡ Certified in Microsoft Power BI, Power Platform, Azure, SQL, and Excel.

𝑴𝙞𝒄𝙧𝒐𝙨𝒐𝙛𝒕 𝑪𝙚𝒓𝙩𝒊𝙛𝒊𝙚𝒅 𝑷𝙤𝒘𝙚𝒓 𝑷𝙡𝒂𝙩𝒇𝙤𝒓𝙢 𝙎𝒐𝙡𝒖𝙩𝒊𝙤𝒏 𝑨𝙧𝒄𝙝𝒊𝙩𝒆𝙘𝒕 (PL-600), 𝑷𝙤𝒘𝙚𝒓 𝑩𝙄 𝘿𝒂𝙩𝒂 𝑨𝙣𝒂𝙡𝒚𝙨𝒕 (PL-300),𝑨𝙯𝒖𝙧𝒆 𝑫𝙖𝒕𝙖 𝙀𝒏𝙜𝒊𝙣𝒆𝙚𝒓 𝑨𝙨𝒔𝙤𝒄𝙞𝒂𝙩𝒆 (DP-203) and 𝑴𝙞𝒄𝙧𝒐𝙨𝒐𝙛𝒕 𝒐𝙛𝒇𝙞𝒄𝙚 𝙨𝒑𝙚𝒄𝙞𝒂𝙡𝒊𝙨𝒕 𝑬𝙭𝒄𝙚𝒍 (MOS).

Analystmate Academy has been recognized as a top institute for Excel and Power BI training in Noida, Greater Noida, and Delhi NCR by various platforms.

Trusted by Students: Ranked #1 Excel instructor on Takelessons.com with 41+ 5-star reviews.
#1 Ranked & Highly Rated Power BI Teacher - 63+ 5-Star Reviews on Superprof.

9 years of industry exposure in Data Science, Data Analytics, Data Analysis, Business intelligence & data visualization.In addition to being a 𝙋𝒐𝙬𝒆𝙧 𝘽𝑰 𝑫𝙚𝒗𝙚𝒍𝙤𝒑𝙚𝒓, I have also worked as a 𝘿𝒂𝙩𝒂 𝑨𝙣𝒂𝙡𝒚𝙨𝒕, 𝙈𝑰𝙎 𝙀𝒙𝙚𝒄𝙪𝒕𝙞𝒗𝙚, 𝑩𝙪𝒔𝙞𝒏𝙚𝒔𝙨 𝘼𝒏𝙖𝒍𝙮𝒔𝙩 𝙖𝒏𝙙 𝘿𝒂𝙩𝒂 𝑬𝙣𝒈𝙞𝒏𝙚𝒆𝙧.

Worked for Top corporates like 𝑨𝙙𝒐𝙗𝒆, 𝙄𝒏𝙛𝒐 𝑬𝙙𝒈𝙚 (𝑵𝙖𝒖𝙠𝒓𝙞 & 99 𝑨𝙘𝒓𝙚𝒔), 𝑴𝙖𝒏𝙠𝒊𝙣𝒅 𝑷𝙝𝒂𝙧𝒎𝙖, 𝑻𝙖𝒕𝙖 𝙏𝒆𝙡𝒆𝙘𝒐𝙢 𝙖𝒏𝙙 𝘾𝒉𝙧𝒐𝙢𝒆 𝑫𝙖𝒕𝙖 𝘼𝒏𝙖𝒍𝙮𝒕𝙞𝒄𝙨 & 𝙈𝒆𝙙𝒊𝙖 .

I am the 𝗖𝗵𝗶𝗲𝗳 𝗠𝗲𝗻𝘁𝗼𝗿 𝗮𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝘁𝗺𝗮𝘁𝗲 𝗔𝗰𝗮𝗱𝗲𝗺𝘆, an online data analytics training institute, and also a YouTuber with over 2𝑲+ 𝙨𝒖𝙗𝒔𝙘𝒓𝙞𝒃𝙚𝒓𝙨. We create videos focusing on technical content related to Excel and Power BI.

Fueling data enthusiasts! I dedicate my 𝒘𝙚𝒆𝙠𝒆𝙣𝒅𝙨 𝙩𝒐 𝒄𝙤𝒏𝙙𝒖𝙘𝒕𝙞𝒏𝙜 𝙤𝒏𝙡𝒊𝙣𝒆 𝑷𝙤𝒘𝙚𝒓 𝑩𝙄 & 𝙀𝒙𝙘𝒆𝙡 𝙩𝒓𝙖𝒊𝙣𝒊𝙣𝒈 sessions, sharing my love for data analysis.

𝑷𝙤𝒘𝙚𝒓 𝑩𝙄 𝙀𝒙𝙥𝒆𝙧𝒕𝙞𝒔𝙚: I am well-versed in Power BI, demonstrating proficiency in Power BI Desktop, DAX, Power Query, and Power BI Service

𝙎𝑸𝙇 𝙋𝒓𝙤𝒇𝙞𝒄𝙞𝒆𝙣𝒄𝙮: I have in-depth expertise in SQL, leveraging it for efficient data retrieval, manipulation, and analysis

𝘾𝒍𝙤𝒖𝙙 𝙋𝒓𝙤𝒇𝙞𝒄𝙞𝒆𝙣𝒄𝙮: I have hands-on experience with the Microsoft Azure Platform, specifically in Data Lake, Data Factory, Databricks, Data Warehouse.

𝘼𝒖𝙩𝒐𝙢𝒂𝙩𝒊𝙤𝒏 𝒂𝙣𝒅 𝑨𝙥𝒑 𝑫𝙚𝒗𝙚𝒍𝙤𝒑𝙢𝒆𝙣𝒕: I am adept at designing and developing Power Automate flows, PowerApps, Canvas App, Model Driven App, and Portals

Ready to level up your data game? 𝑱𝙤𝒊𝙣 𝙢𝒆 𝒇𝙤𝒓 𝒎𝙮 𝙤𝒏𝙡𝒊𝙣𝒆 𝑷𝙤𝒘𝙚𝒓 𝑩𝙄 & 𝙀𝒙𝙘𝒆𝙡 𝙬𝒐𝙧𝒌𝙨𝒉𝙤𝒑𝙨

Subjects

Excel Expert
Power BI Expert
DAX Expert
Advanced Excel (With formula and macro) Expert
Power BI dashboard Expert
Microsoft Power BI Expert
Basic & Advanced Excel Expert
Data analysis and visualization Expert
Excel charts Expert
Power Query Expert
Power pivot Expert
Business Data Analytics Expert
Google Apps Script Expert
Power App Expert
Advanced Excel and Macros Expert
Excel Advanced Expert
Power Automate Expert
Excel training Expert
Interview Preparation for Data Science Expert
Analystmate Expert

Experience

Senior Power BI Developer (Jan, 2022–Present) at Adobe Systems India Pvt Ltd, Noida
Senior Data Analyst (Jun, 2019–Jun, 2022) at Info Edge India Limited (Naukri.com and 99 Acres .com)
Senior Assistant (Aug, 2018–Jul, 2019) at Mankind Pharma Limited
Data Analyst (Sep, 2017–Jul, 2018) at Chrome Data Analytics & Media
Data Analyst (Jul, 2016–Sep, 2017) at Tata teleservices limited,
Excel Trainer (Jan, 2015–Jul, 2016) at Analystmate

Education

Data Analysis using Excel (Dec, 2020–Dec, 2021) from MIcrosoft Corporation
Predictive Analytics (Jun, 2020–Jun, 2020) from Indian Institute of Management Bangalore (IIM Bangalore)
SQL for Data Science (Jan, 2020–Jun, 2020) from University of California, Davis
The Data Scientist’s Toolbox (Jan, 2020–Dec, 2020) from University of California, Davis
Analyzing and Visualizing Data with Power BI (Dec, 2019–Dec, 2019) from MIcrosoft Corporation
Microsoft Office Specialist Excel (Dec, 2017–Nov, 2018) from MIcrosoft Corporation
MCA (Dec, 2016–Nov, 2019) from Swami Vivekananda Shubharti University Meerut
Bsc (Jul, 2013–Dec, 2015) from Dr Br ambedekar university

Fee details

₹500–1,500/hour (US$5.99–17.96/hour)

Industry Level Advanced Excel Training, INR 7000, 4 Months 40 hours (Weekend Batch in Hindi)
Power BI Essentials : Basic to Advanced, INR 10000 4 Months 60 hours (Weekend Batch in Hindi)

Courses offered

Advanced Excel for Data Analytics (Sun 8 - 10 PM) New Batch Start on 23 March (Hindi)
- INR10000
- Duration: 24 days 40 hours'
- Delivery mode: Online
- Group size: 21 - 40
- Instruction language: Hindi
- Certificate provided: Yes
Here's what you'll get in this Course
1. 45+ hours of Online live classes (Also provide class recording to students)
2. 150 + quizzes and 100+ Excel assignments and practice files.
3. Personalized doubt clearing session and Certificate of completion.
4. Mock interviews with industry experts
5. ATS-compliant resumes and profile optimization for job market visibility.

Training Timings : Sunday 01:00 AM - 03:00 PM
Schedule: 2 hours
Format: Live Online with Recording

Course Fee Details:
Original Fee: Rs.10,000
Early Enrollment Discount: 30%
Total Fee After Discount: Rs.7,000
Excel Pivot Table Mastery: Unlock the Power of Your Data
- INR3000
- Duration: 2 days 5 hours (Sat & Sun)
- Delivery mode: Online
- Group size: 6 - 10
- Instruction language: English, Hindi, Urdu
- Certificate provided: No
"Excel Pivot Table Mastery: Unlock the Power of Your Data" is an advanced-level training course designed to help professionals and students take their Excel skills to the next level. The course will guide participants through the process of creating, manipulating, and analyzing data using pivot tables in Microsoft Excel.

The course will start by introducing the basics of pivot tables, including how to create and format a pivot table, and how to manipulate the data within a pivot table to gain insights into the data. The course will then dive into more advanced topics such as calculated fields, calculated items, and pivot table options, as well as the use of pivot charts and pivot tables in real-world applications.

In addition to hands-on, step-by-step training, participants will also receive tips and tricks for using pivot tables more effectively, and will have the opportunity to practice their skills through interactive exercises and real-world examples.

By the end of the course, participants will be able to create pivot tables with ease, perform data analysis on large sets of data, and make informed decisions based on their findings. They will also have a deep understanding of the various features and functionalities of pivot tables in Excel, and will be equipped with the skills and confidence to take their data analysis to the next level.

💡 Pivot Table for Infants - View your Treatments
💡 Pivot Report Layout - Meet your Clinic
💡 Changing Indent Level in Compact View
💡 Pivot Table Dynamic Range
💡 Working on Classic Pivot Table
💡 Walkthrough Pivot Table Reports and Calculations
💡 Counting Distinct Records
💡 Customize Report Filter Area
💡 Handling Blank Cells in Pivot Table
💡 Preserving Formatting and Column Widths on Refresh
💡 Merging Labels in Pivot Table
💡 Refreshing Pivot Table - The Manual Approach
💡 Refreshing Pivot Table - The Permanent Treatment
💡 Working on Slabs
💡 Create New Column missing in Data - The Pain Giver
💡 Customized Sorting in Pivot Table
💡 Move Values to ROW - The Magical Transpose
💡 Pivot Table Custom SUBTOTAL - ABRACADABRA
💡 Pivot Table from Multiple Tables
💡 Handling Large Data - The Secret Mission
💡 Changing Multiple Filter in a Click
💡 Exploring Slicers and Timelines
💡 Removing Source Data - OOPS Moment
💡 Pivot Table Formulas - Calculated Field
💡 Working with Named Sets - No If, No But, Only Pivot
💡 Lookup Data from Pivot Table - The GETPIVOTDATA
💡 Consolidate Data from Multiple Worksheets
💡 Split Data into Multiple Worksheets - Vaccination for Lazy People
💡 Working on Dynamic Dashboards
💡 Create Customized View - OMG Format
💡 Challenges in Pivot Table - What Next?
Mastering Excel Lookup Formulas: From Beginner to Pro
- INR2000
- Duration: 4 Hours in 2 days ( Sat & Sun)
- Delivery mode: Online
- Group size: 6 - 10
- Instruction language: English, Hindi
- Certificate provided: No
"Mastering Excel Lookup Formulas: From Beginner to Pro" is a comprehensive training course that will teach participants the essential skills for working with lookup formulas in Microsoft Excel. The course is designed for individuals who are new to lookup formulas, as well as those who have some experience and are looking to expand their knowledge.

The course will start with the basics of lookup formulas, including the different types of lookup formulas such as VLOOKUP, HLOOKUP, INDEX, and MATCH. Participants will learn how to use these formulas to find data within a worksheet, as well as how to return data from multiple worksheets. The course will then dive into more advanced topics such as combining lookup formulas with other functions, working with dynamic ranges, and troubleshooting common lookup formula errors.

In addition to hands-on, step-by-step training, participants will also receive tips and tricks for using lookup formulas more effectively, and will have the opportunity to practice their skills through interactive exercises and real-world examples.

By the end of the course, participants will have a solid understanding of lookup formulas and will be able to confidently use them to find and return data within their worksheets. They will also have the skills and knowledge needed to perform more complex data analysis and reporting using lookup formulas.

💡 Introduction to Excel Lookup
💡 Core functions - VLOOKUP, HLOOKUP, LOOKUP, INDEX, MATCH, CHOOSE, TEXTJOIN
💡 The Magical XLOOKUP
💡 The Dynamic FILTER Function
💡 Lookup All records
💡 Lookup nth records
💡 Case Sensitive Lookup
💡 Lookup from Image
💡 Lookup first integer
💡 Lookup text
💡 Index with multiple Range
💡 The magical MATCH-INDEX
💡 Reverse Lookup
💡 Integrating Lookup with Arrays
💡 Lookup from Multiple tables
💡 Lookup from Pivot Table
💡 VLOOKUP with OFFSET
💡 VLOOKUP with CHOOSE
💡 Using ROW and COLUMN function in LOOKUP
💡 The magical ADDRESS - INDIRECT
💡 VLOOKUP without Source Table
💡 Dealing with Dynamic Range in LOOKUP
💡 Fetching data based on multiple condition
💡 Fetching data based on dynamic range
💡 Lookup from Multiple Sheets
💡 Name Management in Lookup
💡 Working with Complex Lookup

Message Phone

Pay Review

- Noida, Uttar Pradesh, India
- Can travel: No
Last login: Apr 22
Registered: Dec 1, 2021
Total Teaching exp: 9.0 yrs.
Teaches online: Yes
Online Teaching exp: 9.0 yrs.
Teaches at student's home: No
Homework Help: Yes
Gender: Male
Works as: Individual teacher
Fee:

₹500–1,500/hour
(USD 5.99–17.96/hour)

7 Reviews

5 out of 5

Sanjay Kapoor February 20, 2022

Payment verified US$ 3.60 (300 INR)

Best Teacher

Great learning experience. Initially had no idea how PowerBI worked, but now feel confident in preparing and presenting reports at work. Lavdeep did an excellent job explaining everything, giving insightful thoughts and pro tips throughout the course, and he had a very pleasant attitude.
I searched many teachers, websites, and other sources before I found this website

In closing, I greatly appreciate your guidance. Thanks

Pragati Mishra January 20, 2022

Payment verified US$ 12 (1000 INR)

Excel Guru

Lavdeep has saved me many times by helping me to solve my office work-related Excel formula queries. He did a great job, was quick to respond, and helpful.

Aman gupta January 19, 2022

Payment verified US$ 12 (1000 INR)

Excel Formula Expert

I had reached out to many so-called Excel Experts on Teacheron but was unable to find the solution. Finally, I found Lavdeep’s profile on Teacheron he take only 10 min to solve my excel formula issue.
Great job.

Prafull pandey January 19, 2022

Payment verified US$ 12 (1000 INR)

A truly amazing teacher is hard to find

I was stuck on my job project and it was important for me to complete it on time. I reached out to lavdeep through Teacheron, I was surprised to get the right solution within hours from Lavdeep.
I am very happy, I found a platform where I can come up with my work-related problems. Thanks, Lavdeep and Teacheron

Rohini Goyal December 20, 2021

Payment verified US$ 3.60 (300 INR)

Best Teacher for Advanced Excel

Lavdeep is the most analytic mind . I couldn’t think about a better person for Business Intelligence analysis or complex development projects designing.
He was always ready to answer to our requests and to provide an immediate solution. He's also a very good teacher able to deliver his lessons in a logic, understandable and interesting way.
I learned a great deal from his content and approach to problem solving. I would highly recommend him and wish him all the very best for his future endeavors

Azam Khan December 19, 2021

Payment verified US$ 6 (500 INR)

Data ninja & Excel expert and Dedicated , humble and a confident person

First of all,i would like to say thanks to lavdeep kumar for make me proficient in Microsoft Excel 2019,
It was a really nice way to learn the basics and advance about Microsoft Excel & Power BI Desktop and this session gave me
the tools to understand how to use it for my professional reports,
In one hour, I am glad to have seen how Microsoft Excel & Power BI expands upon the pivot table functionality in Excel, i.e the filled shapes and cards
functionality. Overall, I would recommend this to someone who is learning Power BI & Microsoft Excel as well so they have another Microsoft tool under their skill set .

Deepali Sharma December 13, 2021

Payment verified US$ 3.59 (300 INR)

Fantastic mentor and trainer if you want to get good at Excel

Fantastic mentor and trainer if you want to get good at Excel

Lavdeep Sharma Excel,Power Bi Expert-Power BI Consultant in Adobe 7 Reviews

Subjects

Excel Expert

Power BI Expert

DAX Expert

Advanced Excel (With formula and macro) Expert

Power BI dashboard Expert

Microsoft Power BI Expert

Basic & Advanced Excel Expert

Data analysis and visualization Expert

Excel charts Expert

Power Query Expert

Power pivot Expert

Business Data Analytics Expert

Google Apps Script Expert

Power App Expert

Advanced Excel and Macros Expert

Excel Advanced Expert

Power Automate Expert

Excel training Expert

Interview Preparation for Data Science Expert

Analystmate Expert

Experience

Education

Fee details

Courses offered

Advanced Excel for Data Analytics (Sun 8 - 10 PM) New Batch Start on 23 March (Hindi)

Excel Pivot Table Mastery: Unlock the Power of Your Data

Mastering Excel Lookup Formulas: From Beginner to Pro

7 Reviews 5 out of 5

Lavdeep Sharma Excel,Power Bi Expert-Power BI Consultant in Adobe
7 Reviews

7 Reviews

5 out of 5