Advanced Excel Business Solutions

Introduction

Microsoft Excel is the World’s premier spreadsheet software. We use Excel to analyze numbers, keep track of data, and graphically represent our information. It is used for validating and maintaining item information and analyzing variances. We also use Excel to store quantitative data and to perform accurate and rapid calculations with results ranging from simple budgets to financial and statistical analysis.

Anas got inspired by the Microsoft Excel Guru Haider Tuaima through customizing a unique and in-depth ِِِِAdvanced Microsoft Excel Business Solution, which takes its participants through three phases; the collection phase, the processing phase, and the reporting phase. It covers the journey from understanding data import, data validation, and data cleansing to database manipulation, calculation, lookups, database functions, pivot tables, and finally presenting and outputting the results, including worksheet formatting, chart creation, chart editing and exporting information to other applications.

The Advanced Excel Business Solutions Sessions utilize real-life worksheets containing many day-to-day challenges to be resolved. In essence, participants bring their own non-confidential worksheets to us to share their challenges and find solutions.

Advanced Excel Business Solutions Sessions

Intro Refresher: Performing Calculations
- Selecting and Naming Ranges
- Using AutoCalculate
- Using Functions and Formulas
- Using AutoSum and AutoFill
- Using Date & Time Functions
- Using Text Functions
- Using IF Function

Managing Workbook Information
- - Understanding Relative, Absolute, and Mixed Formulas
  - Creating Absolute and Mixed References

Working with Multiple Worksheets and Workbooks
- Working Across Worksheets and Workbooks
- Working with Multiple Sheet Formulas
- Consolidating Information
- Linking Information Between Workbooks

Working with Data in Lists
- Understanding Data Lists
- Sorting Data
- Creating and Removing Subtotals
- Using Data Validation
  - Restricting Cells to Numbers, Dates, or Times
  - Restricting Cells to a List of Values

Filtering Data
- Filtering Data
  - Using AutoFilter and Removing AutoFilter
  - Working with Filtered Data
  - Creating a Custom AutoFilter
  - Filtering with a Single Comparison Criterion
  - Filtering with Two Comparison Criteria
- Working with the Advanced Filter
  - Setting Up the Criteria Range
  - Examples of Criteria Ranges
  - Filtering Data with the Advanced Filter
  - Displaying All Data

Using Lookup and Database Functions
- Looking Up Values in a Table
- Working with Database Functions
  - Counting the Occurrences of a Value
  - Finding the Sum & Average of Specific Records

Working with PivotTables
- Creating PivotTables
- Editing PivotTables
  - Updating Information in a PivotTable
  - Adding Fields to a PivotTable
  - Removing Fields from a PivotTable
  - Changing the Layout of a PivotTable
  - Selecting PivotTable Data
- Modifying PivotTables
  - Grouping PivotTable Data
  - Hiding and Showing Source Details
  - Understanding Calculated Fields
  - Adding Page Fields
  - Displaying a Specific Page
  - Displaying Page Fields on Separate Sheets

Modifying Chart Options
- Modifying Titles and Labels
- Modifying Axes, Gridlines, and Legends
- Working with Data Tables
- Changing the Data Range
- Working with Data Series

Using Handy Features: FlashFill, Slicer & Sparklines
Auditing Worksheets
Protecting Worksheets & Workbooks
Recording Macros for Tasks Automation
Summarizing Data Using Dashboards

Advanced Excel Business Solutions Successfully Delivered to:

Feedbacks:

It was a whole new experience on various matters discussed. Will recommend the consultant for any known requirements in the field.
Very Informative, Interactive, Definitely the Covered Topics I can use in My Daily Work
A great Consultant he is! Well done Anas!

What was the most useful part of the Business Solution?

Ctrl + E; Almost Everything
Almost all aspects were very useful
Well prepared Excel sheets
Data Validation, Pivot Charts/Tables etc.
VLookup and so many other Excel Options, Shortcuts & Tricks
IF, OR, AND Parts
It was a whole new experience on various matters discussed. Will recommend the Consultant.
Pivot Tables, Macros
Consolidating/Summarizing Data, Creating Reports & Dashboards from Data

Upcoming Consultation / Training Sessions:

Dates: Upon Request
Including: Consultant-led Customized Excel Business Solutions, Material, Lunch & Beverages
Location: Sheikh Zayed Road, World Trade Center District, Saeed Tower II , Dubai, UAE
Company: JPP Management Consultants LLC, Dubai, UAE