MS Office Course Bundle- Word , Powerpoint , Excel & Outlook

Explore how to use Excel's fill series to generate numbers, months, and patterns with pattern recognition and autofill across cells.

Create and import custom lists in Excel to enable memory-backed auto-complete across workbooks. Open file options, enable create list for use in data entry, and import from Excel sheets.

Master Excel keyboard shortcuts, including ctrl+shift for selecting and ctrl+d for fill down, and use the Alt golden key to reveal the ribbon and guide coloring, alignment, and borders.

Master absolute and relative references in Excel by learning fixed versus variable values, using formulas, and efficiently filling ranges with drag and auto fill.

Create a mock sheet in Excel by inserting a new sheet named mark sheet for five subjects and 50 students, using auto-generated numbers and auto-fit columns, with marks 30–90.

Learn to generate random numbers in Excel with the randbetween function within a 30 to 90 range, and quickly fill down by dragging or double-clicking the fill handle.

Learn to replace formulas with their calculated values in Excel using paste special values, keeping results intact while removing formulas.

Learn to calculate total marks for five subjects with Excel formulas and auto-fill. Compute percentage as marks obtained divided by total marks times 100, then adjust decimal places.

Learn to implement if-then logic in Excel to assign pass or fail using greater than 50 percent or equal to, with the =IF formula and copy-down application.

Master nested if statements in Excel to implement a multi-tier grading scheme, validate syntax with brackets and quotes, and automate grade results across the sheet.

Learn to assign ranks with the rank function by comparing each student's percentage with the entire class, and fix the reference range with F4 as you copy the formula.

Learn how to apply conditional formatting in Excel to automatically highlight pass and fail results with colors, and display data bars for quick visual analysis.

Master freeze panes to keep headers and names visible while scrolling data. Select the intersection point, open the view tab, and fix top rows or first column.

Format a table quickly in Excel by applying a predefined table style, setting header presence, and converting the table back to a range to remove table formatting.

Master sort and filter techniques in Excel to isolate morning batches, apply consistent formatting with the format painter, and use between and top 10 percent criteria to select key students.

Discover how to use Excel to calculate subject-wise attendance and marks, applying count blank, count if, max, min, and average, and automate absent entries with find and replace.

Analyze a quarterly sales report for bags priced at 275, calculate sales amount and profit with fixed price, then sort by months and insert January to March totals.

Master grouping and auto totaling in Excel by using subtotal, expand collapse with plus minus signs, and data tab tools to create expandable monthly summaries with grand totals.

Learn to create expandable summaries in Excel by hiding and unhiding rows, using grouping and auto totaling with subtotal and grand total calculations across months.

Learn to remove duplicates to create a unique salesperson list. Then build a conditional sum with sum if to report sales amount and profit by salesperson.

Master absolute and relative referencing in Excel by identifying fixed versus variable parts, using dollar signs and F4, and applying rules through drag-based scenarios.

Apply a mix of absolute and relative references to use sumif across dynamic ranges, freezing columns with dollar signs while letting row references adjust as you fill down.

Apply sumif with external sheet references, combine data from bonus and sales reports, lock ranges with F4, and use a comma to separate sheet references to pull salesperson and units.

Evaluate if conditions in Excel to calculate sales bonuses using multiple logics with and/or criteria, absolute references, and nested IF statements based on units sold and customer reach thresholds.

Analyze aged debtors to track receivables by aging periods and due dates, categorizing invoices by months past due. Learn to prepare practical aging reports from client data and policy.

Unmerge merged cells in the exported report and tidy columns to prepare data for aging analysis in Excel. Use paste special skip blanks to copy headings without overwriting data.

Learn to automate data arrangement in Excel by recording a macro and enabling the developer tab. Create a button to run the macro for auto formatting and consistent data layout.

Apply brown bold font size 10 to the first column, highlight the second row, and add borders; use the format painter to paste across headings and double-click to paste repeatedly.

learn to create excel conditional formatting formulas to highlight payment statuses, using green for cleared and red for unclear, with absolute and relative references and heading-based rules.

