Microsoft Office suite(Latest) | VBA and Macro

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 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 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 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.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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 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.