Advance Excel Optimizer Middle East
Introduction
- Benefits of Performing Data Analysis
- DOs & DON'Ts of Presenting Data
- Stages of Data Analysis
- Advanced Text Formatting
- Best Way to Present Tables
- Many Ways to Present Numbers - Customized Number Formatting
- Customized Dates & Time Formatting
- What are Sparklines?
- Inserting & Modifying Sparklines
- Analyzing Data with Sparklines
- Performing Tweaks with Sparklines
- Handling Missing Data
- Making the Sparklines Dynamic (Auto-Update)
- Conditional Formatting
- Highlighting Cells Based in Criteria
- Using Data Bars, Icon Sets & Color Scales
- Make Your Own Formatting Rules
- Using Special Symbols
- Using the Camera Tool
- The Basics of Charting
- Going through different types of Charts
- Modifying Charts and Working with Chart Options
- Advanced Charts Formatting
- Inserting Text and Pictures inside Charts
- Modifying Chart Axis
- Creating Specialized Charts for Measuring Performance
- Combo Chart
- Dynamic Chart
- Thermometer Chart
- Bullet Chart
- Learning Useful Excel Functions
- Simple IF & Nested IF Function
- CHOOSE & OFFSET Function
- SUMPRODUCT & SUMIFS Function
- VLOOKUP & INDEX-MATCH Functions
- Adding Interactivity with Drop Downs
- Adding Interactive Advanced Controls
- Buttons Control
- Check Box
- Spin Buttons
- Option Buttons
- Using Macros to Automate Reports
- Recording a Macro
- Running a Macro
- Assigning Macros to Objects & Buttons
- Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
- Creating & Modifying Pivot Tables
- Performing Calculations within Pivot Tables
- Working with Pivot Charts
- Analyzing Data with Excellent New Features in Pivot Tables
- Slicers
- Timelines
Building a Complete Dashboard from Scratch
Data AnalysisIntroduction
- Benefits of Performing Data Analysis
- Stages of Data Analysis
- Analyzing Performance against Target
- Using Powerful New Features
- Flash Fill
- Quick Analysis
- Advanced Data Sorting techniques
- Advanced Filtering Techniques
- Applying Validation Checks on Data
- Highlighting Data Based on Specified Criteria
- Create your own Formatting Rules
- Using Non Charting Visualization
- Data Bars
- Icon Sets
- Color Scales
- What are Sparklines?
- Inserting & Modifying Sparklines
- Analyzing Data with Sparklines
- Performing Tweaks with Sparklines
- Handling Missing Data
- Making the Sparklines Dynamic (Auto-Update)
- Going through different types of Charts
- Modifying Charts and Working with Chart Options
- Advanced Charts Formatting
- Inserting Text and Pictures inside Charts
- Modifying Chart Axis
- Creating Specialized Charts for Measuring Performance
- Combo Chart
- Dynamic Chart
- Thermometer Chart
- Bullet Chart
- Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
- Creating & Modifying Pivot Tables
- Performing Calculations within Pivot Tables
- Working with Pivot Charts
- Analyzing Data with Excellent New Features in Pivot Tables
What-IF Analysis
- Using the brilliant Goal-Seek Feature
- Performing Sensitivity Analysis with Data Tables
- Using Scenario Manager to Summarize Results
Data Validation
- Creating Drop Down List
- Regulating & Managing the Entry of Data
- Custom Input Message and Error Alert
Enhancing Interactivity
- Adding Interactive Advanced Controls
- Buttons Control
- Check Box
- Spin Buttons
- Option Buttons
Automating Reports
- Using Macros to Automate Reports
- Recording a Macro
- Running a Macro
- Assigning Macros to Objects & Buttons
- Spreadsheets & Its Terminology
- Understanding Excel Interface
- Entering & Editing Data
- Opening, Closing & Saving Workbook
- Prevent Data Loss in the Event of System Crash
- Didn't Save a Workbook? Don't Worry - Recover Unsaved
Basic Formula & Function
- Difference between a Formula & Function
- Learning the Core Excel Functions
- Nesting Functions
- Understanding Relative, Absolute & Mixed Referencing
- Defining Names and Using them in Functions
Formatting Techniques
- Useful Formatting Tools
- Using Special Number Formatting
- Applying Predefined Styles & Themes
- Inserting Pictures, Objects & Smart Art
Working with Dates & Time
- The Science of Dates & Time in Excel
- Useful Date & Time Functions
Efficient Handling of Large Data
- Quick Data Selection Techniques - Use of Ctrl & Shift Keys
- Quick Data Entry Techniques
- Using the Fill Handle
- Accelerating Copy Paste
- Learning Sorting & Filtering
Analyzing Data with Conditional Formatting
- Highlighting Cells based on Different Criteria
- Exploring the Power of Excel Tables
- Creating Dynamic Ranges with Tables
- Dos & DONTs of Excel Charting
- Creating a Chart in no Time!
- Useful Charting Techniques
Lookup Functions
- Learning the Powerful IF Function
- Evaluating Multiple Results with Nested IF
- Learning the All Important VLOOKUP & Its
- Analyzing Data with Criteria - SUMIF Family
Pivot Tables
- Understanding the Power of Pivot Tables - An
- Excellent Reporting Tool!
- How to Create a Pivot Table
- How to Generate Reports from Pivot Tables
- Managing & Presenting Pivot Table
Managing Workbook & Worksheet
- Linking Worksheets & Workbooks
- Performing Calculations across Worksheets with
- 3D Formula
- Creating a Hyperlink
- Printing Fundamentals
- Protecting Workbook with Password
- Restrict Editing Data
- Hiding the Contents of the Cell
This course is no longer available.
Course details
Dashboard ReportingIntroduction
- Benefits of Performing Data Analysis
- DOs & DON'Ts of Presenting Data
- Stages of Data Analysis
- Advanced Text Formatting
- Best Way to Present Tables
- Many Ways to Present Numbers - Customized Number Formatting
- Customized Dates & Time Formatting
- What are Sparklines?
- Inserting & Modifying Sparklines
- Analyzing Data with Sparklines
- Performing Tweaks with Sparklines
- Handling Missing Data
- Making the Sparklines Dynamic (Auto-Update)
- Conditional Formatting
- Highlighting Cells Based in Criteria
- Using Data Bars, Icon Sets & Color Scales
- Make Your Own Formatting Rules
- Using Special Symbols
- Using the Camera Tool
- The Basics of Charting
- Going through different types of Charts
- Modifying Charts and Working with Chart Options
- Advanced Charts Formatting
- Inserting Text and Pictures inside Charts
- Modifying Chart Axis
- Creating Specialized Charts for Measuring Performance
- Combo Chart
- Dynamic Chart
- Thermometer Chart
- Bullet Chart
- Learning Useful Excel Functions
- Simple IF & Nested IF Function
- CHOOSE & OFFSET Function
- SUMPRODUCT & SUMIFS Function
- VLOOKUP & INDEX-MATCH Functions
- Adding Interactivity with Drop Downs
- Adding Interactive Advanced Controls
- Buttons Control
- Check Box
- Spin Buttons
- Option Buttons
- Using Macros to Automate Reports
- Recording a Macro
- Running a Macro
- Assigning Macros to Objects & Buttons
- Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
- Creating & Modifying Pivot Tables
- Performing Calculations within Pivot Tables
- Working with Pivot Charts
- Analyzing Data with Excellent New Features in Pivot Tables
- Slicers
- Timelines
Building a Complete Dashboard from Scratch
Data AnalysisIntroduction
- Benefits of Performing Data Analysis
- Stages of Data Analysis
- Analyzing Performance against Target
- Using Powerful New Features
- Flash Fill
- Quick Analysis
- Advanced Data Sorting techniques
- Advanced Filtering Techniques
- Applying Validation Checks on Data
- Highlighting Data Based on Specified Criteria
- Create your own Formatting Rules
- Using Non Charting Visualization
- Data Bars
- Icon Sets
- Color Scales
- What are Sparklines?
- Inserting & Modifying Sparklines
- Analyzing Data with Sparklines
- Performing Tweaks with Sparklines
- Handling Missing Data
- Making the Sparklines Dynamic (Auto-Update)
- Going through different types of Charts
- Modifying Charts and Working with Chart Options
- Advanced Charts Formatting
- Inserting Text and Pictures inside Charts
- Modifying Chart Axis
- Creating Specialized Charts for Measuring Performance
- Combo Chart
- Dynamic Chart
- Thermometer Chart
- Bullet Chart
- Analyzing Data with Pivot Tables: A very Powerful Reporting Tool
- Creating & Modifying Pivot Tables
- Performing Calculations within Pivot Tables
- Working with Pivot Charts
- Analyzing Data with Excellent New Features in Pivot Tables
What-IF Analysis
- Using the brilliant Goal-Seek Feature
- Performing Sensitivity Analysis with Data Tables
- Using Scenario Manager to Summarize Results
Data Validation
- Creating Drop Down List
- Regulating & Managing the Entry of Data
- Custom Input Message and Error Alert
Enhancing Interactivity
- Adding Interactive Advanced Controls
- Buttons Control
- Check Box
- Spin Buttons
- Option Buttons
Automating Reports
- Using Macros to Automate Reports
- Recording a Macro
- Running a Macro
- Assigning Macros to Objects & Buttons
- Spreadsheets & Its Terminology
- Understanding Excel Interface
- Entering & Editing Data
- Opening, Closing & Saving Workbook
- Prevent Data Loss in the Event of System Crash
- Didn't Save a Workbook? Don't Worry - Recover Unsaved
Basic Formula & Function
- Difference between a Formula & Function
- Learning the Core Excel Functions
- Nesting Functions
- Understanding Relative, Absolute & Mixed Referencing
- Defining Names and Using them in Functions
Formatting Techniques
- Useful Formatting Tools
- Using Special Number Formatting
- Applying Predefined Styles & Themes
- Inserting Pictures, Objects & Smart Art
Working with Dates & Time
- The Science of Dates & Time in Excel
- Useful Date & Time Functions
Efficient Handling of Large Data
- Quick Data Selection Techniques - Use of Ctrl & Shift Keys
- Quick Data Entry Techniques
- Using the Fill Handle
- Accelerating Copy Paste
- Learning Sorting & Filtering
Analyzing Data with Conditional Formatting
- Highlighting Cells based on Different Criteria
- Exploring the Power of Excel Tables
- Creating Dynamic Ranges with Tables
- Dos & DONTs of Excel Charting
- Creating a Chart in no Time!
- Useful Charting Techniques
Lookup Functions
- Learning the Powerful IF Function
- Evaluating Multiple Results with Nested IF
- Learning the All Important VLOOKUP & Its
- Analyzing Data with Criteria - SUMIF Family
Pivot Tables
- Understanding the Power of Pivot Tables - An
- Excellent Reporting Tool!
- How to Create a Pivot Table
- How to Generate Reports from Pivot Tables
- Managing & Presenting Pivot Table
Managing Workbook & Worksheet
- Linking Worksheets & Workbooks
- Performing Calculations across Worksheets with
- 3D Formula
- Creating a Hyperlink
- Printing Fundamentals
- Protecting Workbook with Password
- Restrict Editing Data
- Hiding the Contents of the Cell
Job roles this course is suitable for:
If you love technology , then the IT field can offer a number of opportunities and areas to specialize in. You can validate your knowledge by advancing up the certification ladder to achieve new career heights. Whatever path you choose , we'll help you figure out the right steps to take.Course Location
About Optimizer Middle East
Introduction:
Optimizer Middle East is a professional organization located in Business village, Deira, Dubai, UAE and active in the MENA countries. The core business of the organization encompass services and consultancies in accounting management systems based on international standards and professional training including technical, management and accounting with the objective of developing personnel skills.
We have executed various professional development projects the Gulf region and North Africa till date targeting to be a leader for Training and development in the area.
Vision:
We Optimizer Middle East shall become the professional umbrella for all the training and development professionals in MENA regions.
Mission:
Develop, organize, sustain through providing professional services, consultancies and training with the objective of disseminating standardized and developed professional practices to individuals and private as well as governmental organizations in MENA region.
Our Objectives:
- Provision of knowledge as skills
- Empowering individuals and organizations in MENA region with the latest professional advanced tools
- Introduction of conceptual practices in the organizational activities
- Qualifying professional experts in the government and private sector
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Excel 2013 Basic to Advanced 1TRAININGAED 78
AED 563Duration: Upto 60 Hours - Microsoft OneNote Global CoursesAED 55
AED 514Duration: 1 Hour