Ms Excel Professional Training

Ms Excel Professional Training

OBJECTIVES

As one of the most used computer software programs for businesses today, mastering Microsoft Excel is an important skill that workers should have. It is no wonder that companies and businesses demand that their staff learn Excel so that they can stay competitive.

Looking at it from the employer’s point of view, especially for those in the field of information technology system, Microsoft Excel is an essential end-user computing tool that can help perform a wide range of tasks. From making some of the mundane tasks more bearable through automation, to everyday functional tasks. Microsoft Excel is also used as a decision-making support for employers.

It isn’t surprising how Excel has been dominating the spreadsheet product industry with a share of more than 90 percent. Thanks to clever programming, businesses have relied on Excel to improve the productivity level of employees. Apart from that, Excel can also be used outside the corporate world.

At the end of the training Participants would be able to:

  • Work effectively with large volumes of texts and numerical data in Excel, with ease;
  • Design Excel-based templates for data collection, analysis and reporting;
  • Exhibit mastery of a wide vocabulary of key concepts, functions, techniques and “power-tips” in this spreadsheet software; and
  • Automate all manner of work activities/tasks in Excel, amongst others

OUTLINES

DAY 1

  • Exploring the Microsoft Excel user interface
  • Setting up a Workbook
  • Modifying Workbooks (properties)
  • Modifying Worksheets (properties)
  • Customizing the Excel Program Window
  • Database concept in Microsoft Excel
  • Presence of header rows for data
  • Presence of row and column consistency of data
  • Reordering and summarizing data
  • Sorting Data Lists
  • Organizing Data into Levels
  • Looking Up Information in a Data List
  • Focusing on specific data using filters
  • Limiting Data That Appears on the Screen
  • Defining Valid Sets of Values for Ranges of Cells
  • Advanced filter techniques
  • Enhancing data integrity through data validation
  • Create data validation
  • Create and edit input messages and error alerts
  • Dependent (advanced) data validation techniques
  • Formatting
  • Number formatting
  • Alignment, font, border, etc
  • Creating custom formats
  • Application of Excel Functions in work activities
  • Logical Functions: IF, AND, OR, NOT, etc
  • Text Functions: UPPER, LOWER, PROPER, LEFT, RIGHT, MID, SEARCH, SUBSTITUTE, etc
  • Tackling text problems: manipulating and formatting text as well as managing large volumes of text data

DAY 2

  • Protection
  • Protect workbook
  • Protect workbook elements
  • Protect worksheet elements
  • Protect select cells in a worksheet
  • Printing in Excel
  • Adding Headers and Footers to Printed Pages
  • Customizing Headers and Footers on printed pages
  • Preparing Worksheets for Printing
  • Setting print areas
  • Print titles
  • Use of conditional formatting in data analysis
  • Advanced filter techniques
  • Dependent (advanced) data validation techniques
  • More Excel Functions
  • Lookup Functions: VLOOKUP, HLOOKUP, CHOOSE, etc
  • Dates and Time Functions: DATE, DATEVALUE, YEAR, MONTH, DAY, etc
  • Named Ranges 1
  • Naming ranges
  • Editing range names and source
  • Using named ranges
  • Combining data from multiple sources
  • Linking to Data in Other Worksheets and Workbooks
  • Consolidating Multiple Sets of Data into a Single Workbook
  • Grouping Multiple Sets of Data
  • Use of Relative & Absolute referencing
  • Analyzing alternative data sets (working with Goal Seek)

DAY 3

  • Working with Pivot Tables
  • Preparation pivot table data
  • Creating pivot tables
  • Editing pivot tables
  • Grouping pivot table fields
  • Showing and hiding Totals
  • Using Pivot Table Slicer and Timeline [New!]
  • Formatting pivot tables
  • Working with calculated fields in pivot tables
  • Creating pivot charts
  • Creating Charts in line with best practices
    • Find the appropriate chart for numerical data
    • Creating a basic chart
    • Manipulating charts (e.g. colour, 3D-form, etc)
    • Changing Chart types
    • Adding/Editing Chart titles, gridlines and labels
    • Creating combination charts
  • Introduction to New Features in Microsoft Excel 2013 [New!]
    • New Functions e.g. ISFORMULA, IFNA, DAYS, ARABIC, etc
    • Form Fill
    • Quick Analysis tool
    • Working with Data Models
  • Power Pivot & Power View
    • Introduction to DAX (i.e. Data Analysis Expressions)
    • Understanding Data Models (including Relational Database Models)
    • Loading data and models (e.g. from MS Excel workbooks, Access, Text Files, etc)
  • Introduction to VBA and Macros
    • Recording/Writing macros
    • Running/Executing macros
  • Application of Form Controls: combo boxes, scroll bars, check box, option box, etc
  • Work-related case studies

DURATION

2 Days


DATE

10th - 11th June


FEE [₦]

70,000.00






    Please prove you are human by selecting the key.

    HIDE FORM
    REGISTER
    Get in Touch
    Go Up