About us Why us Book Online Counselling +91 9818845002
shape shape

Advanced Excel

  • Lookup, logical, text, date and array formulas with real office data
  • Pivot Tables, Pivot Charts and MIS reports (MTD, QTD, YTD)
  • Build a working sales dashboard with form controls and named ranges
  • Classroom in Delhi, Gurgaon and Ghaziabad, or live online, with placement assistance
Formulas, Pivot Tables, MIS reports and dashboards. The Excel work most office jobs ask for.
Duration 30 – 45 Hours
Mode Classroom / Live Online
EMI Starts at ₹1,500/month No Cost EMI · Bajaj Finance
Language English & Hindi

About the Advanced Excel Course

Most people can add a SUM or an IF to a sheet. Jobs in MIS, accounts, sales operations and data analysis need more than that. You need to pull values from another sheet with INDEX-MATCH, summarise 50,000 rows with a Pivot Table, and send your manager a report that updates itself every month.

This course covers that work. You practise on sales, HR and accounts data, and you finish with a dynamic dashboard of your own. Choose the 30-hour course for strong Excel skills, or the 45-hour package if you also want VBA macros, Power Query and AI help inside Excel.

Why Advanced Excel

Excel is still the first tool checked in interviews for MIS executive, accounts, back-office, sales coordinator and junior data analyst roles. Interviewers usually give a small test: a VLOOKUP across two sheets, a Pivot summary by month, or a quick chart. This course prepares you for exactly that kind of test.

What you will be able to do

  • Clean messy data: remove duplicates, split names with Text to Columns, fix dates
  • Match data between two files with VLOOKUP, HLOOKUP and INDEX-MATCH
  • Make monthly, quarterly and year-to-date reports with Pivot Tables
  • Build a dashboard with dropdowns and charts that change when you select a region or month
  • Protect sheets before you send them to a client or manager

Who teaches it

Trainers at F1 Macro Technologies have worked as MIS executives, data analysts and accountants. They teach with the same kind of sheets you will see at work, not textbook examples.

Prerequisite: Basic computer use. You do not need any earlier Excel knowledge for Package 1.

Want Excel plus Power BI and SQL? See the full Data Analytics with AI programme.

In Class Room on Our Study Centres
In Class Room on Our Study Centres
Online Live Class with Innovative Content
Online Live Class with Innovative Content
Self E - Learning Through Our LMS
Self E - Learning Through Our LMS
One to One Online Live Sessions
One to One Online Live Sessions

Advanced Excel Course Modules

Workbook, worksheet, range and cell structure. Excel Options, Quick Access Toolbar, Paste Special, Freeze Panes, Text to Columns, and absolute, mixed and relative references.

Practice: Set up a clean monthly expense sheet with locked headers and correct references.

SUM, SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, COUNTBLANK, ROUND, ROUNDUP, ROUNDDOWN, ISTEXT, ISBLANK, ISERROR, ISNUMBER, CELL, DATEDIF and arithmetic, logical and conditional operators.

Practice: Branch-wise sales summary using SUMIFS and COUNTIFS.

LEFT, RIGHT, MID, LEN, FIND, SEARCH, REPLACE, SUBSTITUTE, TRIM, PROPER, UPPER, LOWER, EXACT, TEXT, CODE, CHAR. TODAY, NOW, DATE, DAY, MONTH, YEAR, WEEKDAY, WEEKNUM, NETWORKDAYS, NETWORKDAYS.INTL and time calculations.

Practice: Clean a customer list and calculate working days between order and delivery dates.

IF, nested IF, AND, OR, IFERROR. Ten ways to map values with VLOOKUP, HLOOKUP, INDEX, MATCH, ROW and COLUMN.

Practice: Match employee codes between an attendance sheet and a salary sheet.

Name Manager, OFFSET, INDIRECT, CHOOSE. DSUM, DCOUNT, DCOUNTA, DAVERAGE, DMAX, DMIN. 15 array formula examples with VLOOKUP, IF, SUM, MAX, MIN, AVERAGE, LARGE and SMALL.

Practice: A report template that changes when you pick a different month from a dropdown.

Sorting, Filter, Advanced Filter, Remove Duplicates, advanced Data Validation, Conditional Formatting, sheet and workbook protection, sharing a workbook, and automatic vs manual calculation.

Practice: A data-entry sheet that blocks wrong entries and highlights overdue payments.

Pivot Tables, Pivot Charts, grouping by month and quarter, percentage and growth analysis. Report terms used in companies: MTD, QTD, YTD, MAT, CYTD, FYTD, FTM, QTM, YTM, L3M, L6M, L12M. Hyperlinked reports and simple user manuals.

Practice: A monthly MIS report on 12 months of sales data.

Column, bar, line and pie charts. Form controls: combo box, list box, button, option button, check box. Camera Tool to show several charts in one space.

Project: A dynamic sales dashboard using OFFSET, Name Manager, form controls, charts and tables.

