Head office, Rana Pratap Bagh, Delhi011 2721 1512+91 97116 99511

Computer & Office Skills

Advanced Excel and data analysis

Beyond the basics of Excel: cleaning data, lookups, pivot tables, charts that answer a question, and simple dashboards.

Suits: Office staff, commerce students and anyone who already uses Excel

Ask about fees and batchesCall 011 2721 1512

Duration, fees and batch timings are quoted by the head office or your centre.

Students at computers in a classroom while a teacher helps one of them

2 study books in this course

  • Advanced Excel and Data Analysis
  • MS Excel
Lessons
17
Practice questions
75
Free ebooks
0

About the course

What the advanced Excel course is about

Most people use Excel as a calculator with a grid. This course is about using it as a tool for answering questions: cleaning a messy sheet, turning it into a table, looking values up across sheets, summarising thousands of rows with a pivot table and showing the result as a chart that makes the point.

The study book works through the functions an office or a shop actually needs, from TRIM and Text to Columns to XLOOKUP, SUMIFS and Goal Seek, and ends with a one-page dashboard that updates when the data changes. The Excel study book of the MS Office course is included for revision of the basics.

All computer & office skills courses

What you will practise

Drawn from the lessons of the study books below.

  1. 01

    Clean a messy sheet with TRIM, Text to Columns, Remove Duplicates and data validation

  2. 02

    Look values up with VLOOKUP, XLOOKUP and INDEX/MATCH, and handle missing values with IFERROR

  3. 03

    Summarise data with SUMIFS, COUNTIFS and AVERAGEIFS, and with text and date functions

  4. 04

    Build a pivot table and a pivot chart from thousands of rows

  5. 05

    Choose and format a chart that answers a question

  6. 06

    Use Goal Seek and scenarios, and lay out a simple dashboard that updates itself

What you will learn

2 subjects, 17 lessons

Every lesson of the study books that come with this course in the student portal, with the key points of each lesson and exercises to try. Your centre gives you the syllabus, the duration and the fee.

Subject 1 of 2

Advanced Excel and Data Analysis

