Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate&#039;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.

Dalia AnwarSenior Manager, Sales, MEA

Customized Corporate Training

We are the 'go-to' experts when it comes to customizing financial training programs. While adhering to the set rules and regulations, we do not interrupt your day-to-day business activities and work with cooperative flexibility to fit the immersing workflow.

Learning 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

Create and manage drop lists

Analyze huge data using Pivot Tools in no time

Protect workbooks and worksheets

Course Outline

Basic functions, formulas and shortcuts

Tips for navigating Excel

If and nested if

if error

sumif

sumifs

countif

Lookup functions(VLOOKUP, HLOOKUP, INDEX, MATCH)

Subtotal

countifs

averageif

averageifs

PivotTables

Sorting and filtering data

Advanced filtering

Subtotaling and grouping data

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

Create drop lists

Remove duplicate

Flash fill

Concatenate, combine and merge excel files

Protect workbooks

Protect worksheets

Protect specific cells on your sheet

Hide Formulas

Print worksheets

Who Should Attend

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

Jihad Hassan

Financial Learning Advisor TL