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.

DURATION: 5 days

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.

LEARNING OBJECTIVES

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

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

TRAINING COURSE OUTLINE

  1. Protecting your data
  • Workbook protection
  • Protecting cells
  • Protecting structure
  1. Circular references
  • Locating and deleting circular references
  • When circular references are necessary
  • Formula error checking
  1. Range names
  • Defining range names
  • Using names in formulas
  • Navigating with names
  • Using named constants
  • Documenting range names
  1. Importing data
  • Importing CSV files
  • Text import wizard
  • Workbook linking
  • Workbook linking
  • Dealing with broken links
  1. Functions
  • Math and rounding functions
  • The AND function
  • The OR functions
  • Nested IF function
  • The VLOOKUP functions
  • The HLOOKUP function
  • Transposing data
  • Concatenating functions
  • INDEX and MATCH functions
  • Using help for functions 
  1. Data Validation
  • Limiting cell values
  • Creating drop-down cell lists
  • Validation error messages
  1. What-if analysis tools
  • Using goal seek
  1. Data consolidation
  • Consolidation by cell position
  • Consolidation by headings
  1. Exporting data
  • Saving as a different file type
  • Exporting to Word
  • Pasting data with a link
  • Copying a graph with a link 
  1. 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
  1. 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 

VENUE: NobView Hotel-Ntinda

FOR WHOM THE COURSE IS INTENDED

It is intended for individuals and organizations that want to ease their data collection, analysis and reporting process. 

Benefits: 98% practical sessions, Certificate of completion, networking and follow-up after training.

PAYMENT DETAILS

Those Paying in UGX can pay through

  • Account Name: Maarifa Consult
  • Bank: Stanbic Bank
  • Account Number:9030010504731
  • Branch: Ntinda, Branch
  • Account Type: Uganda Shillings Account (UGX)
  • You can deposit cash or write a Check in the Name of “MAARIFA CONSULT”

Pay and Register before 2nd / November /2018

Note: After Payment, please send a proof of payment to the email below

How to Apply: Interested individuals can apply through the website www.maarifaconsult.com
or send an email requesting for a registration form to  info@maarifaconsult.com   or