Turn messy sheets into answers with Excel: cleaning and preparing data, tables, lookups, logical and counting functions, text and date formulas, sorting and conditional formatting, pivot tables, charts that answer a question, what-if analysis and a simple shared dashboard.

  • 10 lessons
  • About 40 min of reading
  • 40 practice questions
  • 28 key terms
  1. 1Cleaning and preparing data4 min read · 4 key points · 3 exercises

    Key points

    • Analysis is only as good as the data under it, so clean before you calculate.
    • Keep a raw copy and work with one header row and one record per row.
    • Text to Columns splits combined cells; TRIM, CLEAN and PROPER tidy text.
    • Remove Duplicates and Data Validation keep the list correct now and later.

    Try this

    1. Type ten rows of a kirana shop's sales with deliberate extra spaces and mixed-case item names, then clean them with TRIM and PROPER and paste as values.
    2. Put ten customer records in one cell each as name, city, mobile separated by commas, and split them with Text to Columns.
    3. Add Data Validation to a marks column so only whole numbers from 0 to 100 are allowed, with a friendly error message.
  2. 2Tables and structured references3 min read · 4 key points · 3 exercises

    Key points

    • Ctrl+T turns a list into a Table that grows and filters by itself.
    • Name every Table; names make formulas readable and reliable.
    • Structured references use column names such as Sales[Amount] instead of F2:F417.
    • Calculated columns, the totals row and slicers come free with a Table.

    Try this

    1. Convert a sales list into a Table named Sales, add a calculated column Amount using [@Qty]*[@Rate], then add a totals row showing the sum.
    2. Write a formula on another sheet that totals Sales[Amount], then add three new rows and confirm the total updates.
    3. Insert a slicer on the Item column and use it to show only one item's rows.
  3. 3Lookups: VLOOKUP, XLOOKUP and INDEX/MATCH5 min read · 4 key points · 3 exercises

    Key points

    • A lookup fetches a matching value from another list so prices and names are typed once.
    • VLOOKUP needs the key in the first column and FALSE for an exact match.
    • XLOOKUP and INDEX/MATCH look in any direction and survive inserted columns.
    • IFERROR replaces #N/A with a message; text versus number mismatches are the usual cause of failures.

    Try this

    1. Build a price list Table and use VLOOKUP to fill rates on a sales sheet, then rebuild the same column with INDEX/MATCH.
    2. Make a grade table and use an approximate-match lookup to grade 20 students' marks.
    3. Deliberately type a wrong item code, see the #N/A, and fix it with IFERROR showing the words Check code.
  4. 4Logical and counting functions4 min read · 4 key points · 3 exercises

    Key points

    • IF chooses between two results; nest IFs or use IFS for more branches.
    • AND needs every test true, OR needs any test true.
    • COUNTIFS, SUMIFS and AVERAGEIFS count, total and average rows that meet several conditions.
    • Criteria with operators go in quotes, and SUMIFS takes the sum range first.

    Try this

    1. On a marks sheet, add a Result column that says Pass only when theory is at least 33 and practical at least 40.
    2. Using a sales Table, write SUMIFS formulas for each item's April total and check that they add up to the column total.
    3. Count how many bills over 1,000 were paid by UPI using COUNTIFS, with the 1,000 taken from a cell rather than typed into the formula.
  5. 5Text and date functions4 min read · 4 key points · 3 exercises

    Key points

    • LEFT, RIGHT, MID, LEN and FIND slice text; & and TEXTJOIN join it.
    • TEXT formats a number as text for labels and messages.
    • Dates are stored as day numbers, so they can be subtracted and formatted.
    • TODAY, EDATE, EOMONTH, NETWORKDAYS and DATEDIF handle ages, due dates and working days.

    Try this

    1. From a list of vehicle numbers, extract the state code with LEFT and count how many are from each state with COUNTIF.
    2. Add a column that flags any mobile number that is not exactly 10 digits long.
    3. Given invoice dates, compute the GST due date on the 20th of the next month and the number of days until it using TODAY.
  6. 6Sorting, filtering and conditional formatting3 min read · 4 key points · 3 exercises

    Key points

    • Sort inside a Table keeps rows together; add levels for class then marks.
    • Filters hide rows without deleting them, and SUBTOTAL totals only visible rows.
    • Conditional formatting colours cells by value with built-in rules, bars, scales and icons.
    • Formula rules such as =$F2="Unpaid" colour whole rows; use few rules.

    Try this

    1. Sort a marks Table by Class and then by Total descending, then filter to show only one class.
    2. Add a data bar to the Amount column of a sales Table and a red fill rule for any amount above 5,000.
    3. Write a formula rule that colours a whole row when the Status column says Unpaid, and test it by changing one status.
  7. 7Pivot tables and pivot charts5 min read · 4 key points · 3 exercises

    Key points

    • A pivot table summarises thousands of rows by dragging fields into Rows, Columns, Values and Filters.
    • Change Sum to Count or Average and show values as a percentage of the total.
    • Group dates into months and numbers into bands; refresh after adding data.
    • Slicers, timelines and pivot charts turn a pivot into an interactive report.

    Try this

    1. From a sales Table, build a pivot of total Amount by Item and Month, then show the same figures as a percentage of the grand total.
    2. Group a marks column into bands of 10 to see how many students fall in each band.
    3. Add a slicer and a pivot chart, then add ten new rows to the Table, refresh and confirm the chart changes.
  8. 8Charts that answer a question4 min read · 4 key points · 3 exercises

    Key points

    • Write the question first; the question picks the chart.
    • Columns compare, lines show time, pies show a few shares, scatter shows a relation.
    • Put the answer in the title, start value axes at zero and use colour only to highlight.
    • Combo charts with a secondary axis and sparklines handle mixed scales and per-row trends.

    Try this

    1. Make a column chart of sales by item, sort the bars largest first, and colour only the top bar differently.
    2. Draw a line chart of monthly commission with a title that states the finding in words.
    3. Add sparklines beside a marks Table to show each student's trend across three tests.
  9. 9What-if analysis: Goal Seek, data tables and scenarios4 min read · 4 key points · 3 exercises

    Key points

    • A model separates labelled inputs from formulas and one clear output.
    • Goal Seek changes one input until the output hits a target.
    • Data tables show the output for many input values, one or two variables at a time.
    • Scenario Manager saves named sets of inputs and builds a comparison summary.

    Try this

    1. Build the shop profit model and use Goal Seek to find the daily sales needed for a 30,000 monthly profit.
    2. Make a two-variable data table of profit against daily sales and margin percentage.
    3. Create Best, Likely and Worst scenarios for the model and produce a scenario summary.
  10. 10A simple dashboard and sharing the work4 min read · 4 key points · 3 exercises

    Key points

    • A dashboard shows the few numbers and charts needed to decide, on one sheet, refreshed not rebuilt.
    • Separate Data, Lists, Calc and Dashboard sheets and build everything on the Table.
    • Unlock input cells and protect the sheet to prevent accidents; hide helper sheets.
    • Set the print area, fit to one page, and share a PDF; refresh and check before sending.

    Try this

    1. Build a one-page dashboard with four cards, two charts and a Month slicer from a sales Table.
    2. Unlock only the input cells, protect the sheet, and try to type in a locked cell to see the message.
    3. Set the print area to the dashboard, fit it to one landscape page and export it as a PDF.
