Skip to content
New Milap Nagar, Ambala City

Home Courses

Practical course guide · Ambala, Haryana

MS Office with Advanced Excel in Ambala

Create documents in Word, organise and analyse data in Excel, and present results in PowerPoint.

What you practise in the MS Office course

Create a meeting pack using Word, Excel and PowerPoint. Write an agenda and a decision record in Word, compare costs and track event tasks in Excel, then present the options and a recommendation in PowerPoint. Each file should support the same decision. When the numbers change, you will update the workbook and revise the other files without leaving old totals behind. Learners in Ambala can adapt this practice to a college event, an office workshop or a community meeting.

Use a fictional one-day skills workshop for your practice. The organiser expects 20 participants, has space for up to 24 and can spend up to ₹4,800 on the event. Two venue options include different room hire, printing, supplies and travel costs. The committee needs to choose an option that fits the limit and provides an easy way for attendees to reach the room. Any venue names, quotes and remaining budget in this guide are sample data.

Start by writing a one-sentence objective: choose a venue and assign the tasks needed to confirm the workshop. Prepare three files from the same source figures. The Word document explains the decision and who owns the next steps. The spreadsheet stores the figures, calculations and status. The presentation helps the committee understand the choice in a few minutes. This assignment helps you practise changing the same information across different applications.

Plan the files and practise safe handover

Set up a folder and choose the editable source

Create a Practice Workshop folder with subfolders for Working, Source and Shared. Keep the fictional supplier notes in Source and the editable documents in Working. Put the files you plan to distribute in Shared. Use names that a reader can identify without opening the attachment, such as Workshop-Agenda-Review.docx, Workshop-Budget.xlsx and Workshop-Brief.pptx. Use a date or revision number when sharing updated copies.

Make the Excel workbook the source for costs and calculation results. After changing a quote, read the new figures from the workbook before editing the agenda and presentation. Add the source date to the slide notes and the document budget summary so a reviewer can match the numbers against their copy. If teammates edit files separately, decide who will reconcile the final pack. Two copies with slightly different budgets can create confusion even when their names look almost identical.

Account for how recipients will open the pack

Identify the people who need to make edits and the people who only need the meeting materials. Share editable files with the organisers who maintain them and prepare a PDF agenda for attendees who may open it on a phone. Check the attachments from a separate folder so you notice stale links or old file names. Keep a copy of the actual files that were shared for each meeting.

Use fictional names, emails and phone numbers if you share this project as a learning sample. Before sending a real pack, review the recipient list and decide which files and fields each person needs. A short agenda can travel separately from the internal cost breakdown. Review comments, hidden sheets, speaker notes and tracked changes before distribution. A print preview or screen view alone cannot show you every piece of embedded information in an editable document.

Prepare the agenda and decision record in Word

Use styles to build structure

Start a blank document. Enter “Skills Workshop Planning Meeting” as its title, followed by the date, time and location or meeting link. Add headings for Purpose, Agenda, Decision Required and Next Actions. Use Word's built-in heading styles so the Navigation Pane can show the structure and let you move between sections. Keep the title and headings consistent even if you change fonts later. Edit a style to update every heading that uses it.

Give each agenda item a time allowance and describe the desired result. Use five minutes to agree the workshop audience, ten minutes to compare venues, five minutes to confirm spend and ten minutes to assign actions. The total is 30 minutes. Put the decision on the same page as the agenda when possible. Use an actual numbered list so added or removed entries update the sequence. Avoid lining up columns by adding spaces; text will shift when it moves between devices or fonts.

Practise using paragraphs and spacing controls to keep related information together. Set a heading to stay with the following paragraph when it falls near a page break. Use a real page break to start the full decision record on the next page when it needs a separate section. Check the outline by moving one whole section in the Navigation Pane or by cutting and pasting the complete heading and body. Check that lists and tables still belong to the right section.

Create a short action table

Add columns for Task, Owner, Due, and Status. Use one row for a task and name an owner before the meeting ends. Example rows could include “Confirm access arrangements” assigned to Meera, “Verify updated print quote” assigned to Aman and “Prepare the joining message” assigned to Dev. Use dates in one consistent format. Mark outstanding questions in ordinary words, such as “Awaiting venue response,” so readers understand what needs to happen.

Keep the action table short enough to scan. If it flows onto another page, repeat its header row and check that key entries remain legible. Where the exact date is unknown, state the event it depends on, such as “Within two days of approval,” and add the calendar date after the decision. Have a classmate use the pack to identify the next task, its owner and the current obstacle. Edit the action wording if they need extra context to understand it.