Highlight headings in the data range with conditional formatting, including fake headings, by naming the range and applying two formula-based rules.

Learn to perform a monthly aging analysis of customer invoices using Excel formulas to extract month and year from due dates, categorize outstanding balances, and handle errors for accurate aging.

Master absolute and relative references in Excel, fix columns with dollar signs, and use date values to build aging analysis that drags formulas across months and years.

Build a dynamic aging report in excel that automatically categorizes open balances by days past (0–30, 31–60, 61–90, 91–120, 121–150, and older) using today’s date.

Explore how vlookup retrieves part details by searching the leftmost column of a table, using a fixed table range, a dynamic column index, and exact or approximate matches.

Learn to create and use named ranges with vlookup and iferror to return blanks, handle spaces with underscores, and maintain absolute references without dollar signs.

Simplify data entry in Excel by using data validation with a named list to create a dropdown, ensuring selections match the list and reducing spelling errors.

Learn to create a combo box with autocomplete using the developer tab and ActiveX controls, link it to a cell, and configure the list range and properties.

Explore how to use hlookup by flipping a data table with transpose, compare with vlookup, and extract bar numbers and product names using exact-match lookups and data validation.

Learn to perform lookups in Excel, compare vlookup and lookup, and why data must be to the right of the lookup column; manage fixed versus movable references with named ranges.

Master the index and match approach in Excel to extract the lowest bid and its vendor, using exact-match lookups and dynamic referencing across ranges.

Develop an automatic invoicing system in Excel for Remington Pharmaceuticals Industries, Private Ltd., that retrieves medicine details by name, uses the requested quantity to compute line totals and the overall total. Apply the tiered discount policy from the discount table—0 to 1000 with 5%, 1001 to 2000 with 10%, 2001 to 5000 with 15%, and 5000+ with 20%—and calculate the net amount using a data tab with prices and quantities via index-match.

Develop an Excel invoicing system using vlookup and index match to fetch product details, calculate totals, and apply discount tiers with approximate matching.

Learn to use sum if and IFS to calculate total sales by product and by sales representative across a dataset, handling single and multiple criteria and common pitfalls.

Learn to replace manual filters with a dsum search box that sums a database based on criteria, using headings to map fields and return immediate, dynamic sales totals.

Master advanced filters in Excel and automate with macros to dynamically extract transactions by region, using a search box, named data ranges, and refresh automatically.

Learn to build dynamic Excel pivot tables to generate regional sales reports by dragging regions, sales representatives, and sales amounts into rows, columns, and values using the classic layout.

Learn to create a pivot table based sales report by month and region, grouping dates by month and year to show total sales per region.

learn how to create calculated fields in pivot tables to compute profit by subtracting cost of goods sold from sales, and update the data source and labels as needed.

Explore when to use line, bar, and pie charts in pivot table reports, and learn to switch to stacked and 100 percent stacked columns for clear trend and contribution analysis.

Build a dynamic dashboard by combining charts, pivot tables, and slicers to show company performance by month, sales rep, region, and product, with a timeline filter.

Learn how to automate payroll checks by merging Excel data with a Word check template, adding amount in words via a Visual Basic macro, and printing multiple checks efficiently.

Explore how hyperlinks connect Excel data, enabling navigation between income, expenses, and named ranges. Link to external sites or files and use internal references like defined names for dynamic updates.

Link external sheet references with hyperlinks to quickly access bankbook reconciliation and daily files from a data mapping file; note that renaming or moving files can break hyperlinks, saving time.

Split full names into first and last columns with Excel text to columns, then concatenate them into full names, preserving values only.

Learn how Excel flash fill quickly combines first and last names into a full name, auto-suggests available fields, and uses autofill options to split or concatenate data, saving time.

Master PowerPoint basics by creating a blank presentation, exploring the interface, and using core tools—home, insert, design, transitions, and animations—to craft polished slides.

Insert new slides and apply layouts in PowerPoint, switch between title, title and content, or blank, delete or reset slides, and arrange placeholders, bullets, and simple charts for concise presentations.

