Basics of Microsoft Excel
What Will I Benefit?
Provide the necessary knowledge and skills to deal with and analyze advanced numbers, formulas, functions and graphs, using Microsoft Excel, so that you can take advantage of the capabilities and features of the program to perform your business and daily tasks efficiently and effectively
Course Objectives
-
At the end of this course, the participants should be able to
- Master the conditional coordination skill
- Master the data validation skill, data filtering, and matrix formulas
- Deal professionally with database, search and reference functions
- Professional graphic design
- Take advantage of the capabilities of pivot tables and charts
- Create interactive worksheets and analyze data in a what-if style
Target Audience
Individuals who need to use Pivot Tables and more advanced functions in Microsoft® Office Excel.
Course Outline
5
5
Topics
-
Conditional formatting (advanced formula-based)
- Examples
- Exercises
- Examples
- Exercises
- Examples
- Formula-based advanced filtering
- Multicellular matrix formulas
- Advantages of using a single matrix formula instead of single formulas
- Single-cell matrix formulas
- Fixed matrices
- Create an array of values in a specific range
- Examples of using single-cell arrays
- Sum the three (major) minimum values in a range
- Cancellation of staged formulas
- Matrix functions
- DGET function
- Use the DGET function to perform a two-column search
- VLOOKUP function
- MATCH function
- INDEX function
- INDIRECT function
- OFSET function
- CHOOSE function
- Create a chart at a glance
- Create a stacked vertical bar
- Working with pie charts
- Mixed charts
- Create progress charts toward the goal
- Save charts as templates
- Freezing schemes
- Dealing with lost data
- Examples
- Exercises
- Some operations on pivot tables
- Combine pivot tables
- Calculated fields and items
- Using Slicer
- Pivot charts
- Steps to create a micro
- How to put a button for the micro in the taskbar
- Use relative cell references when recording a micro
- Examples
- Add a worksheet control
- Examples
- Exercises
- Analyze data with targeting
- Analyze data using spreadsheets
- Using a spreadsheet with two variables
- Analyze data using scenarios
- Analyze data with Solver
5
5
Target Competencies
- Analyze Data Using Advanced Functions in Excel
- Working with Data
- Creating and Working with PivotTables
- Working with Macros
- Data Analysis Tools
5
5
Course Methodology
-
This training course will be held in a computer lab where every participant will have his own computer to be able to learn and implement the different skills, where the trainer will perform the skill and the participants will follow by performing the same skill in their computers.
Advanced Microsoft Excel
4400 SAR
3 Days
Course Dates & Locations
*Prices do not include value added tax.
For more information, do not hesitate to contact us
Find more topics about Computer Applications Courses
Basics of Microsoft Excel (Virtual)
(SPSS) Program Skills
Power BI