Microsoft Excel: Intermediate Skills and Techniques

Microsoft Excel: Intermediate Skills and Techniques

₦10,750.00 – ₦16,125.00 incl. VAT

Take your Microsoft Excel skills to the next level with this intermediate course. You will learn how to use advanced excel functions to perform complex calculations and data analysis, create dynamic charts that automatically update with your data, apply conditional formatting and data validation to enhance your worksheets, and troubleshoot errors in formulas and data. You will also discover how to work with multiple worksheets and workbooks, link them with external references and hyperlinks, import and export data from different sources, and create interactive dashboards for better decision-making.

This course is designed for intermediate Microsoft Excel users who want to improve their efficiency and productivity. You should have a basic understanding of Microsoft Excel before taking this course.

-
+

Description

Key Learning Objectives:

  • Explore logical, lookup, text, date and time, alongside array formulas and nested functions.
  • Select suitable chart types, tailor chart components, adjust chart axes and data series, incorporate trendlines and error bars, and create dynamic charts for automatic updates.
  • Apply rules and icons based on specific criteria, develop customized formats and formulas, validate data inputs, and pinpoint and rectify formula and data inaccuracies.
  • Arrange worksheets with grouping, tabs, and color schemes, amalgamate data from diverse sources, create formulas referencing other workbooks or worksheets, and embed hyperlinks for accessing web pages or documents.
  • Establish connections with external data sources, manipulate and filter data, update data connections, and export data into alternative formats.
  • Construct interactive dashboards to present key metrics for informed decision-making, employ slicers and timelines for interactive data filtration, and leverage Power View for interactive report generation.

Customer reviews

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may write a review.