Recording a macro, the VBA editor, variables, IF and loops, working with ranges and sheets, buttons that run macros, and saving .xlsm files safely.

Practice: A macro that formats a raw data export and creates the monthly report in one click.

Importing data from several files and folders, cleaning columns, merging and appending tables, and refreshing a report when new data arrives.

Practice: Combine 12 monthly sales files into one table that refreshes.

Moving Excel files to Google Sheets, sharing and permissions, IMPORTRANGE, QUERY basics, and the formula differences you will notice.

Practice: A shared tracker that a team of five can update at the same time.

Using ChatGPT and Microsoft Copilot to explain a formula, write a first version of a formula or macro, and check it before you trust it. Where AI gets Excel wrong and how to spot it.

Practice: Write a nested formula with AI help, then fix the mistakes it makes.

12 modules · scroll inside the box to see all

Reserve your seat

Pay a small amount now to hold your seat. Pay the rest when you join.

  • Classroom in Delhi NCR or live online
  • No Cost EMI available
  • A counsellor calls you to confirm

Takes about a minute

Top Offers on this Course

Advanced Excel

₹500 Initial Pay
  • Duration: 30 hours
  • Features:
    • Best for: Freshers, office staff and students who need strong Excel for interviews and daily work
    • Modules 1–8
    • Sales dashboard project
    • Practice files for every module
    • Interview-style Excel test with feedback
3 more benefits are shown after you unlock.

Advanced Excel + VBA & AI

₹500 Initial Pay
  • Duration: 45 hours
  • Features:
    • Best for: MIS executives, accountants and analysts who want to automate repeated reports
    • Everything in Package 1
    • Modules 9–12: VBA macros, Power Query, Google Sheets, AI help inside Excel
    • 2 projects: sales dashboard and a one-click automated MIS report
    • Mock interview for MIS and Excel roles
3 more benefits are shown after you unlock.
EMI
  • No Cost EMI available
  • EMI through Bajaj Finance
  • Pay your course fee month by month
  • Ask your counsellor for the EMI plan that suits you

EMI and No Cost EMI are offered by Bajaj Finance and Payment Gateway Partners. They depend on Bajaj Finance approval, admin approvals, documents and terms.

Jobs That Use These Skills

MIS Executive

MIS Analyst

Data Entry & Reporting Executive

Accounts Executive

Junior Data Analyst

Sales Coordinator

Operations Executive

Back Office Executive

Who Should Join

  • Graduates and final-year students preparing for MIS, accounts or back-office interviews
  • Working staff who spend hours every month making the same report by hand
  • Accountants who already use Tally and now need Excel for reconciliations and reports
  • Sales and operations coordinators who send weekly numbers to their managers
  • Anyone planning to learn Power BI or SQL later. Excel comes first.

Frequently Asked Questions

Yes. Module 1 starts with workbook structure and references, so you do not need earlier training. If you can type and save a file, you can start with Package 1.

Package 1 is 30 hours and covers formulas, lookups, Pivot Tables, MIS reports and a dashboard project. Package 2 is 45 hours and adds VBA macros, Power Query, Google Sheets and using AI tools such as ChatGPT and Copilot inside Excel. Choose Package 2 if your job involves making the same report every week or month.

Yes. You get a course completion certificate from F1 Macro Technologies after you finish the course and submit your project.

Yes. Accountants use SUMIFS, VLOOKUP and Pivot Tables for ledger matching, GST reconciliation and monthly expense reports. If you also need Tally, GST and ITR, look at the Certified Enterprise Accountant course.

Yes. Classes run in the classroom in Delhi, Gurgaon and Ghaziabad, and live online. Weekday, evening and weekend batches are available. Call +91 98188 45002 or WhatsApp +91 99903 49899 for the next batch date.

Yes. Data Analytics with AI covers Advanced Excel, Power BI, SQL Server and Python, depending on the path you pick. This Advanced Excel course teaches only the Excel part, in 30 to 45 hours: lookups, Pivot Tables, MIS reports and dashboards. Join it if Excel is all you need for your job. Choose Data Analytics with AI if you want the full set of data tools.

Independent reviews

Course Reviews

4.7 average rating

2,800+ student ratings on Google, Justdial & UrbanPro.

Student stories

What Our Students Say

Real words from learners who trained with F1 Macro Technologies.

5/5

I joined this data analyst coaching and it was really helpful. The teacher explained every concept in a simple and clear way. The classes covered Excel, SQL, Power BI, and Python with real examples. Doubt sessions were great, and I got personal help whenever needed. Best for beginners who want to start a career in data analysis

Sahil Panwar

Sahil Panwar

Data Analytics
5/5

F1 Macro is Referred By My Friend After That I Join the Classes for Data Analysis Course My Excel Class is Complete Good To Understand, Power BI Class is Running, Excellent To Understand the Classes Of Power BI from Rohit Sir, Advance Excel, SQL, VBA and Python By Krishna Sir All Doubt are Clear at Same time. Thanks

Ankur Pandey

Ankur Pandey

Data Analytics
5/5

