Username:
Password: Code:
5 7 k x
  Forgot Password?   Sitemap  |  Register
Home About us Solutions Newsroom Forum Partners Article Helpdesk FAQ Contact Us
2011-09-07
ServiceVows launches

more

 
Read more...
image
 
News
2011-08-24:EXCEL BERTHS IN NIGERIA

  

Saturday August 20, 2011 would be remembered as the day when EXCEL finally berth in Nigeria.Nigeria over the years have been bedeviled with low quality trainings on the appreciation and usage of Office Tools especially MS Excel.
With a full understanding of the fact that every employee in Corporate Nigeria can't function effectively and efficiently without having a full grasp of the operation of MSExcel,ServiceVows Ltd with support from 901 Business Solutions blazed the trail by providing an absolutely FREE Excel training to 80 lucky Nigerians chosen from the over 1,000 requests for the record-breaking free event in an equally world-record rated environment.
 
 
Mr Rotimi Akintomide the Lead Consultant of ServiceVows said the program was borne out of the observed dearth in Excel knowledge and that those teaching do not understand the needs of the student sas they've not worked in the Business which could have given them a grasp of issues faced with using Excel in the workplace.
 
ServiceVows Ltd has a team of Consultants providing top-notch training servcies to clients in a simplistic,easy to remember manner with an innovative after-training service for participants.
 
Listed below were the topics covered during the inaugural training session:

S/N
TOPIC
LESSONS
1
UNDERSTANDING EXCEL LAYOUT
(i)   Starting Excel
 
 
(ii)  Define a spreadsheet
 
 
(iii) Define and describe a Ribbon
 
 
(iv) Define Tabs,Groups and Command
 
 
(v)  Explain the features of a spreadsheet
 
 
(vi) Demonstrate the link between and amongst the components
2
NAVIGATING EXCEL
(i)   Navigate via Scroll Bar and Cursor
 
 
(ii)  Navigate via Keystrokes
 
 
(iii) Navigate via xlshortcuts
3
WORKBOOK AND WORKSHEETS
(i)   Define a workbook
 
 
(ii)  Create a new workbook
 
 
(iii) Edit and existing workbook
 
 
(iv) Saving a workbook
 
 
(v)  Navigate with a workbook
4
CELL OPERATION
(i)   Define a cell
 
 
(ii)  Demonstrate how to navigate between cells
 
 
(iii) Define a cell character
 
 
(iv) Explain Numbers and Texts
 
 
(v)  Explain the categories of Numbers and Texts
 
 
(vi) Explain Cell Alignment,Font,Border and Colour Fill
 
 
(vii)Demonstrate how to protect a cell
 
 
(viii)Conditional Formatting
5
MULTIPLE CELL DIMENSION
(i)   Define a Range
 
 
(ii)  Create  a Named Range
 
 
(iii) Insert,Delete and Shift a Cell
 
 
(iv) Define a Row and a Column
 
 
(v)  Insert Row and Column
 
 
(vi) Hide a Row and a Column
 
 
(vii)Merge a Row and a Column
6
DATA SORT AND ADVANCED FILTER
(i)  Sort by values,cell color,font color,cell icon
 
 
(ii) Custom autofilter
 
 
(iii) Pre-requisites to using advanced filter
 
 
(iv) Limitations of using advanced filter
7
DATA TOOLS
(i)  Text to Columns by Delimited
 
 
(ii) Text to Columns by Fixed Width
 
 
(iii) Data Validation Setting
 
 
(iv) Data Validation Messaging
 
 
(v)  Data Validation Input Alert
 
 
(vi) Pre-requisites to consoliating by position
 
 
(vii)Consolidate sheets by Position
 
 
(viii)Limitations to using consolidation by position
8
FORMATTING
(i)  Conditional formatting
 
 
(ii)  Format as Table
 
 
 
9
WHAT IF ANALYSIS
(i) When to use goal seek
 
 
(ii) Pre-requisite to using goal seek
 
 
(iii) How to use goal seek
 
 
(iv) Limitations of goal seek
10
SUBTOTAL
(i) When to use Subtotal
 
 
(ii) Pre-requisite to using Subtotal
 
 
(iii) How to use Subtotal
 
 
(iv) Theory of Visibility
11
LOOKUP FUNCTION
(i) When to use VLookup
 
 
(ii) Pre-requisite to using VLookup
 
 
(iii) How to use VLookup
 
 
(iv)Theory of first born
12
PIVOT TABLE
(i) When to use Pivot Table
 
 
(ii) Pre-requisite to using Pivot Table
 
 
(iii) How to use Pivot Table
 
 
(iv) Tweak the Pivot Table
13
VBA MACRO APPRECIATION
(i) Compare vba with manual
 
 
(ii) Benefits of Macro

Back

 
   No comment Found.
----------------------------------------------------------------------------------------------------------
Add Comments *Please Login before Submit your Comments
 
 
 
 
 
 
Google
 
Web www.servicevows.com
 
Copyright @ 2009 Servicevows Solutions Inc. All rights reserved. Privacy Statement.   Terms of Services