Microsoft Office Management Training Course

Explore the Microsoft Word 2016 interface from a blank document to the ribbon, covering file options, formatting tools, insert features, themes, layout, and view modes.

Learn essential text formatting in Word, including font type and size, bold, italic, underline, color, strikethrough, superscript and subscript, case changes, highlighting, and format painter.

Learn to find and replace in Microsoft Word: search for a word, swap it, and use replace all, demonstrated with Microsoft Word and Excel.

Master inserting cover pages, tables, pictures, shapes, charts, and more using Word's insert menu. Learn to add headers and footers, text boxes, comments, hyperlinks, and symbols.

Explore how to design a Word document by applying themes, customizing colors and fonts, adjusting paragraph spacing, and adding watermarks, borders, shading, and page color.

Learn to create and design tables in Microsoft Word by inserting and drawing tables, applying design styles, and editing structure with insert, delete, merge cells, and borders.

Explore using the view menu in Microsoft Word to switch between print, read, and web layouts; adjust ruler, grid lines, navigation pane, zoom, and window switching.

Master cut, copy, and paste in Excel and apply the format painter to transfer formatting. The lesson also covers keyboard shortcuts, selecting cells, and the differences between copy and cut.

Learn how to format worksheets using the font tools under the home menu, including bold, italic, underline, and double underline, and how to apply fonts, sizes, colors, fills, and borders.

Learn to use the alignment tools in the home menu to format text in Excel, including left, center, right alignment, wrap text, indent, orientation, vertical text, and merge options.

Learn to apply various number formats in Excel using the Home menu, including currency, date, time, percentage, and text, and adjust currency types and decimals.

Explore using style tools under the home menu to apply styles, conditional formatting, and table formatting, with rules for greater than, between, or equal values and color schemes.

Master inserting and deleting cells, rows, and columns in Excel, and use the home menu to format and hide or unhide rows and columns.

Learn to create multiple worksheets, name them, duplicate, move or copy, and permanently delete sheets within a single workbook.

Learn to create and use pivot tables from the insert menu to filter large data, summarize sales by region, and perform counts, averages, and other aggregations in Excel.

Learn to create charts from table data, customize them with design and format options, explore pie and 3D charts, and introduce sparklines for compact data visualization using the insert menu.

Discover how to create and customize pivot tables in Excel and link them with slicers to filter region-based sales data visually.

Learn to use the insert menu text tools to add text boxes, headers, footers, and automated page numbers, and apply word features to format documents and worksheets.

Explore using text tools under the insert menu to add text boxes, watermarks, and headers and footers with page numbers, plus insert equations and symbols.

Master the Excel page layout tools to adjust margins, orientation, scaling, page breaks, and print options, preview your prints, and print selections with confidence.

Learn to use Excel formulas for everyday data tasks, including sum, autosum, multiplication, tax calculations, and average, plus min, max, count, and count blanks for stock quantity and stock value.

Learn to use the if function in Excel to categorize stock values into A, B, and C grades using thresholds of 30 and 20, with extensions for large data.

Master data validation in Excel by using lists to restrict input, displaying dropdowns, configuring error messages and alerts, and identifying invalid data.

Master the text to columns tool in Excel to split first and last names from client data using space as a delimiter.

Learn to forecast profits in Excel using manual and automatic methods. Build historic data, apply the forecast function, and use the forecast sheet to visualize future profits.

Use the spelling checker under the review menu in Excel to identify and correct misspellings, review suggestions, and finalize text with the built-in dictionary.

Explore workbook views from the view menu in Excel, including normal, page break preview, and page layout, and learn to adjust print scaling and margins to fit one page.

Explore window tools under the view menu in Excel to manage multiple documents, including new window, arrange options (tile, cascade, horizontal, vertical), freeze panes, and switch to windows.

Explore the Microsoft PowerPoint interface, including the title bar, ribbon, quick access toolbar, and file menu, and learn how to create, save, customize, and export presentations.

Explore how to use the file menu in Microsoft PowerPoint, including save as vs save, open and browse from desktop, and exporting to PDF, printing, sharing, and other options.

Explore PowerPoint slide layouts and formatting tools, including font selection, size, bold/italic/underline, text shadow, case options, spacing, highlighting, and color customization, plus inserting images and bullet points.

Explore how to use text tools under the insert menu in PowerPoint, including creating text boxes, headers and footers, date and page numbers, notes, and comments, with formatting tips.

Learn to add transitions in PowerPoint from the transitions menu, preview effects such as fade and push, and set duration and timing for all slides.

Learn to add animations and transitions to slide text in PowerPoint, using fade or fly in, and sequence them with shapes. Preview across a slideshow from beginning.

Explore PowerPoint's review menu tools to polish slides. Check spelling, run accessibility checks, translate text, and add or delete comments to streamline review and collaboration.

Master the tell me what you want to do tool in Microsoft PowerPoint to quickly insert tables, icons, comments, and new slides, making tasks faster and easier.

Explore Microsoft Access, a user-friendly relational database management system that lets you create tables, forms, queries, reports, and relationships to store and manage data across multiple tables.

Explore how data becomes information through processing in Access, and define data types for each field: text, memo, number, date/time, currency, auto number, yes/no, hyperlink, attachment, and lookup wizard.

Discover how to create a Microsoft Access database quickly using templates, including an inventory tracking template, then customize pre-made tables, upload images, and tweak details for a professional result.

Update field properties in an Access table by changing data types and formats in design view, add a new numeric contact number, and enforce required fields.

Master formatting in Microsoft Access by using view modes, data sheet and design view, perform copy-paste, sort, find and replace, and apply font, alignment, and grid options.

Open an Access table, add and delete rows and fields, edit records in datasheet and design views, and ensure unique IDs auto-increment for new records.

Learn to set up primary keys and indexes in a table, using an auto number ID to ensure uniqueness and prevent duplicates, and optimize data retrieval.

Create and manage relationships between tables in Microsoft Access by linking primary keys, establishing one-to-one and one-to-many relationships, and enforcing referential integrity across orders and customer tables.

Create a form in Microsoft Access to enter and display order data, using the form wizard to select fields and add buttons that automate functionality across related tables.

Learn to create a query in Microsoft Access using the customer and orders tables to identify paid and unpaid customers and obtain contact details.

Create and customize reports in Microsoft Access from query results using the report wizard, selecting fields like customer name, customer ID, price, and payment status, for management review.