- Creating spreadsheets
- Entering and Editing
- Number formats
- Navigation
- Resizing Columns
- Highlighting & Formatting
- Creating formula
- Formatting and printing
- Create formula
- Totals
- Printing and layout
- Headers and Footers
- Totalling and entering data
- Sum/Min/Max and Average
- Basic Tables
- Absolute cells references
- Working with Multiple Sheets and files
- Formula Revision / Absolute Cells References
- Inserting, Deleting, Moving and Copying Sheets
- Renaming Sheets
- Grouping Sheets
- Creating Linking and 3-D Formulas
- Linking Workbooks
- Creating Charts
- Creating column, line and bar charts
- Creating charts on different sheets
- Formatting Charts
- Printing Charts
- Working with Tables and lists
- Sorting and filtering
- Conditional Formatting
Available face to face and online. Contact us today to get started.
- PowerQuery
- Remove Duplicates
- Text Functions
- Flash Fill
- Data Validation
- Dynamic functions (Excel 365 only)
- If Functions
- Using Vlookup formula
- The new Xlookup (Excel 365 only)
- Creating and Manipulating Pivot Tables
- Sum ifs/count ifs/average ifs
- Macros
- Creating a document
- Entering and editing text
- Saving, closing and opening a document
- Selecting text
- Text and paragraph formats
- Spelling and grammar check
- Bullets and numbering
- Borders and shading
- Cut, copy and paste
- Changing page orientation
- Setting margins
- Printing and previewing the document
- Keyboard and productivity shortcuts
- File Formats and Compatibility
- Paragraph alignments and indents
- Multi-level Bullets and Numbering
- Working with Tables
- Applying and modifying styles
- Working with Headings
- Navigation Pane
- Table of contents
- Section breaks in long documents
- Apply different page formats
- Templates
- Using Fields
- Mail Merge
- Creating styles
- Appling and modifying styles
- Adding headers and footers and page numbering
- Table of contents
- Creating a template
- Editing and renaming templates
- Inserting ClipArt and WordArt in to a document
- Creating and manipulating pictures
- Quick Parts
- Autotext
- Fields
- Macros
For those new to Powerpoint or wanting to recap on the basis. This will show you have to produce slides, and create a presentation, as well as some shortcuts and tips.
Learning outcomes will include:
- Working with Slides and Layouts
- Viewing and Navigating with Sections
- Formatting Slides
- Creating and updating charts
- Insert Word Tables
- Creating Smart Art and Organisational Charts
- Using the slides master to add logos
- Headers and Footers
- Inserting pictures and graphics
- Using Video and Sounds
- Finalising the presentation with animation and transition
- Notes, Printing and file formats
Available face to face and online. Contact us today to get started.
- Creating Templates
- Slide Masters and master layouts
- Working with graphics and pictures
- Including Movies and Sounds
- Re-use slides from other presentations
- Hyperlinks and Action Buttons
- Exporting the presentation to different formats
- Customising Powerpoint
- Shortcuts
- Productivity Hints and Tips
- Custom Animation
- Creating a video of your slide show
Available face to face and online. Contact us today to get started.
- Creating and Addressing Mail
- Spell Checking and formatting
- Sending & receiving mail
- Replying/forwarding
- Out of Office Assistant
- Creating Folders and subfolders
- Viewing the calendar screen
- Creating appointments and setting reminders
- Duplicating appointments & recurring appointments
- Amending/deleting appointments
- Rescheduling/adjusting duration
- Creating an event or a meeting
- Adding a contact
Available face to face and online. Contact us today to get started.
- Tips for managing mail
- Setting Rules for incoming mail
- Conditional formatting of messages
- Working with categories, and flags
- Using different views
- Using Quick Steps
- Sharing Calendars
- Tasks and To Do
- Email Templates
- Creating a distribution list
Available face to face and online. Contact us today to get started.
- What is Sharepoint/One Drive
- Accessing files
- Best practice for using Word/Excel/Powerpoint within Sharepoint
- Autosave and Versions
- Creating and Managing a Team
- Conversations and Files
- Meetings
- Customising teams
- Using Channels
- Using Chat
- Adding Apps to Teams
Available face to face and online. Contact us today to get started.
