Advanced Excel Training

Advanced Excel Training

Get Information

Advanced Excel training aims to teach participants how to prepare effective reports in their daily business life, how to create their work through shortcuts, how to save time by using advanced Excel functions and how to prevent unwanted errors.

The main purpose of Advanced Excel Training is to add new ones to your pre-existing Microsoft Office Excel knowledge at a certain level and to take your Excel skills to an advanced level.

You will learn effective, new and efficient solution examples for solving problems you may encounter while working with Excel. Advanced Excel Training does not have a content where only some formulas and Excel will be explained simply. This training will focus on how to create an effective Excel work environment.

About Education

Education Objectives

  • Learn to use many functions such as If (IF), Vertical (vlookup), Horizontal (hlookup),
  • To make your reports more automated,
  • Eliminate user-induced errors,
  • You will have an idea about macro creation and create simple macros,
  • Using Excel’s pivot table feature in your reports without difficulty,
  • Enriching the visuality of your reports with graphics,
  • To learn and apply profit maximization and cost minimization processes,
  • Financial, database, logical, etc. to create solutions and organize data stacks

 

Education Content

MODULE 1. MOST USED OPERATIONS AND FEATURES IN EXCEL: This section is dedicated to the most commonly used mathematical operations and Excel features that every Excel user in the business world should know. Depending on the level of the participants, this section can be passed quickly.

Using the pinning feature in Excel

Percentage change and percentage increase calculations

Filtering by multiple criteria in Excel

Lock specific cells in a Worksheet

Password to the Workbook

Fixing headings in tables

Printout of Worksheets and Printer settings

Converting Worksheets to PDF

The most used shortcuts in Excel

 

MODULE 2. MOST USED FUNCTIONS: This chapter covers the most widely used Excel functions that every Excel user in the business world should know.

If function usage and applications

2 Nested use of the If function

Nested use of more than 2 If functions

Etopla, If-mean, If-say functions and applications

Multiply Multiply, Multiply If Average, Multiply If Count functions

Dowser, Slope and Rank functions

Nested use of the vertical function

Extracting the largest or smallest 10 digits in tables with the help of the function

Perform operations on data sets with text functions

Creation of drop-down lists in cells with Data Validation feature

Combined use of Data Validation and Reducer functions

Failure to display #VALUE, #OPERATION and similar errors in columns with the function

 

MODULE 3. USING CONDITIONAL FORMATTING IN TABLES: Excel’s Conditional Formatting feature makes it easy to color any data table according to the criteria you want, to color cells by comparing them, and to add different symbols to cells to make it easier to perceive numbers faster.

Color the numbers above, below or in the range of a certain criterion

Auto-color the 10 largest digits in a column

Conditional Formatting Color Scales and Data Bars

Placing red green arrows up and down cells

Show increase and decrease in numbers with different symbols in cells

Compare cells with Conditional Formatting and give color to the cell

 

MODULE 4. PIVOT TABLES IN EXCEL: The Excel Pivot Table feature allows you to quickly prepare reports and summarize data in large data sets. The uses and many unknown features of Pivot Tables are shared with the participants.

Preparation of reports with Pivot Table in Excel

Formula writing and creation techniques in Pivot Tables

Updating the source in Pivot Tables

Technique for automating the Data Source

Slicer feature in Pivot Tables

Adding charts in Pivot Tables

Different report templates in Pivot Tables

Automatic rank and percentage share calculation in Pivot Tables

Report creation technique by grouping numbers in Pivot Tables

Applications

 

MODULE 5. GRAPHS IN EXCEL: In this section we will go through basic graphing in Excel, combinations in graphs and effective visualization elements.

Bar Charts, Bar Charts, Pie Charts, Line Charts

Excel’s 3D charting features

Creation of Stacked Set graphs

Design features of graphics

Dynamic title creation in charts

Effective visualization methods

How to add an image to a graphic area

Representation of percentage results on the second axis

 

MODULE 6. MACRO CREATION: This section covers creating macros, working with macros and reading macro code at a basic level in Excel.

Creating simple level macros

Editing macros

Reading macro codes

Create a Button for Macros

Who Should Receive the Training?

  • Beginner and Intermediate Excel users,
  • Those who want to see Excel shortcuts, the best solutions,
  • Professionals for whom Excel features heavily in their work life,
  • Those who complain that operational work takes too much time and want to reduce this burden,
  • Officials, experts, staff in the teams, HR, finance and accounting departments of organizations / companies,
  • Individuals who want to improve their Excel Skills
  • Officials of State Institutions,
  • Those who want to use MS Excel at an advanced level and integrate it into business life,
  • Financial, database, logical, etc. Authorized, expert people from every sector who want to produce solutions and organize data stacks; who want to manage sales and stock transactions,
  • People in the management department,
  • Anyone who wants to learn and apply profit maximization and cost minimization processes.
  • Anyone who wants to advance their knowledge of Excel, including Excel formulas, charts, data analysis, scenarios, solvers and macros.

Requirements

  • Basic computer and operating system knowledge.
  • Basic and/or intermediate Excel knowledge.

Plan this training institutionally!

This training can be planned in different durations and content specific to your organization. Please contact us for detailed rich content and planning to realize your training objectives.

Get in touch

Additional information

Lokasyon

Online

Kontenjan

20

Eğitmen

Academy Club