PowerPoint FAQ’S
-
A Theme is the overall design.
A Layout is the arrangement of text/images on a single slide.
-
View → Slide Master → Insert logo → Save.
-
Use large fonts (min. 24pt) and simple images. Test by sharing screen before the meeting.
-
Design → Choose Theme → Apply to all slides.
-
Copy chart in Excel → Paste into PowerPoint → Choose “Keep Source Formatting” or “Use Destination Theme.”
-
File → Export → Choose PDF (for slides) or Video (for recording presentations).
-
At least 24pt for text and 32pt for titles.
Outlook FAQ’S
Excel FAQ’S
-
Select the cell → Type =SUM( → Highlight the numbers → Press Enter.
-
A Workbook is the entire file.
A Worksheet is each tab inside the file.
-
View → Freeze Panes → Freeze Top Row.
-
Select the column → Home → Sort & Filter → Sort Largest to Smallest.
-
Example: =A1*0.23 (for 23% VAT in Ireland).
-
Use Drop-down Lists: Data → Data Validation → List → Enter options.
-
A Pivot Table summarises large amounts of data quickly (totals by client, product, or month). Very useful if you handle more than 50+ rows of data.
Word FAQ’S
-
Insert → Header → choose a style → Insert Picture → select your logo → Resize & position → It now repeats on all pages.
-
Save updates the existing file.
Save As creates a new file (useful for keeping versions).
-
Select the image → Click “Layout Options” (icon next to the picture) → Choose “Square” or “Tight” wrapping.
-
Use a free template: File → New → Search “Invoice” → Fill in your details.
-
Insert → Page Number → Choose location (top or bottom).
-
Fonts or layouts may not match on another computer. Always Save as PDF before sending.
-
File → Save As → Choose PDF → Save.
-
File → Options → Mail → Signatures → Create signature → Add name, phone, website.
-
Right-click an email → Rules → Create Rule → Choose condition → Select destination folder.
-
CC: Everyone sees all recipients.
BCC: Recipients are hidden.
-
Calendar → New Appointment → Add time/date → Set Reminder (10 mins, 1 hr, etc.).
-
Right-click Inbox → New Folder → Name it “Personal” or “Clients.”
-
Use the Search Bar above Inbox. Type keyword + sender’s name if possible.
-
Calendar → Share Calendar → Enter their email → Set permissions.
Teams FAQ’S
-
Calendar → New Meeting → Add title, attendees, date/time → Send.
-
Chat is for private conversations.
Teams are group spaces with shared files and channels.
-
During meeting → Share → Choose Window → Select the document only.
-
Yes. Just type their email in the invite, even if they don’t use Teams.
-
Click “More” (…) → Record. After meeting, the link is saved in the Chat/Meeting thread.
-
Check your mic/headset settings → Click “Devices” in Teams → Make sure the right device is selected.
-
Smaller “rooms” within a meeting for group discussions. Create them in Meeting Controls → Breakout Rooms.