Glossary: 28 key terms of Advanced Excel and Data Analysis
Header row
The first row of a list, holding one short unique name for each column.
Record
One row of data describing one thing, such as one sale or one student.
Text to Columns
A Data tab tool that splits one column into several using a separator or fixed widths.
TRIM
A function that removes extra spaces from the start, end and middle of text.
Data Validation
A rule on a cell that limits what can be typed, such as a list of classes or a number range.
Remove Duplicates
A Data tab tool that deletes rows whose chosen columns repeat an earlier row.
Table
A named range created with Ctrl+T that grows by itself, filters and fills formulas down.
Structured reference
A formula reference using Table and column names, such as Sales[Amount].
Calculated column
A Table column whose formula is copied automatically to every row.
Slicer
A set of clickable buttons that filters a Table or pivot table.
VLOOKUP
A function that finds a value in the first column of a range and returns a value from another column.
XLOOKUP
A newer lookup that searches any column, returns from any column and has a built-in not-found message.
INDEX/MATCH
A pair of functions where MATCH finds a position and INDEX returns the value at that position.
IFERROR
A function that shows a chosen value instead of an error such as #N/A.
SUMIFS
A function that totals a column for rows meeting one or more conditions.
COUNTIFS
A function that counts rows meeting one or more conditions.
Criteria
The condition a cell must meet, written like ">1000" or "Sugar*".
Serial date
The way Excel stores a date, as the number of days since the start of 1900.
EDATE
A function returning the same day a number of months before or after a date.
Conditional formatting
Formatting that changes automatically based on a cell's value or a formula.
SUBTOTAL
A function that calculates only the visible rows after a filter.
Pivot table
An interactive summary of a list built by dragging fields into Rows, Columns, Values and Filters.
Refresh
Telling a pivot table or chart to re-read its source data after changes.
Secondary axis
A second value axis on the right of a chart for a series on a different scale.
Sparkline
A tiny chart drawn inside a single cell to show a trend for that row.
Goal Seek
A what-if tool that changes one input until a formula reaches a target value.
Data table
A what-if tool that shows a formula's result for a whole list or grid of input values.
Scenario
A named set of input values that can be shown or compared in a summary report.

Subject 2 of 2

MS Excel

