Topic: Advanced & basic ms-excel training in ph-(jan-aug-2019)

ADVANCED & BASIC MS-EXCEL TRAINING IN PH-(JAN-AUG-2019)
Comprehensive Microsoft Excel 2013 (5 Days)
[IMG]file:///C:/Users/Eldemuz/AppData/Local/Temp/msohtmlclip1/01/clip_image001.png[/IMG]
Class Overview
On the first day of this comprehensive Microsoft Excel 2013 training course, students will learn to use Excel 2013 to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The second day of class will focus on using advanced formulas, working with lists, working with illustrations and charts, and using advanced formatting techniques. And on the third, fourth and final day of class, students will learn to work with pivot tables, audit worksheets, work with data tools, protect documents for collaboration with others, and work with macros.
This Comprehensive Microsoft Excel 2013 Training class is a combination of the following courses:

• Introduction to Microsoft Excel 2013 Training
• Intermediate Microsoft Excel 2013 Training
• Advanced Microsoft Excel 2013 Training
• Class Goals
  
  • Create basic worksheets using Microsoft Excel 2013.
  • Perform calculations in an Excel worksheet.
  • Modify an Excel worksheet.
  • Modify the appearance of data within a worksheet.
  • Manage Excel workbooks.
  • Print the content of an Excel worksheet.
  • Learn to use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Learn to work with tables.
  • Learn to use conditional formatting and styles.
  • Create pivot tables and charts.
  • Learn to trace precedents and dependents.
  • Convert text and validate and consolidate data.
  • Collaborate with others by protecting worksheets and workbooks.
  • Create, use, edit, and manage macros.
  • Import and export data.
  
  
• Class Outline
  
  1. Creating a Microsoft Excel Workbook
  2. The Ribbon
  3. The Backstage View (The File Menu)
  4. The Quick Access Toolbar
  5. Entering Data in Microsoft Excel Worksheets
  6. Formatting Microsoft Excel Worksheets
  7. Using Formulas in Microsoft Excel
  8. Working with Rows and Columns
  9. Editing Worksheets
  10. Microsoft Excel 2013 New Features 1
  11. Advanced Formulas
  12. Working with Lists
  13. Visualizing Your Data
  14. Working with Tables
  15. Advanced Formatting
  16. Microsoft Excel 2013 New Features
  17. Using Pivot Tables
  18. Auditing Worksheets
  19. Data Tools
  20. Working with Others
  21. Recording and Using Macros

VENUE: Eldemuz Engineering centre
1st floor 60 Aba road by craft centre busstop Portharcourt,

DATE: start dates January-Friday 4^th January , 14^th January,2019,

1. 4^th& 18th febuary 2019,
2. 4^th& 18th March 2019,
3. 1^st & 22^nd April 2019,
4. 6^th &20^th May 2019,
5. 3^rd &24^th June 2019,
6. 1^st &22^nd July 2019,
7. 5^th &26^th August 2019.

Contact:Visit .ng for more details,call 08038812638,or email :[email protected]

08038812638