Basic IT computer task you should know in the office at work

Offer quick technical tips and show how to adjust pace by selecting a different option, then join the group discussion for further details and reviews.

This course teaches essential basic computer skills for office work, how to organize tasks, extract data from large datasets, and use Excel effectively, including handling PTEN documents.

Learn to configure Windows to show file extensions, identify common extensions for documents, Excel, and PowerPoint, and safely handle executable files.

Master the clipboard by copying, cutting, and pasting text and images across apps with shortcuts like ctrl+c, ctrl+v, and ctrl+x, and undo with ctrl+z.

Master Windows file search by navigating to the correct directory, using the search tool, and employing wildcards like asterisks with Ctrl+F to find terms not detected by simple keywords.

Learn how compressed files, especially zip archives, preserve folder structures and reduce email size, and how to create and unzip them using built-in tools or seven zip.

Save your work regularly by using the ctrl+s shortcut to prevent data loss from power outages or software crashes, across Excel, PowerPoint, and other documents.

Learn to capture your desktop with print screen or the snipping tool, then paste into Word, Paint, or Outlook to share context and request help.

Learn quick photo editing using basic tools like crop and highlight in paint to crop screenshots, draw attention with shapes and text, and hide sensitive information before emailing images.

Discover how to download and install a free media player on Windows to play a wide range of video formats, install necessary codecs, and manage file associations for smooth playback.

Learn how to share many files and folders by compressing the folder into a single zip file to preserve the directory structure, and have recipients unzip it.

Learn to send large files beyond normal email limits with WeTransfer; upload, share a download link, and note seven-day expiry for recipients.

Learn essential office shortcut keys for cutting, copying, pasting, undoing, finding, and printing; manage windows with snap and desktop shortcuts to boost daily productivity across Word, Excel, and Outlook.

Compare two blocks of text to identify edits and errors, using side-by-side view, the compare and combine tools, and track changes to approve or reject edits.

Identify and remove confidential information before sharing documents with clients or colleagues; use PDF export or paste as values in Excel to avoid exposing sensitive data.

Learn how to organize tasks with reference numbers, assign sequential numbers by date, and incorporate them into emails and folders to stay efficient, tidy, and professional.

Organize your work by structuring your task folders to keep quotations, approvals, and emails linked to each client, with reference numbers and folders for internal and external resources.

Organize emails into folders to preserve proofs like supplier quotations and budget approvals. Maintain a clear folder structure in Outlook for easy retrieval and evidence of actions.

Zoom into your task directory using reference numbers and folder search to locate the file quickly. Copy the reference number, search root directory, and open the folder to take action.

Learn how Excel stores data efficiently by organizing people and product information in tables, enabling quick retrieval of attributes like nationality, gender, and price.

Understand Excel file types, focusing on xlsx and xls extensions and their backward compatibility with older versions like Excel 2003. Discover how compatibility mode activates when opening older spreadsheets.

Learn to use Excel as a powerful calculator by performing addition, subtraction, multiplication, and division, starting formulas with =, referencing cells, and saving and backtracking complex calculations.

Learn to manage multiple tabs in a single Excel file with multiple sheets, move a sheet to a new file, and use cross-sheet formulas while saving without compatibility issues.

Master Excel's search and replace features to locate items across large sheets, find all instances, and apply replacements with options like match case.

Explore handling data tables in Excel by using header arrows to filter and sort, apply multi-criteria filters, and preserve data integrity with full-table selection and undo.

Master freeze frame to keep the top header visible while scrolling, and use the split frame to create four panes for flexible navigation in large data tables.

Master vlookup to automatically cross-reference two data tables by item code, returning corresponding item title, using a table array, column index, and exact match, then paste values to lock results.

Learn how to resize the print area in Excel, use page break preview to ensure costs or sensitive data stay hidden, and preview the printout before exporting to PDF.

Learn how to open Excel in multiple instances, creating a new Excel window and moving a second file into it to compare side by side.

Master Excel pivot tables for data analysis by counting group occurrences, inserting a pivot table, setting values to count, and quickly summarizing scattered data.

Explore the portable document format, a cross-platform file type that preserves text, fonts, and graphics, enabling reliable sharing and readable documents across devices.

Compare pdf readers and prefer foxie pdf reader for free use, then download and install it, adjusting basic settings and safety to avoid viruses.

Master basic pdf manipulation on a PDA using Foxit Reader, including zooming, side-by-side page view, continuous spacing, separate page view, and rotating large documents for easy reading.

Discover how to convert documents to pdf using a virtual PDA printer, install the software, and save or share Word, Excel, email, and image files.

Extract two relevant pages from a large pdf using free tools, avoiding paid software. Ensure the extracted pages are text searchable and copy-paste friendly for professional sharing.

Learn to open PDFs in multiple windows to read documents side by side, enable multiple instances in preferences, and cross-reference content.

Learn to cut and paste text and pictures for easy sharing with colleagues, using copy and paste, Ctrl-C, Ctrl-V, and snapshot techniques to include diagrams in emails.

learn to cut and paste as plain text rather than as images, using text-based copy (ctrl-c) and pasting as text to keep emails professional and readable.

Convert image text to editable text using OCR tools like Foxit Phantom to enable copying and searching, while noting accuracy limits and confidentiality concerns.

Master commenting on documents with call-out for specific items and general comments for whole pages, then save, track, and resolve feedback from collaborators and suppliers before finalizing proposals.

Explore how password-protected pdfs prevent copying and screenshots, learn common reasons for locking documents, and consider practical workarounds plus privacy cautions when using online unlock services.

Use Foxit's multiple file search to scan all pdfs in a folder for balance sheet terms and retrieve all matching instances.

Learn daily IT essentials and basic office skills, including cutting and pasting, saving work, screenshots, file creation, and organizing information with folders; plus a light Excel intro and PDSA professionalism.