Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Microsoft Excel Workshop

By: Sandhills Consulting Nigeria Ltd

Lagos State, Nigeria

26 - 28 Jul, 2016  3 days

Follow Event

  

NGN 115,500

Microsoft excel (spreadsheet) application software is an important tool that aids operations, and decision making in every organizational function including; Accounting, internal audit, sales and marketing, payroll, production, inventory and stores management and others . Some of the specific uses and applications of spreadsheet include:

  • Cash-flow statements
  • Worksheet for financial statements
  • Audit work papers.
  • Production plans/reports and engineering analysis.
  • Financial engineering/ modeling (what if analysis)
  • Database (relational) design and management
  • Statistics and display of chats
  • Consolidated financial statements
  • Aging statements
  • Pension reports and statements
  • Budgets, credit management and numerous others

Considering the above list, most employees should have the knowledge and the minimum exposure to the use of excel at the basic level. This course extends to the advanced stage.

An organization that engages its employees in excels training and other basic computer skills is bound to realize improved performance.

Course Content

Day One      

  • The Basics 
  • Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Formatting a Worksheet 
  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit
  • Using AutoFill

Day Two  

  • Managing your workbooks 
  • Switching Between Sheets in a Workbook
  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Printing Options
  • Editing a spreadsheet
  • Entering Date Values
  • Editing, Clearing, and Replacing Cell Contents
  • Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells
  • Collecting and Pasting Multiple Items
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Inserting Cell Comments 
  • Providing Formulas
  • Creating a basic Formula
  • Calculating Value Totals with AutoSum
  • Editing & Copying Formulas
  • Correcting and Fixing Errors in Your Formulas
  • Formulas with Several Operators and Cell Ranges  
  • Using basic and arithmetic/statistical functions: - sum, average, multiplication, and division
  • Working with the Forms Menu 
  • Sorting, Subtotaling and Filtering Data
  • Using Data Validation

 

Day Three

  • Creating and Working with Charts
  • Creating a Chart
  • Moving and Resizing a Chart
  • Adding Titles, Gridlines, and Data
  • Mapping and Modifying a Map 
  • Using a pivot table
  • Automating Tasks with Macros
  • Recording a Macro
  • Working with macro
  • Recording,
  • Assigning
  • Add a micro to a toolbar
  • Working with Other Programs
  • Inserting an Excel Worksheet into a Word Document
  • Modifying an Inserted Excel Worksheet
  • Querying the data base using excel
  • Linking and consolidating worksheets.

Course Outcome

At the end of the course the participants should be capable of using excel for the following:

  • Preparing Payroll
  • Accumulating, Analyzing, Accounting Data,
  • Preparing Financial Statements
  • Preparing Aging Statements
  • Carrying out “what if analysis” or “scenario analysis” and
  • Many more functions.

Target Audience                    

  • Accounting Staff and Officers
  • Supervisors
  • Sales and Marketing Staff
  • Stores and Inventory Officers
  • Librarians
  • Personnel in the registrar’s office
  • Auditors
  • Academic staff
  • Foremen and Production Supervisors
  • Office Managers
6,Segun Gbele Close, Off Lola Holloway Street, Omole Phase 1, Ojodu-Ikeja, Lagos, Nigeria Jul 26 - 28 Jul, 2016
NGN 115,500.00(VAT Inclusive)
(Convert Currency)

08185131363, 08061277967

Discount of 10% for 3-4 participants from same Organization Discount of 15% for 5 or more participant from same Organization. THIS COURSE IS ALSO OFFERED AS IN-PLANT
PROFESSOR PENDER GBENEDIO (CEO/ CHIEF CONSULTANT SANDHILLS CONSULTING NIG. LTD). B.Sc. Accounting, Central State University, Wilberforce, Ohio USA; MBA and Ph.D. Accounting, University of Cincinnati Ohio USA; Doctoral Secondary Fields, Finance and Industrial Management. Worked as Financial Specialist at the Corporate Headquarters of the National Cash Register Company (NCR) in Dayton, Ohio USA. He was later appointed a Professor of Accounting and Chair of the Department of Accounting and Associate Dean of the Business School at North Carolina Central University, in Durham, North Carolina, USA; Campus Dean at Strayer University, Colombia Campus, South Carolina, USA. He has taught numerous courses, multiple times in Accounting, Finance and Industrial Management. He is also a visiting Professor at Covenant University (Sango Ota) teaching Ph. D and M.SC Environmental, International and Oil &Gas Accounting. His strengths are in Accounting, Finance, Industrial Management, Functional, Soft Skills and Leadership Courses.PROF CHARLES UWADIA: B.Sc. Computer Science, MSc Computer Science, Ph. D Computer Science. He is presently the head of Computer Science Faculty at the University of Lagos. His strength is in Computer Science Applications.