Hello I'm Vivek Yadav...I have enrolled master of data analytics thanks for giving me the opportunity to be a part of F1 macro. I have learned a lot from here which I am gonna cherish all my life .. thank you so much teachers for your kind support.

Vivek Yadav

Vivek Yadav

Data Analytics - MDA
5/5

The institute has amazing and supportive faculty members. They provide with multiple assignments along with study material as well as resolve any queries related to the assignment. I highly recommend F1 Macro Technologies for anyone looking to build a strong foundation in data analysis.

Divya R Nair

Divya R Nair

Data Analytics
5/5

I have just completed my Data Analyst Training from F1 Macro Technology, Delhi. I enjoyed my training over there. The course was designed by experts and not only theory but hands on experience was good in class. Each and every concept was taught from the basics. They covered all the aspects which will help you in Future.

Tarun Gupta

Tarun Gupta

Data Analyst Training | Placed in MNC
5/5

I have done MCCA course from F1 Macro and I am lucky because I got a good and supportive teaching staff here. Now I got a job in India's biggest IT company Telus International - all thanks to the entire team of F1 Macro Technologies.

Ali Jawad Zaidi

MCCA + Data Skills | Placed at Telus International
5/5

Hi, I am Amit from Bangalore. I have attended Data Analytics basic tools like Excel, SQL, Python, Power BI from F1 Macro Technologies and I can proudly say one should go for their courses as the faculties and the study materials are really good.

Amit Prakash

Data Analytics (Excel, SQL, Python, Power BI)
5/5

My name is Mukesh Goyal from Jaipur. It's a wonderful platform for good learning. I really learnt from F1 Macro Technologies courses - SQL Server, Advance Excel, Power BI, VBA, Python. Overall good experience. Thanks to all staff and management for this opportunity to learn and earn.

Mukesh Goyal

Data Analytics + ML | Career Switcher from Jaipur
5/5
Google review

My name is Ankur Sharma, and I live in Gandhi Nagar, Delhi. I enrolled in the Data Analyst course at F1 Macro technologies Institute Laxmi Nagar, and my experience has been very positive. The institute provides highly knowledgeable and supportive teachers who explain concepts clearly and help students understand even complex topics with ease. They are always available to solve doubts and provide guidance whenever needed. One of the best things about the institute is the digital notes and study materials, which make learning more convenient and effective. The course content is well-structured and industry-oriented, helping students build practical skills in Data Analytics. I would highly recommend F1 Macro Institute to anyone looking to learn Data Analyst and improve their technical skills in a supportive learning environment.

Ankur Sharma

Data Analytics
5/5
Google review

I am Avinash Singh, currently pursuing the Data Analytics course at F1 Macro Technologies. The training is well-structured, and the instructors explain concepts clearly. The hands-on projects and practical approach have helped me improve my skills in Excel, SQL, Power BI, and Data Analytics. I highly recommend this institute to anyone looking to build a career in data analytics.

Avinash Singh

Data Analytics
11student reviews in total See all reviews

Our Students Hired in Corporates

  • Axis Bank
  • Samsung
  • Godrej
  • WNS logo
  • Infosys logo
  • Bosch logo
  • GE logo
  • Bank of America logo
  • YES Bank logo
  • Citibank logo
  • HCL logo
  • RBL Bank logo
  • Genpact logo
  • Bata logo
  • MetLife logo
  • CPA Global logo
  • Muthoot Finance logo
  • Google logo
  • Fidelity Investments logo
  • PwC logo
  • EXL logo
  • BT logo
  • Cisco logo
  • GSK logo
  • Bajaj Finserv logo
  • TVS logo
  • Accenture logo
  • Bajaj logo
  • P&G logo
  • IBM logo

We do not own these logos. Company names and logos belong to their owners. We show them only to mark where our students got jobs. F1 Macro Technologies is not a partner of these companies and is not endorsed by them.

Placement stories

Recent Hirings of Our Students

Learners from our placement records, now working in the roles they trained for.

Tarun Gupta Placed

Tarun Gupta

Data Analyst
  • Trained inMaster in Data Analytics
  • Now atBT Group, Gurugram
Paras Jain Placed

Paras Jain

Operations Executive
  • Trained inMaster in Data Analytics
  • Now atArush Switchgears LLP, Daryaganj
Mohit Bhallav Placed

Mohit Bhallav

Accountant
  • Trained inMIS
  • Now atShubham Enterprises, Delhi
Shikha Tripathi Placed

Shikha Tripathi

Web Developer
  • Trained inWeb Development + Java
  • Now atNXlogy Pvt Ltd, Noida

Placement assistance helps you prepare and apply; it is not a job guarantee.

Your Path to a Global Career Starts Here

See how F1 Macro Technologies is bridging the gap between education and employment. Explore where our students are working today.

Excited?

Talk to Expert Counselor

to understand your profile and plan the next career move!

Call us+91 98188 45002

or Request a Call back

This confirms you are a person. If you cannot answer it, please call us and we will take your details.
WhatsApp