Loading...
Advanced MS Excel Training in Dubai2019-09-08T08:40:53+00:00

Quick Enquiry

Advanced Excel Training Program

Lynchpin is the leader in providing Excel Training in Dubai & Abu Dhabi. Our expert Microsoft Excel Trainer deliver both public Excel Training Programs as well as in-house Excel Training Programs in Dubai, Abu Dhabi and across UAE.

Looking for Excel Training in Dubai and Abu Dhabi? Its time to save your time and gain control over your financial, accounting, auditing, presentations and day to day data calculations, sorting, and storing work, by one of the most intelligent software application Microsoft Excel

  • Discover methods to dramatically reduce the time you spend on spreadsheets
  • Develop practical solutions to your business problems through superior spreadsheet design
  • Upgrade your spreadsheet skills with advanced data management techniques
  • Consolidate worksheets from different sources into one workbook
  • Develop efficient techniques for using charts
  1. Use spreadsheet skills for advanced financial applications
  2. Create, format and troubleshoot pivot tables
  3. Analyze data accurately using pivot tables and slicers
  4. Adopt logical methods to solve complex problems by analyzing data accurately using pivot tables
  5. Efficient working with related worksheets and workbooks by benefitting from new reporting and presentation techniques

Unit 1: Filling Data

  • Understanding Filling
  • Filling A SeriesCreating A Custom Fill List
  • Modifying A Custom Fill List
  • Deleting A Custom Fill List

Unit 2: Formula Referencing

  • Absolute and Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Other basic formulas

Unit 3: Creating Name range

  • Creating Names for the range
  • Using Names In New Formulas
  • Creating Names Using The Name Box
  • Using Names To Select Ranges
  • Pasting Names Into Formulas
  • Creating Names From A Selection
  • Using The Name Manager

Unit 4: Logical Functions

  • Understanding Logical Function
  • Using IF To Display Text
  • Using IF To Calculate Values
  • Nesting IF Functions
  • Using IFERROR
  • Using AND
  • Using OR
  • Vlookup function
  • Multiple Vlookup

Unit 5: Conditional Formatting

  • Formatting Cells Containing Values
  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top & Bottom Ten Items
  • Working With Data Bars
  • Working With Colour Scales
  • Working With Icon Sets
  • Sparkline (New feature)
  • Creating Sparklines
  • Editing Sparklines

Unit 6: Advanced Validation

  • Creating drop down in cells
  • Restriction values from list only
  • Creating error message
  • Creating dependent list

Unit 7: Formulas

  • Count, CountA, CountIF & CountBlank
  • Sum, SumIF & SumIFs
  • Networkdays
  • Networkdays International (For ver 2010)
  • Today & Now function
  • Trim (Removing unwanted spaces)
  • Concatenate (Combining columns)

Unit 8: Dynamic table (New feature)

  • Converting data into table
  • Automation calculation in table
  • Converting table to normal range
  • Using table in Charts & Vlookup

Unit 9: Sorting Data

  • Understanding Lists
  • Performing An Alphabetical Sort
  • Performing A Numerical Sort
  • Sorting On More Than One Column
  • Sorting By Rows
  • Working with subtotal
  • Paste special
  • Hyperlink

Unit 10: Filtering Data

  • Understanding Filtering
  • Applying And Using A Filter
  • Clearing A Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards

Unit 11: Creating Charts

  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing A Chart
  • Dragging A Chart
  • Changing The Chart Type

Unit 12: Charting Techniques

  • Adding A Chart Title
  • Adding Axes Titles
  • Positioning The Legend
  • Showing Data Labels
  • Showing A Data Table
  • Modifying The Axes
  • Showing Gridlines
  • Adding a Trendline
  • Adding a TextBox To a Chart
  • Creating combination chart
  • Creating 2 Axis chart

Unit 13: Pivot Tables

  • Understanding Pivot Tables
  • Creating A PivotTable Shell
  • Dropping Fields Into A PivotTable
  • Filtering A PivotTable Report
  • Clearing A Report Filter
  • Calculation in pivot
  • Formatting A PivotTable Report
  • Dynamic range for pivot
  • Understanding Slicers (New Feature)
  • Creating Slicers (New Feature)

Unit 14: Macros

  • Recording & Running Macros
  • Creating button to run the macro
  • Assigning shortcut to macro
  • Deleting Macros
  • Relative reference in Macros

Unit 15: File / Data Security

  • Open & Modify file password
  • Sheet protection
  • Protecting your sheet from deletion
  • Protecting few cell, rows or cols
  • Protecting your data from copying

Participant’s Feedback

WhatsApp chat