Microsoft Office suite(Latest) | VBA and Macro

Learn how to format characters in a word document by applying bold, italics, and underline; adjust font size, color, and case; add subscripts and superscripts; and reset formatting.

Master the character formatting dialog to apply font, size, color, superscript, subscript, and all caps, with spacing controls and live previews. Learn how to set defaults for consistent formatting.

Explore paragraph formatting in Microsoft Word, mastering justification, alignment, indentation, and multi-level lists—numbered, alphabetical, and roman—plus spacing and background color for professional documents.

Master paragraph formatting in the latest office suite, adjusting spacing, keeping paragraphs together, and managing page breaks, with options for line numbers and suppression.

Set up a Word document by adjusting margins, orientation, and page size, and explore columns, section breaks, and custom margins to format content effectively.

Explore creating and applying custom themes, headers and footers, and page layouts in Word, including color schemes, fonts, margins, page numbers, symbols, and printing options.

Learn image formatting in Microsoft Office: convert charts to images, remove backgrounds, adjust brightness, contrast, color, and shading, apply artistic effects, crop, rotate, and compress images for formal documentation.

Learn how to remove image backgrounds in Microsoft Word using the background removal tool, select areas to keep, and adjust image position to create clean, composite visuals.

Explore creating and editing headers and footers with top or bottom placement, apply page numbers and document properties, and insert a hyperlink to a URL via the insert menu.

Learn how to create envelopes and labels using mail merge in Microsoft Word, manage recipient lists, set return and delivery addresses, preview results, and send letters or emails.

Explore view options in Microsoft Word to read with zoom and reading modes, navigate documents, and adjust margins, fonts, and page view for efficient editing.

Explore advanced table formatting in Excel, covering expandable layouts, properties, insertion, splitting and merging cells, alignment, auto-fit, and formulas to manage large data tables.

Explore how to proof and review a Word document using spell check, grammar, language settings, translate, and track changes, with comments, revisions, and page statistics.

Explore track changes and review options to manage edits in Word documents. Learn how to view, accept or reject revisions, toggle markup, view original versions, and enforce editing restrictions.

Create and update a table of contents linked to headings, manage spacing and numbering, and insert footnotes for professional reference in documents.

Explain permissions and document protection, including encrypted access, restricted edits, and digital signatures, to control access and sharing via SharePoint and version history.

Explore Excel basics in this VBA and macro course, learning to navigate the interface, manage data with lists and tables, create charts and dashboards, and automate tasks with macros.

Master cell formatting in Excel by applying text, number, and percentage formats. Convert data types, use autofill, and apply efficient selection techniques to manage data.

Explore autofill for rapid data entry, copy or apply existing formatting with fill options, and convert numbers to currency or percentage while controlling decimals and locale separators.

Explore essential Excel operations for managing workbooks, including creating and renaming sheets, moving or hiding sheets, protecting sheets with a password, and using freeze panes, zoom, side-by-side views, and comments.

Learn to create and manage named ranges in Excel, use the name manager to assign names to cells or ranges, and apply them in formulas like sum and average.

Master cell formatting in Excel by applying date, text, number, currency, and fraction formats, then explore copy and paste options, including values, formulas, links, and transposed data.

Master searching and commenting in Excel with find, replace, and match case, learning how to locate, replace values, and insert or view comments across sheets.

Explore cell borders, color options, and merging or un-merge operations, and apply the format painter to copy formatting across cells.

Create and format tables in Office, add headers, and manage rows and columns. Master sorting, filtering, and table designs, and export tables or integrate with VBA macros across SharePoint workflows.

Explore fonts in Excel, learn to switch font families like Cambria and Arial, adjust font size, and observe how font changes affect cell appearance and formatting.

Explore styles and themes in Excel, learn to insert shapes, apply colors, textures, and 3-D effects, and use default themes to create a consistent look across an Excel sheet.

Explore file recovery and protection strategies for Excel workbooks, including how to manage production copies, restrict edits, apply signatures, and audit access through logs.

Learn how to create formulas in Excel using cell references, basic math operations, and conditional functions, while managing dependencies and copy-paste behaviors.

Explore how to use formulas in Excel, including functions and arguments, text and left functions, if statements, random and aggregate operations, and copy, paste, and convert formulas to values.

Explore frequently used Excel formulas and functions, including equals, plus, concatenation, and the left, right, and mid functions, plus removing spaces.

Explore frequently used Excel formulas, including count, blank handling, lookup and match, min and max, round, random, mean, mode, rank, and absolute value.

Explore how absolute and relative references in Excel affect formula behavior, using dollar notation and examples across January to March turnover values.

Explore date functions and formulas in Excel to handle formats, convert dates, and perform date arithmetic, including adding days and weeks and generating weekly dates.

Learn how to insert and format images in Excel, including inserting from a file or Bing search, copying and pasting, adjusting brightness, color, borders, and compression.

Learn how to create and customize charts in Excel, including inserting column charts, formatting elements, changing colors, adding or copying charts, and printing charts for beginners.

Learn to create pivot tables in Excel, organize data by column headers and index values, and apply calculations such as sum, average, max, and min to regional data.

Explore conditional formatting and sparklines in Excel, including color scales, data bars, traffic lights, top/bottom rules, above/below average, and sparklines to visualize stock market trends.

