ADVANCED EXCEL : CORPORATE DATA MANAGEMENT & ANALYSIS 

Microsoft Excel is the World’s premier spreadsheet software. We use Excel to analyze numbers, keep track of data, and graphically represent our information.  It is used for validating and maintaining item information and analyzing variances. We also use Excel to store quantitative data and to perform accurate and rapid calculations with results ranging from simple budgets to financial and statistical analysis.

This unique and in-depth ِِِِAdvanced Excel workshop will take its participants through three phases; the collection phase, the processing phase, and the reporting phase. It covers the journey from understanding data import, data validation, and data cleansing to database manipulation, calculation, lookups,  database functions, pivot tables, and finally presenting and outputting the results, including worksheet formatting, chart creation, chart editing and exporting information to other applications.

The exercises utilize real-life worksheets containing many day-to-day challenges to be resolved. In addition, participants can bring their own worksheets to the workshop to share their challenges and find solutions. Participants are also encouraged to ask as many questions as required to make sure that there are no more doubts on the topics covered.

All versions of Excel from 97/2003 to 2010/2013/2016 can be utilized in this workshop with references to the different techniques and new features available in each version.

4 & 11 February 2017 (Two Saturdays) from 9:00am to 4:30pm

PS: For a Group of Participants preferred Dates and Location can be agreed Upon

– Coral Deira Hotel, Al Muraqqabat Rd, Dubai (Close to the Clock Tower in Deira)

1190 990 AED per Participant (Special Offer), including:

– Instructor-led training

– Certificate of Attendance

– International Buffet lunch

– Free Hotel Parking

– After Training Support

– High Quality Training Guaranteed

    • Introduction to the Principals of Data Management
      • Understanding data quality
      • Introducing data integrity
      • Data management tools
    • Performing Calculations
      • Selecting and Naming Ranges
      • Using AutoCalculate
      • Using Functions and Formulas
      • Using AutoSum and AutoFill
      • Using Date & Time Functions
      • Using IF Function, Nested IF, AND/OR Functions
    • Managing Workbook Information
      • Managing Information
        • Clearing Information
        • Deleting and Inserting Ranges
      • Moving and Copying Information
      • Copying Formulas
        • Understanding Relative, Absolute, and Mixed Formulas
        • Creating Absolute and Mixed References
        • Copying Values Only
        • Using AutoComplete
      • Working with Data in Lists
        • Understanding Data Lists
        • Sorting Data
        • Creating and Removing Subtotals
        • Using Data Validation
          • Restricting Cells to a List of Values
      • Filtering Data
        • Filtering Data
          • Using AutoFilter and Removing AutoFilter
          • Working with Filtered Data
          • Creating a Custom AutoFilter
          • Filtering with a Single Comparison Criterion
          • Filtering with Two Comparison Criteria
      • Using Lookup and Database Functions
        • Looking Up Values in a Table
        • Working with Database Functions
          • Counting the Occurrences of a Value
          • Finding the Sum & Average of Specific Records
      • Working with PivotTables
        • Creating PivotTables
        • Editing PivotTables
          • Updating Information in a PivotTable
          • Adding Fields to a PivotTable
          • Removing Fields from a PivotTable
          • Changing the Layout of a PivotTable
          • Selecting PivotTable Data
        • Modifying PivotTables
          • Grouping PivotTable Data
          • Hiding and Showing Source Details
          • Understanding Calculated Fields
          • Adding Page Fields
          • Displaying a Specific Page
          • Displaying Page Fields on Separate Sheets
      • Working with Charts
        • Creating a Chart
        • Creating a Pie Chart
          • Exploding a Wedge in a Pie Chart
      • Modifying Chart Options
        • Modifying Titles and Labels
        • Modifying Axes, Gridlines, and Legends
        • Working with Data Tables
        • Changing the Data Range
        • Working with Data Series
        • Deleting a Chart
            • Using Handy Features: FlashFill, Slicer & Sparklines
    • Recording Macros for Task Automation

For more details, kindly send us an email to: info@platinum-cpd.com 

Our Subject Matter Expert would be very glad to get back to you.

 

This slideshow requires JavaScript.