Nigerian Seminars and Trainings

Search all upcoming seminars, conferences, short management courses and training in Nigeria and around the World

business logo

Advanced Excel 2016 Essential Training

By: Ciel Consulting

Rivers State, Nigeria

01 - 05 Apr, 2019  5 days

Follow Event

  

NGN 40,000

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions, the Goal Seek, Solver, and other data analysis tools, and automating tasks with macros.

Topics include: 

  • Working with the Excel interface
  • Entering data
  • Creating formulas and functions
  • Formatting rows, columns, cells, and data
  • Working with alignment and text wrap
  • Adjusting rows and columns
  • Finding and replacing data
  • Printing and sharing worksheets
  • Creating charts and PivotTables
  • Inserting and deleting sheets
  • Using power functions such as IF and VLOOKUP
  • Password-protecting worksheets and workbooks
  • Sorting data
  • Analysing data with Goal Seek and Solver
  • Creating and running macro
21 Oilfield Avenue, off School Road, Elelenwo, Port Harcourt Apr 01 - 05 Apr, 2019
NGN 40,000.00
(Convert Currency)

Victor 07039147221

Data Analysis Facilitators
NST PPC Advert