Tel:
(+234) 8038437312, 8023262908. E-mail: training@coinmac.org
Our Offices and Locations:
Nigeria, London, India, USA, United Kingdom, UAE & Canada

COINMAC INTERNATIONAL INC
Management Consultant
Multi-disciplinary Trainer
Information Technology Solution Provider

Home Contact Us
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac
Coinmac

Course List
Media/Downloads
Join us on facebook
Registeration for: Introduction to Microsoft Excel
Select Dates/Venues to attend
Personal Information
First Name:
Last Name:
Phone No:
E-mail:
Organization's Name:
Director of Org.:
AFTER MAKING PAYMENT, YOU CAN COME BACK TO THIS PAGE AND FILL THIS SECTION BELOW
PAYMENT VERIFICATION FORM
Teller No/Transaction ID:
Amount Paid:
Reg No:
Introduction to Microsoft Excel
Category: COMPUTER APPLICATION SOFTWARE COURSES

COURSE OBJECTIVES
You Will Learn How To:

  • Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
  • Optimize your worksheets using templates, graphs and formulas
  • Design simple to complex formulas by nesting Excel functions
  • Import, fine-tune and share Excel data
  • Create, manage and launch macros

COURSE CONTENT
Introduction to Microsoft Excel
The spreadsheet model
• Worksheets and their contents
• Differentiating workbooks and worksheets
Navigating the interface
• The Ribbon
• Customizing the interface
• Managing large spreadsheets by zooming
• Identifying worksheet tabs by color
• Changing worksheet views
Basic data editing
• Modifying cell contents and formats
• Inserting data with AutoFill
• Knowing when to use Paste Special
Acquiring and Conforming Data
Importing data from outside sources
• Integrating data from other Excel sheets
• Utilizing data from servers
• Managing external links
• Finding and removing duplicates
Excel tables and lists
• How Excel tables work
• Converting text to columns
• Sorting and grouping table data
• Adding data in a table or list
Worksheet Formatting and Presentation
Initial formatting
• Configuring cell numeric formats
• Aligning data within cells
• Fitting cells to data size
• Naming cells and cell ranges
Worksheet presentation
• Freezing worksheet areas
• Hiding content in worksheets
• Editing, modifying and saving templates
Innovative formatting
• Styling cells and sheets with prebuilt styles
• Conditionally formatting cells and data
• Rotating and wrapping text
Leveraging Formulas and Functions
Formula basics
• Performing simple calculations
• Specifying relative and absolute cell references
• Examining formulas with the auditing tools
• Concatenating text with the & operator
• Introducing functions with the Wizard and Formula tabs
• Working with statistical functions: SUM, MAX, MIN, COUNT and COUNTA
Cleaning up data and manipulating data further
• Utilizing TRIM, UPPER, LOWER LEFT and RIGHT MID functions
• Manipulating dates with YEAR, MONTH, DAY and TEXT functions
• Nesting formulas to perform multiple functions
• Defining and utilizing names in formulas
• Working with data in advanced formulas
Creating a Visual Presentation of Data
Charting your data
• Determining when charts are required
• Creating and modifying charts with wizards
• Adjusting chart layouts, title and labels
Printing workbooks
• Setting options on the Page Layout tab
• Viewing and adjusting page breaks
• Developing appropriate headers and footers
Introducing Advanced Excel Features
PivotTable basics
• Creating a PivotTable with wizards
• Pivoting existing PivotTable data
Final workbook touches
• Reviewing and adding comments on worksheets
• Protecting and sharing worksheets
• Tracking shared worksheet changes
Creating and managing macros
• Macro basics and when to use a macro
• Recording effective macros
• Launching macros from buttons

 

DATES:

04 Apr - 08 Apr, 2016,
23 May - 27 May, 2016,
15 Aug - 19 Aug, 2016,
21 Nov - 25 Nov, 2016

IMPORTANT NOTE:

FOR MORE DETAILS WITH RESPECT TO COURSE CONTENT E.T.C, PLEASE SEND YOUR REQUEST TO training@coinmac.org or call +2348023262908,+2348038437312
PARTNERS
Our Products and Services
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
SSCEPASS4SURE
HUSIS
MEDICALHEALTH
SCHOOLFEES
RESULT WIZARD
EASYSCHOOL
SCHOOLPORTAL
BULKSMS
JAMBCBT
Enquire Now Testimonials FAQS REGISTER NOW