Advanced Excel Training - Compugoal Computer Services

Go to content

Main menu:

Advanced Excel Training

Corporate Training
We provide a fresh, modern take on Advanced Excel training . There are no complicated textbooks or unnecessary technical explanations - our narrative-based approach is designed to create memorable scenarios that you and your colleagues can relate to and learn from.
Product Benefits
• Employees will save time and increase productivity
• Proficient in spreadsheets
• Table creating abilities
• With the Excel VBA, one can automate the task in excel and this process is called macros
• Ability to work with safety and security
Knowledge of using graphs and charts
Help to identify trends
Conditional formatting
Career enhancement
Achieve high performance
Accurate Analysis

Units in this package Include:-
 
PIVOT TABLES
2  How to quickly convert no-compliant data into pivot friendly data
2  Pivot Tables-Step by step
2  Manipulating the Data portion of a Pivot Table
2  Manipulating the Rows of a Pivot Table
2  Manipulating the columns in a pivot table
2  Combining rows and columns to create meaningful pivots
2  Report Filter
2  Grouping Data in the rows and columns:-
             · Manual
             · Dates
             · Numbers
2  Simple Pivot Charting
2  Creating Calculated Fields within a pivot table
2  Creating Calculated Item within a pivot table
2  GETPIVOTDATA function
2  Multiple Consolidation ranges in Pivot Tables
2  Conditional Formatting on Pivot Tables(Excel 2007 and higher)
2  Linking to an external database via Pivot Tables
ADVANCED EXCEL TECHNIQUES
2  Advanced Excel Techniques for use in modeling
2  How errors happen in models and how to avoid them
2  Financial Model and spreadsheet design principals
2  Essential Excel knowledge
IMPORTING DATA INTO A MODEL
2  Data cleanup using the data Autofilter and the Advanced Filter
2  GOTO Special tool for working with cells
2  Using the text to column tool
2  Common pitfalls/ problems at this page
2  Working with imported text data
          · CLEAN, CONCATENATE, DOLLAR, EXACT, FIND/SEARCH, LEFT/RIGHT/MID, LEN, LOWE/UPPER/PROPER, REPLACE, T, TEXT, TRIM, VALUE
2  Handling dates in your models
          · EOMONTH, DATE, DATEVALUE, DAY, EDATE, MONTH, NETWORKING DAYS, WEEKDAY, WORKDAY, YEAR
2  Manipulating the data
         · (SUMIF, COUNTIF, SUMIFS, COUNTIFS, VLOOKUP)
2  Ranking Results
2  Error Checks and Spreadsheet integrity
2  Analysing Results
           ·  Data filter
           ·  Speech to text
           ·  Database Functions
REPORTING RESULTS
         ·  Conditional  Formatting
         ·  Cell Formatting
         ·  Data Protection
DATA VISUALISATION
2  Getting the Data right for Graphing
2  Understanding Excel  graphs and incorporating them into your model
2  Adding another series to a graph
2  Creating a Secondary axis in a chart
2  Changing default colouring to match corporate colours
2  Create a chart template for consistent use
2  Different Chart Types
           ·  Column Charts
           ·  Bar Charts
           ·  Pie Charts
           ·  Area Charts
           ·  Radar
           ·  Waterfall graphs
           ·   Combination Charts
TRENDLINES IN MODELS
2  Goalseeking straight off the graph
2  Linking your word documents directly to the excel  graph
2  Conditional Formatting Graphs
2  Using a custom picture for your graphs
2  Creating flexible graphs

For more information and a quote,

Call:+254722572016
Contact Person:Patrick
 
Copyright 2019.Compugoal Computer Services. All rights reserved.
Back to content | Back to main menu