Work with cells, ranges and formulas in Microsoft Excel, use functions such as SUM, IF, VLOOKUP and XLOOKUP, and sort, filter, chart and print your data.

  • 7 lessons
  • About 27 min of reading
  • 35 practice questions
  • 25 key terms
  1. 1Getting Started with Excel4 min read · 5 key points · 3 exercises

    Key points

    • A workbook (.xlsx) contains worksheets made of columns, rows and cells.
    • A cell address is the column letter followed by the row number, such as B4.
    • A range such as A1:C5 uses a colon to mean "from A1 to C5".
    • Text aligns left and numbers align right by default; ##### means the column is too narrow.
    • The fill handle continues series such as Jan, Feb, Mar.

    Try this

    1. Create a workbook with the headings Roll No, Name and Class in A1:C1, enter details for eight students, click a few cells to read their addresses in the Name Box, and save the file as Class Register.
    2. On a new sheet, use the fill handle to fill Jan to Dec down column A starting at A2 and Mon to Sun across row 1 starting at B1, then type 1 and 2 in two cells, select both and drag to continue the series up to 20.
    3. Type ten full names in column A and the first name of the first person in column B, press Enter so the cell below is selected and press Ctrl+E to let Flash Fill complete the column, then enter today's date with Ctrl+; and fix any ##### by double-clicking the column border.
  2. 2Formatting Cells and Worksheets3 min read · 5 key points · 3 exercises

    Key points

    • Formatting changes how a value looks, not the value itself.
    • Ctrl+1 opens Format Cells, where you can choose formats such as Currency with the ₹ symbol.
    • Gridlines do not print by default; use Borders for tables you will print.
    • Wrap Text, Merge & Center and AutoFit help data fit neatly.
    • Conditional Formatting changes a cell's look automatically based on its value.

    Try this

    1. Before typing anything in a Code column, format it as Text so codes such as 00123 keep their zeros, then type a price list of ten items with their codes, format the price column as Currency with the ₹ symbol and two decimal places from Format Cells (Ctrl+1), and add All Borders to the table.
    2. Add a title above a marks table and use Merge & Center across the table's width, AutoFit every column by double-clicking the border between the column headings, then apply Wrap Text to a long column heading and drag that column narrower so the heading shows on two lines.
    3. In a stock sheet of 15 items, use Conditional Formatting > Highlight Cells Rules > Less Than to colour quantities below 10 in red, add Data Bars to a sales column, then change one quantity to 5 and watch its colour update.
  3. 3Formulas and Basic Functions4 min read · 5 key points · 3 exercises

    Key points

    • Every formula starts with =; use cell references so results update automatically.
    • Excel calculates brackets first, then powers, then * and /, then + and -.
    • COUNT counts cells with numbers, while COUNTA counts cells that are not empty.
    • AVERAGE ignores empty cells but includes zeros.
    • Alt+= inserts AutoSum; errors such as #DIV/0!, #NAME? and #REF! point to the cause of a problem.

    Try this

    1. Create a marksheet for five students with marks in five subjects, add Total and Average columns using SUM and AVERAGE, and show the highest and lowest totals with MAX and MIN.
    2. Make a shopping bill with Item, Qty and Rate columns, calculate each Amount with a formula such as =B2*C2, copy it down with the fill handle, and get the grand total with AutoSum (Alt+=).
    3. Type =10+5*2 and =(10+5)*2 in two cells to see how brackets change the answer, compare COUNT and COUNTA on a column of names, and type =SUMM(B2:B5) to see the #NAME? error.
  4. 4Relative, Absolute and Mixed References4 min read · 5 key points · 3 exercises

    Key points

    • Relative references (A1) change when a formula is copied; this is the default.
    • Absolute references ($A$1) stay fixed wherever the formula is copied.
    • Mixed references ($A1 or A$1) lock only the column or only the row.
    • F4 cycles through the reference types while you edit a formula.
    • Use an absolute reference or a named cell for one value, such as a rate, used by many formulas.

    Try this

    1. Type five bill amounts in B2:B6 and a discount rate of 10% in F1, enter =B2*$F$1 in C2 and copy it down to C6, then try =B2*F1 copied down instead and work out why the lower rows show 0.
    2. Build a multiplication table: type 1 to 9 in B1:J1 and in A2:A10, enter =$A2*B$1 in B2, and copy it to the whole block B2:J10.
    3. Give cell F1 the name Discount in the Name Box and rewrite the discount formula as =B2*Discount, then edit a formula such as =B2*$F$1, place the cursor in the B2 reference and press F4 four times, writing down each form it shows.
  5. 5Decisions and Lookups: IF, VLOOKUP and XLOOKUP4 min read · 4 key points · 3 exercises

    Key points

    • IF(test, value_if_true, value_if_false) returns one of two results; text results go in double quotes.
    • VLOOKUP searches the first column of a table and returns a value from a column to its right.
    • Use FALSE as VLOOKUP's last argument for an exact match; a value that is not found gives #N/A.
    • XLOOKUP needs Microsoft 365 or Excel 2021 and later; it matches exactly by default and can return from any column.

    Try this

    1. In a marksheet with a Percentage column, add a Result column that uses IF to show Pass for 40 or more and Fail otherwise, and a Grade column with a nested IF that gives A for 75 and above, B for 50 and above, and C for the rest. If the percentages are shown with the % sign, write the limits as 40%, 75% and 50% in the formulas.
    2. Make a price list of ten item codes, names and prices in A2:C11, type a code in F2 and show its price with =VLOOKUP(F2,$A$2:$C$11,3,FALSE), then type a code that does not exist to see #N/A and wrap the formula in IFERROR to show Not found.
    3. In a sales list with City and Amount columns, count the sales from Delhi with COUNTIF and add their amounts with SUMIF; if your Excel is Microsoft 365 or Excel 2021 or later, also redo the price lookup with XLOOKUP and a "Not found" message.
  6. 6Sorting and Filtering Data4 min read · 5 key points · 3 exercises

    Key points

    • Keep one heading row and no blank rows inside a list you want to sort or filter.
    • Sort A to Z or Z to A sorts whole rows; Data > Sort sorts by several columns.
    • Filter (Ctrl+Shift+L) hides rows that do not match, without deleting them.
    • Ctrl+T turns a list into an Excel Table with automatic filters and formatting.
    • Freeze Top Row keeps the headings visible while you scroll.

    Try this

    1. Make an employee list of 15 rows with Name, City, Department and Salary columns, then use Data > Sort with two levels to sort by City from A to Z and then by Salary from largest to smallest.
    2. Turn on filters with Ctrl+Shift+L, show only the Sales department employees from Pune, then use Number Filters > Greater Than to show salaries above 30000, and finally clear all the filters.
    3. Convert the list into an Excel Table with Ctrl+T and add a Total Row from the Table Design tab, freeze the heading row with View > Freeze Panes > Freeze Top Row, and on a copy of the sheet (right-click the sheet tab, choose Move or Copy and tick Create a copy) enter one employee twice and remove the repeat with Data > Remove Duplicates.
  7. 7Charts and Printing4 min read · 5 key points · 3 exercises

    Key points

    • Select the data with its headings and use Insert > Recommended Charts or a chart type.
    • Column charts compare categories, line charts show change over time and pie charts show parts of a whole.
    • The Chart Design and Format tabs add titles, labels and styles; charts update when the data changes.
    • Fit Sheet on One Page, Print Area and Print Titles control what prints and how.
    • Gridlines do not print unless you tick Gridlines > Print.

    Try this

    1. Enter sales figures for six months, select them with their headings, insert a column chart, and use Add Chart Element to add a chart title, axis titles and data labels.
    2. Make a household budget with five expense heads and show it as a pie chart, then switch your sales chart to a line chart with Change Chart Type and edit one sales figure to watch the chart update.
    3. Prepare a 60-row list for printing: set Landscape orientation, use Print Titles to repeat the heading row at the top of every page, choose Fit All Columns on One Page, and check the preview under File > Print.
