Training on Advanced Microsoft Excel for Reporting & Analysis

Project status
Project start date
19 Apr 2018
Project posted
25 Mar 2018 12:19
Project duration (approx.)
3.0 Days
Budget (approx.)
$400 / day
Level of Experience
Mid-level
Area of expertise
Analyst / Research , Finance and Accounting
Consultant location
On-site
Location
Qatar
Languages
English (Essential)

Objectives and Key Deliverables

This course covers how to work more efficiently with workbooks and worksheets, enhance the appearance of data and worksheets, perform analysis using functions and use the sorting and filtering features to manage and analyse data.

The ideal candidate should be currently based in Qatar or the MEA region.
Accommodation/Travel/Daily allowance provided by the client.

Upon successful completion of this course, students will be able to:
 Use the fill operations available to fill a data series
 Understand and use formula cell referencing to create more complex formulas
 Use a range of logical functions
 Apply conditional formatting to ranges in a worksheet
 Create and use labels in a workbook
 Work with various elements of a worksheet
 Use a range of techniques to work with worksheets
 Use a range of find and replace techniques
 Apply a variety of page setup techniques
 Sort data in a list in a worksheet
 Filter data in a table
 Create effective charts in Microsoft Excel
 Use a range of techniques to enhance charts
 Apply formatting techniques to text on charts

Module (01) Conditional Formatting
1.1 Formatting Cells Containing Values
1.2 Clearing Conditional Formatting
1.3 More Cell Formatting Options
1.4 Top & Bottom Ten Items
1.5 Working With Data Bars
1.6 Working With Colour Scales
1.7 Working With Icon Sets
Sparkline (New feature)
1.8 Creating Sparklines
1.9 Editing Sparklines
Module (02) Sorting Data
2.1 Performing an Alphabetical Sort
2.2 Performing a Numerical Sort
2.3 Sorting on More than One Column
2.4 Sorting by Vertically & Horizontally

Module (03) Filtering Data
3.1 Understanding Filtering
3.2 Applying and using a Filter
3.3 Clearing a Filter
3.4 Creating Compound Filters
3.5 Multiple Value Filters
3.6 Creating Custom Filters
3.7 Using Wildcards

Module (04) Filling Data
4.1 Understanding Filling
4.2 Filling a Series
4.3 Creating a Custom Fill List
4.4 Modifying a Custom Fill List
4.5 Deleting a Custom Fill List

Module (05) PivotTables
5.1 Understanding Pivot Tables
5.2 Creating a PivotTable Shell
5.3 Dropping Fields Into a PivotTable
5.4 Filtering a PivotTable Report
5.5 Clearing a Report Filter
5.6 Calculation in pivot
5.7 Formatting a PivotTable Report
5.8 Dynamic range for pivot
New feature
5.9 Understanding Slicers
5.10 Creating Slicers

NOTE: there are more modules required. Enquire and more details will be given.

Available actions

You must have an account to be able to apply for projects.

Register as a consultant

Already have an account? Log in


Looking for a consultant?

Post a project and have consultants apply

Post a project

About Talmix

Talmix is an online market place for consultants to connect with clients for projects such as market research, due diligence, competitive analysis, strategic business planning, and organisational reviews.

  • 35,000+ consultants
  • 150+ countries
  • 100+ sectors
Why Talmix >
Top