Description
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.
