Training: Advanced Excel Skills for Business

Advanced Excel Skills for Business
Instructor: Ahmed Ibrahim
Class duration: 6:15 pm – 8:15 pm
Prerequisite: Basic and Intermediate Excel Skills

Classes
Class 1: Data Validation
 Create and apply data validation in spreadsheets
 Work with formulas in data validation
 Create and use drop-down lists
 Generate custom conditional formats

Class 2: Conditional Logic
 Explain the concept of conditional logic in formulas
 Evaluate data in a cell using logical tests
 Use conditional operations in functions (IF, AND, OR)
 Evaluate data with nested IF functions

Class 3: Automating Lookups
 Use the VLOOKUP function to find and display the contents of a cell
 Identify the use and requirements of the range lookup feature
 Look up data using the INDEX and MATCH functions

Class 4: Formula Auditing and Protection
 Configure Formula Calculation Options
 Trace Precedents and Dependents
 Explain how to check for errors in a spreadsheet
 Protect workbooks and worksheets

Class 5: Data Modeling
 Model different scenarios based on input, assumptions and/or outcomes
 Use Goal Seek and Solver to investigate what input parameters produce a desired outcome
 Use Data Tables and Scenario Manager

Note: This is subject to adjustment given the outcome of the pretest and the pace of the students.

look forward to receiving your application. The deadline for applications is Offline: [18th January, 2024], Online: [25th January, 2024]

Further Details

Duration:   6 Days

Class: 6 Days (6:30pm – 8:30pm) 

(Register Early -->> Click Here )

Offline Start & End Date: [18th January, to 23rd January 2025)  

Online Start & End Date: [25th January, to  30th January 2025)  

Fee Requirement

Registration Fee Individual: $25
Students: $20

Location Office: Ali Gobannimo Building, 3rd Floor, Togdheer, Hargeisa.

Bank Account Details

Deposit to Bank: Dahabshiil Bank

Account Name: African Academy for Professionals

Account Number: HRGD75468

Zaad Number:  0634730610 African Academy for Professionals

Contact Details:

Mobile Office: +252634730610

Office Line: 523851

Registration Link: https://forms.gle/1NeQvqfhV7yAEW2e6

Web: https://www.aapsom.com