Glossary: 25 key terms of MS Excel
Absolute reference
A cell reference with dollar signs, such as $F$1, that stays exactly the same when the formula is copied.
Argument
A value, cell or range given to a function inside its brackets, such as B2:B10 in =SUM(B2:B10).
AutoSum
A button, with the shortcut Alt+=, that inserts a SUM formula for the numbers above or to the left of the active cell and also offers Average, Count Numbers, Max and Min.
Cell
The box where a column and a row meet, which holds one value, piece of text or formula.
Cell reference
The address of a cell, written as its column letter followed by its row number, such as B4.
Chart
A picture of worksheet data, such as a column, line or pie chart, that updates when the data changes.
Conditional Formatting
A Home tab feature that changes a cell's look automatically, for example colouring it red, when its value meets a rule you set.
Excel Table
A list converted with Ctrl+T that gets filter arrows and banded rows and grows automatically when you type a new row just below it.
Fill handle
The small square at the bottom-right corner of the active cell, dragged to copy a value or formula or to continue a series such as Jan, Feb, Mar.
Filter
A Data tab tool, turned on with Ctrl+Shift+L, that hides the rows that do not match your choices without deleting them.
Formula
A calculation typed in a cell that starts with an equals sign, such as =B2*C2.
Formula Bar
The bar above the column headings that shows, and lets you edit, the content or formula of the active cell.
Freeze Panes
A View tab command that keeps chosen rows or columns, such as the heading row, visible while you scroll.
Function
A ready-made formula with a name, such as SUM, AVERAGE or MAX, that works on the arguments given in its brackets.
IF function
A function that tests a condition and returns one value when the condition is true and another when it is false.
Mixed reference
A cell reference that locks only the column or only the row, such as $A1 or A$1.
Number format
The way a number is displayed, such as Currency, Percentage or Date, which does not change the value stored in the cell.
Print Titles
A Page Layout setting that repeats chosen rows, such as the heading row, at the top of every printed page.
Range
A group of cells written with a colon between the first and last cell, such as A1:C5.
Relative reference
An ordinary cell reference, such as B2, that shifts to match its new position when the formula is copied.
Sort
To rearrange rows into an order, such as A to Z or largest to smallest, while keeping each row's data together.
VLOOKUP
A function that finds a value in the first column of a table and returns the value from a chosen column to its right in the same row.
Workbook
An Excel file, saved with the .xlsx extension, that contains one or more worksheets.
Worksheet
A single sheet in a workbook, made of a grid of columns and rows, with its name shown on a tab at the bottom of the window.
XLOOKUP
A lookup function in Microsoft 365 and Excel 2021 and later that searches one column or row and returns the matching value from another, matching exactly by default.

