Training Date 22 May - 25 May, 2025
Training Mode Physical
Venue Maarifa Consult office
Apply Now

The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

In this course, you will learn how to perform data analysis using Excel’s most popular features. You will learn how to create pivot tables from a range with rows and columns in Excel. You will see the power of Excel pivots in action and their ability to summarize data in flexible ways, enabling quick exploration of data and producing valuable insights from the accumulated data. Pivots are used in many different industries by millions of users who share the goal of reporting the performance of companies and organizations. In addition, Excel formulas can be used to aggregate data to create meaningful reports. To complement, pivot charts and slicers can be used together to visualize data and create easy to use dashboards.

Who Should Attend?

This advanced Microsoft Excel training course is ideal for people wanting to use more complex functions within Excel, including tools for analyzing, linking and exporting data. Participants will need to have attended or be familiar with the basics of Microsoft Excel.

Certification

Upon successful completion of this training, participants will be issued with a certificate of completion.

objectives

By the end of the course, participants will be able to:

  • Protect a workbook and save with a backup
  • Understand and use advanced functions
  • Consolidate data, link and export data
  • Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
  • Create and modify PivotTables and Pivot Charts
  • Create and modify Microsoft Excel Macros
  • Create flexible data aggregations using pivot tables
  • Represent data visually using pivot charts
  • Calculate margins and other common ratios using calculation on pivot table
  • Filter data using slicers in multiple pivot tables
  • Create aggregate reports using formula-based techniques

Outline

  • Protecting your data
      • Workbook protection
      • Protecting cells
      • Protecting structure
  • Circular references
      • Locating and deleting circular references
      • When circular references are necessary
      • Formula error checking
  • Range names
      • Defining range names
      • Using names in formulas
      • Navigating with names
      • Using named constants
      • Documenting range names
  • Importing data
      • Importing CSV files
      • Text import wizard
      • Workbook linking
      • Workbook linking
      • Dealing with broken links
  • Functions
      • Math and rounding functions
      • The AND function
      • The OR function
      • Nested IF function
      • The VLOOKUP functions
      • The HLOOKUP function
      • Transposing data
      • Concatenating functions
      • INDEX and MATCH functions
      • Using help for functions
  • Data Validation
      • Limiting cell values
      • Creating drop-down cell lists
      • Validation error messages
  • What-if analysis tools
      • Using goal seek
  • Data consolidation
      • Consolidation by cell position
      • Consolidation by headings
  • Exporting data
      • Saving as a different file type
      • Exporting to Word
      • Pasting data with a link
      • Copying a graph with a link
  • PivotTable reports
      • Create a PivotTable
      • Rearranging data
      • Applying filters
      • Adding fields
      • Modify field settings
      • Refreshing data
      • Formatting a PivotTable
      • PivotCharts
      • Creating a PivotChart
      • Filtering a PivotChart
  • Macros
      • Recording a Macro
      • Editing a Macro
      • Relative/Absolute Recording
      • Stepping through a Macro
      • Macro buttons
      • Customizing the toolbar
      • Writing a line of code
      • Deleting a Macro

Approach

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies. Training manuals and additional reference materials are provided to the participants.

Tailor-Made

We can also do this as a tailor-made course to meet organization-wide needs. Contact us to find out more: training@maarifaconsult.com / and cc    maarifaconsult@gmail.com

OR Call us on +256774361213

Fees & Payment

Fees Ugandans: UGX400000 International: USD200

The training fee covers tuition fees, learning materials, Lunch & Breakfast. Payment should be sent to our bank account before start of training and proof of payment sent to training@maarifaconsult.com /or maarifaconsult@gmail.com

 

Bank Account can be Requested.