Overview
In this course, 5 Excel Skills every marketer should know and master are presented to participants. It is a compilation of tried and tested skills and techniques put together in partnership with marketing practitioners that satisfy the rudiments of everyday sales and marketing tasks. The tools treated cover optimizing data entry, analysis and trend analysis.
Objectives
At the end of this course, participants should be able to build and organize data; extract reports; create and customize charts as well as monitor trends in their data sets. Participants should also be able to protect worksheets and workbooks and deal effectively with all issues concerning printing of documents in MS Excel.
-
Intermediate
-
18 Hours
GHC 650
Per Participant
Content
Table Formatting
- Summarize with Pivot Tables
- Remove duplicates
- Convert to Range
- Insert Slicers
- Filtering
- Inserting automatic Totals
- Banding columns & Rows with Table Styles
Charting
- Conditional formatting to chart – simple
- Conditional formatting to chart – advanced
- How to chart from Excels pool of chart options – Basic
- Advanced Excel Charting, e.g., Speedometer, Thermometer
Pivot Tables
- Step by step approach to build a PT
- Drill up & down
- Insert slicers
- Group & Ungroup data
- Refresh data
- Change Data source
- Band column & rows
- Calculations in PT – Simple
- Calculations in PT – Advance
Functions
- IF
- SUMIF
- SUMIFS
- COUNTIF
- COUNTIFS
- VLOOKUP
- AVERAGEIF
- AVERAGEIFS
- NESTED FUNCTIONS
- ARRAYS
Advanced Filters
- OR logical test
- AND logical test
- Wild cards
- Placing formulas in Advanced Filter criterion
Course Reviews
Facilitator(s)
Richard Lamptey
Richard Odartey Lamptey has worked in the private sector for a period spanning over eight (8) years. He has consulted...