Filters
Search

Microsoft Excel Advanced

Advanced Excel plays a very important role in structuring & presenting data so that it looks impressive. Once one has a good understanding of Excel features like tables, cell styles, formatting options, then it is necessary to make awesome Excel workbooks. The role of this course is to teach participants the various formulas used in Excel, how to debug them, audit them and how to use which formula for which occasion (and also know few alternatives for any given formula problem).

Schedule

Date Location Price Book
28/01/2024
*
SAR 800.00 incl tax
+ -
17/03/2024
*
SAR 800.00 incl tax
+ -

Overview

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research, and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you've mastered them. This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis.

 

"Audience(s)

-Analyst
-Accountants


Prerequisites
WINDOWS

Agenda

Course Outline
1-Setting Up a Workbook
2- Working with Data and Excel Tables
3- Performing Calculations on Data
4- Changing Workbook Appearance
5- Focusing on Specific Data by Using Filters
6- Reordering and Summarizing Data
7- Combining Data from Multiple Sources
8- Analyzing Alternative Data Sets
9- Creating Dynamic Worksheets by Using Pivot Tables
10- Creating Charts and Graphics
11- Printing
12- Automating Repetitive Tasks by Using Macros
13- Working with Other Microsoft Office Programs

FAQ

Downloads

*
*
*
*
Close