Review changes and prepare the final PDF

Use comments to ask what needs confirming. Turn on Track Changes if teammates should review wording edits one by one. Accept or reject changes after discussing them and remove resolved internal comments from the shared copy. Keep a working copy with the decision history where you need it. Take care when changing to a reading view that hides markup; review the final file explicitly before export because hidden markup can still be present in an editable copy.

Export the agenda to PDF and open the exported file. Check that the title and visible figures match the decision, headers and page numbers are in order, and no table text is cut off. Confirm that the file works on a phone at a reasonable reading size. Try selecting some text in the PDF instead of relying only on appearance. If the table is too small, simplify the columns or move the longer action notes to a second page with the same section heading.

Compare workshop costs and track tasks in Excel

Create a quote table with clear inputs and totals

Put venue quotes in an Excel Table with Option, CostItem, Quantity, UnitPrice, Amount, QuoteDate and QuoteStatus. Put the ₹4,800 spending limit in a separately labelled cell. For Venue A, use room hire ₹2,250, printing ₹600, supplies ₹500 and local travel ₹340. For Venue B, use room hire ₹1,800, printing ₹1,050, supplies ₹450 and local travel ₹330. Enter 24 copies at ₹25 for Venue A printing and use a quantity of one for flat fee quotes.

Calculate a line amount from Quantity multiplied by UnitPrice. Keep the currency format separate from the typed numeric value, so a formula can use the price directly. Sum each option using SUMIF, or SUMIFS if you also need to restrict the result to active quotes. For the original example, Venue A totals ₹3,690, leaving ₹1,110 within the cap. Venue B totals ₹3,630, leaving ₹1,170. Calculate both cases by hand once and compare the result with Excel.

Amount remaining is spending limit minus estimated cost. Confirm what the spending limit includes before making a decision. If the committee wants to reserve ₹500 for unforeseen costs, show that as a separate row or amount in the summary and note how it affects the remaining budget. Keep the same rule when comparing both options. Do not treat a blank cost as confirmed savings; make any pending quote visible.

Use a lookup and summary to make decisions easier

Create a small venue reference table with one row per option. Include a capacity, confirmation status and a short access note. Use an exact lookup to bring the selected venue's capacity into a summary box. Where available, try XLOOKUP with a clear missing-value message. INDEX with MATCH can also return the value from the capacity column. Test an invalid venue code and show the missing status on the summary. Ask the organiser to verify accessibility details before describing them in the agenda.

Create a PivotTable with CostItem on rows, Option in columns and the sum of Amount in Values. You can now see that A is ₹450 higher for room hire and ₹450 lower for printing. The supplies and local travel figures account for the remaining difference of ₹60. Compare the PivotTable totals against the option summary. Apply one filter at a time and label what it shows. If you use a chart, label the two option bars and state whether they show the original estimate or the latest confirmed quotes.

Track tasks and progress without mixing status labels

Use a second Excel Table for Task, Owner, DueDate and Status. Add validation for the agreed statuses, such as To Do, In Progress, Waiting and Done. Use COUNTIF to count completed tasks, or COUNTIFS to find open tasks due before a named review date. Agree on what “Done” means. A print quote request can be sent while the task for obtaining the confirmed price is still waiting.

Use a fixed review date while practising status formulas so another person can reproduce your result. Add an open task due the previous day, one due on the review date and one due the next day. Verify that the “overdue” rule catches the first task. Add an open task with no date and display a separate flag for missing dates. If you simply compare every date field with the review date, empty fields may be interpreted in a way that makes your overdue count misleading.

Present the decision in PowerPoint

Build a short deck around the audience's question

Create a four-slide presentation. Slide one states the workshop goal and the venue decision needed. Slide two compares the options and shows the limit. Slide three explains the recommendation and any conditions, such as confirming room access or getting a final print quote. Slide four lists the actions and their owners. Give each slide one message that follows from the earlier slide. Move optional detail to speaker notes or the workbook, where it can be reviewed if someone asks.

For the comparison slide, enter the values from the workbook and label the two options. A simple chart can show ₹3,690 and ₹3,630 with the ₹4,800 limit shown separately. If you use bars, show the scale and begin at zero. The ₹60 difference is small compared with the budget, so describe the operational factors that matter for the decision. An accessible room and agreed opening hours could be more important than the price gap. Keep the prices and conditions in the same reading order on both the slide and the notes.