Practice and study material

Study books and timed practice tests in the student portal

Students sign in to read the study books lesson by lesson, print them, mark lessons as done and test themselves with timed practice tests, every answer explained.

  • 2study books
  • 17lessons
  • 75practice questions
  • 53glossary terms

How the practice tests work

  • Fresh questions each time

    Up to 20 questions are picked at random from the subject’s question bank.

  • One minute per question

    A timer counts down. When it reaches zero, your answers are sent automatically.

  • Move around freely

    Skip a question, flag it, and come back to change your answer before you submit.

  • Learn from every answer

    At the end you see the right answer and an explanation for each question.

  • Read, print and keep track

    Each study book has its lessons, key points, exercises and a glossary. Print a lesson, or mark it as done.

Try 3 practice questions

Real questions from this course’s question banks. Pick an answer to see the explanation.

  1. Advanced Excel and Data Analysis · Question 1

    A sparkline is

    Show the answer

    Answer: A. a tiny chart inside one cell

    Sparklines show a per-row trend inside a single cell.

  2. MS Excel · Question 2

    Which of these can XLOOKUP do that VLOOKUP cannot?

    Show the answer

    Answer: D. Return a value from a column to the left of the lookup column

    VLOOKUP can only return values from columns to the right of its first column. XLOOKUP takes separate lookup and return ranges, so the return range can be on either side.

  3. Advanced Excel and Data Analysis · Question 3

    What is the main advantage of building a chart on a Table rather than a fixed range?

    Show the answer

    Answer: C. New rows are included automatically

    A Table expands as rows are added, so anything built on it sees the new data.

