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
Coinmac

DONWLOAD OUR COMPANY PROFILE
Course List
Media/Downloads
Join us on facebook
Registeration for: Basic Microsoft Excel
Select Date/Venue to attend
Personal Information
First Name:
Last Name:
Phone No:
E-mail:
Organization's Name:
Address.:
AFTER MAKING PAYMENT, YOU CAN COME TO THIS PAGE AND FILL THIS SECTION BELOW
PAYMENT VERIFICATION FORM
Ref No:
Amount Paid:
Reg No:
Basic Microsoft Excel
Category: COMPUTER APPLICATION SOFTWARE COURSES
COURSE FEE: N99,500.00

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:

12 Mar - 16 Mar, 2018,
07 May - 11 May, 2018,
10 Sep - 14 Sep, 2018,
10 Dec - 14 Dec, 2018

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