Topics
Computer Basics
Microsoft Word
Part 1
Learn the Word interface, Ribbon, OneDrive integration, and how to create, format, print, convert to PDF, and upload documents.
Part 2
Covers basic text editing: cut, copy, paste, formatting text, adjusting spacing, using Find and Replace, and creating lists.
Part 3
Learn to format documents with hyperlinks, columns, headers, footers, page numbers, and structured headings.
Part 4
Enhance documents with images, text boxes, tables, charts, and watermarks; includes formatting and image tools.
Part 5
Covers indents, tabs, comments, track changes, writing tools, document protection, and mail merge for personalized content.
Microsoft Excel
Part 1:
Opening, saving, managing workbooks, formatting cells, sorting/filtering data, using Find and Replace, and preparing files for printing.
Part 2:
Boost efficiency with features like Paste Special, basic formulas (SUM, AVERAGE, COUNT), text functions (LEFT, MID, RIGHT, TRIM), chart creation, and keyboard shortcuts.
Part 3:
Use “Go to Special” for quick data selection and create pivot tables to summarize and analyze large datasets.
Part 4:
Enhance organization with templates, named ranges, drop-down lists, and conditional formatting for dynamic cell styling.
Part 5:
Improve data management with Excel tables, Flash Fill, column splitting, CONCATENATE, Quick Analysis, and Sparklines for visual trends.
Part 6:
Master advanced functions: IF, COUNTIF, SUMIF, IFERROR, VLOOKUP, and INDEX MATCH. Learn Power Query to clean, merge, and manage complex data.
- 2017 Order Data.xlsx
- 2018 Order Data.xlsx
- 2019 Order Data.xlsx
- 2020 Order Data.xlsx
- Advanced Excel Skills 2.xlsx
- Microsoft Excel - Part 6.pdf