Make the deck readable on a different screen

Use a consistent slide layout and check the text in Slide Show view. Give each slide a descriptive title and meaningful text labels on charts. Check that figures retain their currency symbols and that colour differences are supplemented by labels. Use alternative text where a visual conveys information. Check the order in which slide objects are read with the tools available in your Office edition. Read the slide at presentation size instead of assessing text only while zoomed in.

If you link a chart from Excel, test the presentation on a second machine or from a separate folder with the source workbook in the expected location. A linked object can require access to the original file. Pasting a static chart or rebuilding a simple comparison from the workbook can make handover easier when the presentation must travel independently. Record the workbook revision in the deck and refresh the slide's figures whenever the source changes.

Rehearse a short explanation and a question

Give a one-minute summary to another learner. Start with the decision required and finish with the action you want the group to take. Ask someone to challenge your recommendation. For example, if they ask why you chose A when B costs less, demonstrate where you found the amounts and describe the tradeoff that matters to the workshop. If an assumption was never confirmed, acknowledge the open question and take it to the action table.

Complete an update across the three files

Run a realistic last-minute change

Practise receiving a revised print quote two hours before the meeting. Change Venue B printing from ₹1,050 to ₹1,280 in the latest workbook copy and update its quote date. The B estimate becomes ₹3,860 and the remaining budget is ₹940. Venue A still totals ₹3,690, leaving ₹1,110. The lower-cost option switches from B to A. Refresh any PivotTables and recheck the summaries before opening Word or PowerPoint.

Then update the recommendation, the agenda budget note and the slide comparison. Search the three files for the old values and review any matches. Keep earlier values only where the history explains the revision and mark them as superseded. If a PDF has already been exported, generate the updated file and check its revision. Ask the recipient to use the new version if earlier material was distributed.

Repeat the change using a different scenario. Imagine Venue A confirms that its room can only seat 18. Enter the revised capacity in the reference table and compare it against the 20 expected participants. Discuss the consequence in the slides and update the Word action table with the person responsible for resolving it. The event budget may still fit, while the capacity check affects whether the venue can be recommended.

Test delivery from the recipient's point of view

Ask a partner to open only the Shared folder and prepare for the meeting. Check whether they can tell which venue you recommend, which cost is current and which person will confirm the booking. Ask them to open the PDF and use the deck in Slide Show view. Move the pack temporarily to another practice folder and check whether your chart, presentation fonts and any internal navigation still work where expected. Put the recovered issue and fix in a short change log.

Compare the source date and revision across all files once more. The editable working pack should include enough context to revise the project. The attendance-facing agenda should contain only details needed by that audience. For an interview portfolio, use fictional records and preserve one copy showing the initial options and a second showing the revision. Be ready to explain the logic of the change without rereading every line.

After a practice meeting, draft a brief decision record. Capture the chosen venue, the approved budget, any conditions and who will confirm each action. Compare the record with the meeting notes and carry outstanding tasks into the existing Excel tracker. Give each action the same wording in Word and Excel so a recipient can recognise it by name. Try a follow-up meeting with three attendees and ask one person to use the record to explain what changed between meetings.

Practise a participant list and personalised joining notes

Use one row per participant

Create a fictional attendee list with Name, Session, ArrivalTime and Confirmed. Give six sample participants different names and assign each to the morning or afternoon session. Store the table in a separate workbook from the venue budget so the same cost sheets do not circulate with a participant list. Keep one row per participant and check how the list identifies duplicate entries. If two people have the same name, an existing registration ID is a more reliable record key than the name alone.

Filter to confirmed attendees and compare the visible count with the number of records you expect to prepare. Set aside one row with a deliberately missing arrival time and review it before merging. An exception should lead to a question for the organiser or to a record awaiting confirmation. A blank field in the final message makes the reader guess whether a time was intentionally omitted. Use consistent formatting for the sample times and be clear about the displayed time convention.

Build a Word template and check personalised output

Write a short confirmation letter with the workshop title and meeting date, then place the name, session and arrival time fields where they belong in the message. Use Word Mail Merge in a desktop edition that supports it, select the attendee list and preview the first, middle and last records. In this exercise, merge into a new document for review. Compare the text alongside the workbook before saving individual copies or preparing a handout. The word processing file is a template you can use with another fictional list.

If the time appears as an unexpected number, inspect how the data source represents dates and times and what Word displays after the merge. For practice, compare a purpose-built display field such as a text column produced with TEXT against the source time. Check names that contain multiple words and verify how the final page breaks handle very long names. The preview should contain the expected number of letters. Review each sample note for the correct time and session.