Explore Excel’s graphics options, including inserting shapes, pictures, and smart grid visuals, to graphically represent data with charts and diagrams.

Master vlookup in Excel to extract data from large tables, perform cross-sheet lookups, and choose between exact and approximate matches with practical copy-paste steps.

Learn how to use hlookup in excel to perform a horizontal lookup, compare it with vlookup, select the table array, and retrieve matching values from a specific row.

Explore why index and match improve excel lookups and how to retrieve a value from a table using these functions with exact match and absolute references.

Apply data validation in Excel to restrict inputs and create lists, using a predefined source, selecting from a list or custom values, and handling blanks.

Explore other data validation options in Excel, including ignore blanks, between, greater than, and custom formulas, to enforce cost ranges and data integrity with VBA and macros.

Explore data validation in VBA and macro workflows for Microsoft Office, focusing on error messages, warnings, and informational popups for restricted fields like car manufacturer values.

Learn how input messages in data validation guide users, explain why a value must fall within a specified range, and demonstrate implementing these messages to prevent invalid entries and improve usability.

Learn to create dynamic lists of values using data validation and dependent drop-downs sourced from selected fields, and configure data input messages to guide users.

Discover how pivot tables summarize large data with a single click, organizing totals by region and item through rows, columns, values, and filters.

Learn to modify and format a pivot table by dragging fields into rows and columns, choosing value options like average and maximum, and applying grouping; refresh to see updates.

Explore styling pivot tables with banded rows and colors for a professional, readable design. Learn to gather data, apply filters, and drill into results to extract specific insights.

Explore how pivot charts automatically reflect pivot table filters to produce dynamic visuals, and learn to customize colors, chart types, and formatting for clear presentations.

Explore pivot table filtering and the slicer tool to refine data views, apply single or multiple filters, and update dashboards with dynamic, focused insights.

Power Pivot introduction shows how to combine two or more tables from different data sources in Excel to create a unified data model for analyzing revenue and nonprofit data.

Activate power pivot in excel by navigating to options and managing add-ins. Enable features through plugins and add-ins, and adjust settings to customize the experience.

Learn to customize a data model in Power Pivot by adding tables, creating relationships, and using the diagram view to link data sources within a workbook.

Learn to create a Power Pivot relationship in Excel, link tables and columns, and analyze the exact sum of profit by representative with percent insights.

Learn to create calculated fields in Power Pivot to compute profit, counts, distinct values, and averages, and to format results and manage relationships in the data model.

Explore how to use Power Pivot KPI to validate each representative's profit by calculating average net profits, creating performance categories, and building a graphical KPI dashboard for executives.

Trace formula auditing to see how precedents and dependents connect cells, and how changes in gross profit or net profits propagate across the worksheet.

Use watch window and show formula to inspect formulas and monitor changes across cells. Apply formula auditing to review formulas for errors and print formula views to share findings.

Discover macros in microsoft office to automate daily repetitive tasks and generate reports, saving time. Macros store step sequences and can run via button or manual trigger.

Create your first macro in Excel by recording steps, naming it without spaces, and assigning a keyboard shortcut, then set its storage scope for reuse.

Learn to edit and save macros in Excel using VBA, including how to manage macro storage, proper naming, and sharing macro-enabled workbooks.

Learn to run a VBA macro from a form in Excel using form controls and buttons, manage macro naming conventions, and ensure data is saved before executing the macro.

Develop a VBA macro to automate weekly incident reports, generate a trend chart from the last three weeks, and deliver the data to stakeholders using a consistent worksheet setup.

Explore the basics of VBA and the VBA editor in Excel, learn to create your first macro with if statements and loops, manage procedures, and save as a macro-enabled workbook.

Create VBA modules and procedures, insert procedures, define functions, and configure scope (public or private) to control access, with examples of project code and local variables.

Launch your first VBA program by creating a simple macro, learn to declare and use variables, choose data types like string and integer, and print results to a worksheet.

Discover how to build if statements in VBA to compare values, branch logic, and print results, including using offset and multiple conditions.

Explore loops in VBA by implementing if conditions, incrementing values, and moving between cells, while learning how to set colors, store values, and manage in memory variables.

This project introduces VBA macros by recording a macro to format a sheet and apply it across all sheets, then integrating the macro to loop through sheets.

Record a macro to format data, create headers, set values like country, apply colors and borders, store the macro in the workbook, and explain integration into worksheets.

Learn how to integrate a macro with VBA code to automate across worksheets, create procedures and functions, and run and manage macros within a workbook.

Harness autosum across all sheets with a single click using VBA, looping through worksheets with nested loops to sum values efficiently.

Learn how to create a basic autosum macro in VBA by setting up a module, defining variables, and using offset and a sum formula to automate cell sums.

Learn to build a VBA automation with variables and nested loops to perform autosum-like tasks across worksheet data, including loop control, data handling, and step-by-step debugging.

Learn to automate data consolidation and formatting in Excel using VBA macros across multiple sheets, including header creation and applying formatting with a single macro to save weekly reporting time.

Leverage existing VBA code and macros to automate data extraction across multiple sheets, apply formatting, and generate a final report from quotes.

Finalize the VBA project by building the final report with headers and formatting, copying data across ranges, and using loops and integer variables to control tests on the portal sheet.