Beacon
FinRecruit
FinConsult
Future of Finance
Linkedin

Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course Overview

The Advanced Excel workshop is designed for experienced Excel users who want to develop their Excel skills to the peak of the software’s ability in order to reduce time, create professional worksheets faster, and optimize work efficiency. In this workshop, participants will learn how to use and create complex formulas and functions, how to use Pivot Tables, how to create different types of charts to visualize data in the best possible way, and how to protect workbooks and worksheets. Participants will also explore different advanced tools to speed up their work. The workshop includes plenty of hands-on exercises to help participants retain what they have learned to start applying it straight away in the workplace.


For More Inquiries

Jihad Hassan

Senior Business Development Specialist

 +201278655721

 g.hassan@beaconfintrain.com

Jihad Hassan

Senior Business Development Specialist

 +201278655721

 g.hassan@beaconfintrain.com

Course Outcome

Use advanced formulas for complicated calculations

Present data on the right chart type

Format, manage, and modify all charts

Manage worksheets content professionally

Finish daily tasks in much shorter time

Course Outline

Topic 1 :Review of Basic Excel

Basic functions, formulas and shortcuts

Tips for navigating Excel

Topic 2 :Creating Advanced Formula

If and nested if

if error

sumif

sumifs

countif

Lookup functions(VLOOKUP, HLOOKUP, INDEX, MATCH)

Subtotal

countifs

averageif

averageifs

Topic 3 :Data Analysis Tools

PivotTables

Sorting and filtering data

Advanced filtering

Subtotaling and grouping data

Topic 4 :Visualizing Data with creating and managing Charts

Create, format, and manage Column chart

Create, format, and manage Bar chart

Create, format, and manage Pie and Doughnuts Chart

Create, format, and manage Line and area Chart

Create, format, and manage Combo Chart

Topic 5 :Speed up your work by using advanced tools

Create drop lists

Remove duplicate

Flash fill

Concatenate, combine and merge excel files


Who Should Attend

Anyone willing to take their excel skills
to the next level.

Share