Recheck the instructions after a change

Change the afternoon arrival time by 15 minutes in the source list and update the general joining instructions. Generate another reviewed merge output. Check the affected attendee notes, the draft agenda and any presentation slide that mentions arrival. Morning participant notes should still show their original time. Save the earlier review copy where the organisers can identify it and give the new file an updated revision. Describe the change briefly so the next person knows which group was affected.

Practise common office interview tasks

Time a short practical test

Use a 30-minute exercise. Take five minutes to review the brief and sort the input files, ten minutes to prepare a formatted Word memo, ten minutes to build the Excel summary, and five minutes to produce a slide and review all outputs. Try one run with the workshop data and one with a different budget. Keep notes on errors you made, such as using a number without a source or forgetting to update a printed total. Begin the next session by reproducing and correcting one error.

If asked how you would prepare a meeting agenda, describe the audience and outcome, list the timed items, and state who owns each decision. Demonstrate how you use Word styles and export a PDF. If asked what you would do with inconsistent expenses, show how you check data types and verify figures against the quote. For PowerPoint, explain how you turn a data sheet into one comparison the audience can understand while the meeting continues.

Answer questions with an example from the pack

For “How do you keep several Office files consistent?”, show the revision from ₹3,630 to ₹3,860 and walk through the refresh, agenda and slide updates. For “What is your process before sharing documents?”, show the final PDF and describe how you check the page, recipient list, internal comments and filenames. If someone asks where you used Advanced Excel, demonstrate the exact lookup for capacity and the PivotTable for cost categories, then show a control total.

Identify one improvement you would make for repeated weekly use. For example, store the meeting date and cap once in the workbook and write a short refresh checklist. A recurring pack benefits from stable field labels, while a single small meeting can work with a simpler workbook and a static chart. Explain how you decide the level of automation based on how often the pack changes and who will maintain it.

Frequently asked questions about MS Office in Ambala

What is the difference between this course and Advanced Excel?

The MS Office course combines Word documents, Excel workbooks and PowerPoint presentations in one workflow. Choose Advanced Excel when the main goal is to spend more time on cleaning, analysing and reconciling spreadsheets. The meeting pack gives you a concrete way to decide which level is right for you. Try entering the quotes and making a one-page agenda first, then identify the part you would most like to practise.

Do I need to know Office before starting?

Knowing how to open apps, select text and organise files is helpful. If these tasks still feel unfamiliar, start with a basic computer lesson and practise saving an editable Word file and its exported PDF. Tell the centre which applications you have used and which device you will practise on. Ask which Office edition the batch uses, because menu locations and advanced features can vary.

What can I put in an office skills portfolio?

Use a clean Word agenda, the sample Excel workbook and a short PowerPoint. Add a brief written summary of the venue decision and one example of how an updated quote changed it. Use fictional data. Show file names, formulas, a readable print version and at least one control check. Be ready to take the interviewer from the source figure to the final slide in a few steps.

What should I ask about the next batch?

Ask the Ambala centre about the current batch schedule and fees, which Office apps and versions are used, and whether practice includes a combined assignment. Bring a typical task you want to learn, such as preparing a report or formatting a meeting agenda. Ask how trainers review spreadsheets and presentations, and what you can practise on your own between sessions.

Course syllabus

  1. Format documents and export them as PDFs

    Format a Word document using headings and tables, then export a clean PDF.

  2. Use formulas, filters and charts in Excel

    Organise rows in Excel, apply formulas and create a chart that explains the result.

  3. Summarise data with lookup functions and PivotTables

    Use lookups and PivotTables to summarise a larger table of records.

  4. Build a slide deck around a clear message

    Build a short PowerPoint deck using the same information and present the main findings.

What you’ll be able to do

Prepare a usable office pack: a document, an Excel report and a short presentation.

Example practice project

Prepare a meeting pack

Create a Word agenda, an Excel budget sheet and a short PowerPoint deck using the same example data.

Prepare to discuss your project in an interview

Practise describing what you built, one choice you made and how you checked the result.

Question to practise
How did you check that your document, report or data entry was accurate?

See the interview practice guide →

Before you join

Does this course go beyond basic Excel?

Yes. The outline includes lookup functions and PivotTables alongside Word and PowerPoint.

What’s included?

This program includes a course certificate and placement support. Ask the admissions team about completion requirements and the support available for your batch. Placement support does not guarantee a job.