Learn to change slide layouts and rearrange content in PowerPoint by adjusting text boxes, bullets, and images, and reorder slides using slide sorter and normal view.

Use the design tab to apply predefined themes quickly and adjust color, font, and bullet layouts. Save a custom theme to maintain the same design across slides.

Insert pictures into PowerPoint slides from your computer, then resize, move, crop, and apply frames, brightness, contrast, color changes, and background removal.

Insert a logo across slides using the slide master for consistency across layouts. Add online pictures from insert online pictures, filtering for transparent backgrounds and Creative Commons to enhance presentations.

Transform bullet points into smart art to enhance your PowerPoint presentation, selecting layouts, colors, and shapes to customize the chart and improve visual impact.

Insert and customize charts in PowerPoint using the chart menu and embedded data. Choose chart types, adjust colors, and switch rows and columns to fit your data.

Learn to insert audio into PowerPoint slides for background music, choose source (pc, web, or record voiceover), and tailor playback with auto play across slides, volume, and fade options.

Learn practical outlook 2016 setup by configuring a gmail account, including manual setup, incoming and outgoing servers, security settings, and testing the connection.

Explore the Microsoft Outlook interface, including the home screen, left navigation, reading pane, and favorites, and manage multiple email accounts. Learn to sort, search, and customize emails for inbox management.

Learn to use the Outlook calendar to create appointments and meetings, set reminders, and manage recurring events by dragging emails to the calendar and customizing time, location, and duration.

Create and send a meeting invitation in Outlook, setting subject, location, and time, inviting attendees to the current meeting and tracking RSVP responses in the calendar.

Learn to speed up email typing with auto correct across Microsoft Office apps, using text replacements to expand shorthand into full phrases and configure spelling corrections.

Learn how to use the quick access toolbar in Outlook to create shortcuts for frequent functions, such as reminders and new email, by right-clicking and adding them to the toolbar.

Enable voting buttons in an email to collect attendees' yes/no responses for a meeting, customize options, send the message, and track replies.

Enable blind carbon copy in Outlook by going to options and turning on the bcc feature, so you can send emails with a hidden recipient alongside the main recipient.

Learn to set a change reply to address in Outlook by configuring the 'replies to' options to route responses to a chosen main email.

Explore how Outlook search folders categorize emails by criteria: unread, important, large, or words in subject or body, and create custom folders to streamline email management.

Learn to create and insert an Outlook signature using free online tools, customize with a logo, contact details, and social links, and apply it within Outlook signatures.

add a calendar event to your email so recipients can save the meeting date and time in Outlook by inserting a calendar entry with the subject and date.

Learn to add a calendar to an email so recipients save the meeting date and time to their Outlook calendar, using the insert calendar feature with full details.

Learn to work offline in Outlook while traveling, saving emails and tasks until you reconnect, then automatically send messages once internet access returns.

Explore using Outlook's delay delivery to schedule an email to send later, 'do not deliver before' a chosen date and time, such as 14 March at 9:30 am.

Learn to insert attachments and pictures in Outlook emails, using attach file, browse, and copy-paste methods, and place images in the body with resizing options.

Learn to send emails to multiple recipients in Outlook by copying addresses from an Excel sheet, using semicolon separators, and following the on-screen prompts.

Create and manage physical folders in Outlook to organize emails, move messages with drag-and-drop or the move to option, and select multiple emails using shift-click.

Create rules in Outlook to automatically move emails from a specific sender to designated folders, including applying rules to existing messages.

Explore managing emails by color categories in Outlook, tagging messages with red, blue, green, orange, or purple. Learn to view emails by category and apply colors with shortcuts.

Learn to create and save new contacts in Outlook, including adding a photo and details, and use saved contacts to compose emails from the address book or the context pop-up.

Learn how to import contacts from an Excel CSV into Outlook, map fields like first name, company, and email, and view contacts in various formats for efficient address book management.

Celebrate completing the Outlook training and invite learners to leave reviews. Proceed to the next course.

Complete the MS Office course bundle and apply the learned tools in work or life. The instructor invites reviews, questions in the Q&A, and a bonus discount to keep learning.