Advanced Excel, PPT and Word Training

Advanced training courses - Excel, PowerPoint, Word and Outlook

Each advanced training course is tailored to the people attending the training. Everyone will fill in a training needs form, and only the topics that you need training on will be covered during the training,

The training will also use your own spreadsheets or documents, so any questions can be answered instantly and your spreadsheets and documents will be improved.

Are you looking for an Advanced Excel, PowerPoint, Word or Outlook refresher course?

The trainer will be available after the training for questions via phone or email.

In Central London, The City, Canary Wharf, West End, NW London and the surrounding areas.

Suggested Advanced Excel Topics include:

• Advanced Formatting
• Sort and filter information in your spreadsheets
• Split and freeze worksheets
• Advanced Formulas including vlookups, Hlookups, IFs, SUMIF, Average, Autosum
• Pivot tables
• Pivot charts
• Charts
• Text to columns
• Group Columns / Rows
• Sparklines
• What-if analysis
• Advanced Conditional Fomatting
• Drop-down lists
• Spreadsheet Macros
• Advanced Excel tips, tricks and shortcuts

Suggested Advanced Word Topics include:

• Inserting tables
• Adding images
• Creating text boxes
• Adding WordArt
• Inserting and formatting shapes
• Spell checking and using the thesaurus
• Previewing, printing and saving a document
• Finding and replacing text
• Adding page numbers and page breaks
• Using and applying Styles
• Inserting and updating cover page and contents page
• Advanced Footnotes and cross-references

Suggested Outlook Topics include:

• Diary management:
• Private meetings
• Suggest a new time
• Categorising meetings
• Sorting and categorising emails
• Adding contacts and distribution lists
• Setting up filters
• Using Rules

Suggested Advanced PowerPoint Topics include:

• Creating an advanced PowerPoint presentation
• Changing presentation views
• Updating colour scheme
• Inserting and editing SmartArt graphics in your PowerPoint presentation
• Adding advanced animation
• Using slide masters to customise a PowerPoint presentation
• Producing an advanced PowerPoint slide show
• Previewing PowerPoint slides and saving presentations
• Inserting, editing and updating charts
• Adding transitions to your PowerPoint slides
• Inserting and updating tables
• Adding and editing bullet points
• Using indentation on your PowerPoint slides
• Inserting screen shots and screen clips