Careers

Careers this course leads towards

The kind of work these skills are used for. Each guide explains what the job involves, the skills it asks for and how to get started.

  • Data entry and office assistant

    Typing records, letters and reports, keeping spreadsheets up to date, and handling email, files and printing in an office.

  • Accounts assistant (Tally)

    Entering sales, purchases and payments, keeping GST records and preparing the reports a business owner or accountant asks for.

Free calculators

Useful calculators

Free tools that go with this course. They work in your browser, on a phone or a computer.

How admission works

From your first question to your certificate.

The usual steps, at the head office in Delhi or at an authorised member centre.

Who can join
Students above 12 years of age.
Where
The Delhi head office and authorised member centres.
Fees and timings
On WhatsApp at +91 97116 99511, or by phone on 011 2721 1512.
Start with a question
  1. 1

    Ask about the course

    Call or WhatsApp the head office, or visit your nearest member centre. Ask for the duration, the fee and the batch timings in writing.

  2. 2

    Fill the admission form

    Admission forms are supplied by the head office to every centre.

  3. 3

    Learn in class

    Attend your batch at the centre, with the course material and study notes, and sign in to the student portal for the study books and practice tests.

  4. 4

    Take the exam

    The institute prefers written exams, taken in front of a teacher.

  5. 5

    Receive your certificate

    Students who pass get a Gurukul Technicals Institute certificate and marksheet. Employers can verify it with the head office.

Questions

Questions about the advanced Excel course

Still have a question?

Chat on WhatsApp
Who can join the advanced Excel course?

Students above 12 years of age can take admission, at the Delhi head office or at an authorised member centre. The course suits office staff, commerce students and anyone who already uses Excel. Tell the head office or your centre what you already know, and they will suggest where to start.

Do I need to know Excel already?

You should be comfortable typing data, writing a basic formula such as =SUM and saving a workbook. The MS Excel study book comes with this course for revision; if all of it is new to you, start with the MS Office course instead.

How long is the course and what is the fee?

Duration, fees and batch timings depend on the course and the centre. Ask the head office or your nearest member centre, and get the details in writing before you pay.

Where are the classes?

At the head office in Delhi (A-10, Chief Commissioner Colony, opposite Rana Pratap Bagh) and at authorised member centres. Call or WhatsApp the head office to find the nearest centre.

What do I need to use the study books and practice tests?

A phone or a computer with an internet connection, and the login your centre gives you at enrolment. The student portal opens in an ordinary web browser, so there is nothing to install. Student login.

How do the practice tests work?

Sign in to the student portal and choose a subject. Each test picks up to 20 questions at random from that subject’s question bank and gives you one minute per question, with a timer that sends your answers automatically when it reaches zero. You can skip a question, flag it and come back before you submit, and at the end you see the right answer and an explanation for every question. This course has 75 practice questions across 2 subjects, and you can take the tests as often as you like.

Is there an exam and a certificate?

Yes. The institute prefers written exams, taken in front of a teacher. Students who pass receive a Gurukul Technicals Institute certificate and marksheet.

How is a Gurukul Technicals Institute certificate verified?

On the verify certificate page, anyone can enter a certificate number and check it against the institute’s online register, which covers certificates issued through the portal. For older certificates, or if there is any doubt, send a copy to the head office by email or WhatsApp; the reply comes within 2 working days.

Ready to start the advanced Excel course?

Ask the head office for the duration, the fee, the batch timings and your nearest member centre.

WhatsApp +91 97116 99511Call 011 2721 1512
WhatsApp us