College of Information and Communication Technologies

College of ICT

University of Dar Es Salaam

Short courses

Advanced Microsoft Excel Training

  • Date: - -
  • Venue: Mbeya, CVL Office at Uzunguni
  • Cost: TZS 1,250,000
  • Contact: 0715677873 | oscar.mashauri@udsm.ac.tz
  • Register

This advanced Microsoft Excel training course will teach you to use the advanced features of Excel in any version to their full extent. By the end of this course, you will be able to use advanced graphs and presentation techniques to maximise impact, macros and VBA automate your spreadsheets and increase interactivity, using superpower functions can solve complex problems, using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions, users can seamlessly write and combine formulas like VLOOKUP, HLOOKUP, MATCH,INDEX,COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more also use charts to communicate effectively and present results in a stunning manner

Course Outline

Introduction
  • Welcome
  • Quick Excel interface tour
Tables and Formatting
  • Introduction
  • Create and Change Table Formatting
  • Tables Data Filters and Sort Options
  • Export Tables to Pivot Tables
  • Print Tables Alone
  • Change colors
  • Conditional Formatting
  • Quickly Numeric Formats Adjusting
  • Use Cell Styles
  • Row, Column, and Sheet Adjustments
  • Use Format Painter
  • Displaying Data as an Outline
  • Formatting Options for Print
Formulas and functions
  • Introduction
  • Logical Functions
  • Lookup and Reference Functions
  • Functions and Superpowers
  • Date and Time Functions
  • Math Functions
  • Functions For Working With Text
  • Array Formulas In Excel
  • Working with Financial Functions
  • Statistical
  • Reference Functions
  • Useful Informative Functions
  • Data Consolidation
Charts
  • Introduction
  • Working with Chart and Graph Types
  • Charts Formating
  • Dynamic and Interactive charts
  • Use sparklines
  • Working with Chart's Data Sources
  • Printing and Sharing
PivotTables and Pivot Reporting
  • Introduction
  • Create and Understanding a PivotTable
  • Working with the PivotTable Fields
  • Value Field Settings
  • Applying Filter and Sorting PivotTable Data
  • Working with the PivotTable Report Layout
  • Working with Conditional Formating
Data Validation
  • Introduction
  • Working with Validation Formula
  • Lists
  • Advanced Range Names
  • Working with Date and Time
  • Find Validation Rules in Workbook
  • Working with Duplications
Working with VBA and Macros
  • Introduction to VBA and Macros
  • Working in the Visual Basic Editor
  • Create and Running macros
  • Working with variables
  • Managing variable scope
  • Working with Arrays
  • Working with Workbooks
  • Worksheets with VBA
  • User Defined Functions
  • Working with VBA Logical Functions
  • Debugging Techniques
  • Working with Cell Data
  • Workbook Events
Security and Sharing
  • Protecting Workbooks
  • Assigning Workbook a Password
  • Unlocking cells and Workbooks
  • Printing your worksheet

Target Audience

Any one who interested to be MS Excel Expert.

How to make Payment

The fees Paid by cash should be deposited to NBC Bank, Account Name: Centre for Virtual Learning, Account Number: 040103002088 and by Cheque should be made payable to the Director, Centre for Virtual Learning (CVL), University of Dar es Salaam. Come with deposit(s) slip.

Log in