Advanced MS Excel

Home /Advanced MS Excel

Course Overview

Course Outline

Key Takeaways

Review

Enquire Now

Course Overview

Trained Over 1500 Professionals on Excel

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

Course Details

Training Dates

19 & 20 March 2024

Training Fee

AED 1900/- for 2 full days

Start Course

Run This Course
In-House

Enjoy this certified
program at your premise of choice, with lower costs, and schedule that suits you best.

FULLY CUSTOMIZED
ACCORDING TO YOUR NEEDS!

Book In-House

Course Outline

  • Understanding Filling
  • Filling A SeriesCreating A Custom Fill List
  • Modifying A Custom Fill List
  • Deleting A Custom Fill List
  • Absolute and Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Other basic formulas
  • 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
  • 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
  • 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
  • Creating drop down in cells
  • Restriction values from list only
  • Creating error message
  • Creating dependent list
  • Count, CountA, CountIF & CountBlank
  • Sum, SumIF & SumIFs
  • Networkdays
  • Networkdays International (For ver 2010)
  • Today & Now function
  • Trim (Removing unwanted spaces)
  • Concatenate (Combining columns)
  • Converting data into table
  • Automation calculation in table
  • Converting table to normal range
  • Using table in Charts & Vlookup
  • 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
  • Understanding Filtering
  • Applying And Using A Filter
  • Clearing A Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing A Chart
  • Dragging A Chart
  • Changing The Chart Type
  • 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
  • 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)
  • Recording & Running Macros
  • Creating button to run the macro
  • Assigning shortcut to macro
  • Deleting Macros
  • Relative reference in Macros
  • Open & Modify file password
  • Sheet protection
  • Protecting your sheet from deletion
  • Protecting few cell, rows or cols
  • Protecting your data from copying

Key Takeaways

Skills

Use spreadsheet skills for advanced financial applications

Create

Create, format and troubleshoot pivot tables

Analyze

Analyze data accurately using pivot tables and slicers

Adopt

Adopt logical methods to solve complex problems by analyzing data accurately using pivot tablesControls over Financial Statements

Efficient

Efficient working with related worksheets and workbooks by benefitting from new reporting and presentation techniques

Client's Review

Previous
Next
Master the Finance and related expertise with our unique and customized Finance Training options.

Explore

Contact Us

Stay Connected