Microsoft Excel - Intermediate

This course is aimed at users who have a basic knowledge of Microsoft Excel and would like to progress in this area.

Description

  • V-Lookup 
  • IF Statements 
  • Sum-IF
  • Count-IF
  • Text Formula 
  • Linking Spreadsheets 
  • Advanced sort options 
  • Filters 
  • Subtotals 
  • Pivot Tables 
  • Modifying Pivot Tables 
  • Updated Pivots 
  • Conditional Formatting 
  • Protecting Data 
  • Hide and Unhide Data 
  • Named Ranges 
  • Working with Dates 
  • Working with comments 
  • Data Validation 
  • Headers and Footers 

Similar courses

Microsoft Office 365

More Information

Microsoft Word Introduction - 2010

More Information

Microsoft Power BI is a data analytics and visualization tool that allows you to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight.

More Information

Learn and understand the important features of Outlook and Internet.

More Information

Microsoft Project 2019 is a project management and scheduling tool that helps you organize, manage, and control defined variables. From everyday tasks to complex projects and programmes, Microsoft Project combines powerful planning capabilities with advanced collaboration tools to help you set realistic expectations, manage time, personnel, and resources to stay on time and budget.

More Information

Attending this course will give learners a foundational understanding of SharePoint. Learners also be taught important terminology like Office Groups, Organisations, etc.

More Information