• Home
  • Login
  • Welcome to the Staff Intranet
YOU ARE HERE: Skip Navigation LinksEdinburgh Napier Staff Intranet > Learning Events
Excel (advanced level) - online

 

Event Date: 25th May 2022

Event Times: 09:30 - 12:30

Venue: MS Teams

Lead Facilitator:

Type:

Provider Details: Learning and Development, learninganddevelopment@napier.ac.uk

Event Description:
This course is delivered in partnership with Edinburgh College, through the Flexible Workforce Development Fund (FWDF) - a government initiative that is used to strengthen in house training and development by working with local Scottish colleges, who administer the fund.

The course will cover the following topics:

Macros

• Record Macros
• Editing & Deleting Macros
• Customising Ribbon

Review Data

• Track Changes
• Review Changes
• Auditing Tools
• Restricting Data Area

Utilities

• Create Scenarios
• Goal Seek
• What – IF Analysis
• Data Consolidation
• Drawing Diagrams
• Pivot Tables
• Pivot Table Charts

Additional Items & Formulas

• Conditional Formatting – ICONS
• Sparklines
• Concatenate – Left, Right, Mid, Upper, Lower
• Screen Shots
• VLookup
• IF Statements
• SumIF
• CountIF
• Text Formula
• Linking Spreadsheets


Further information on HRConnect or by contacting event provider.

Back to events