Online Courses, Online Classes, Online Learning, Distance Learning, Online Management Distance Courses
|
WODIA TRAINING INSTITUTE (WOTI)
MANAGEMENT TRAINING AND SKILLS DEVELOPMENT
WOTI COMPLEX
Online Courses, Online Learning, Online Education, Online Classes, eLearning in Business, Management
and Microsoft Home Office Study to Boost to Your Career and Organization
--- Online Learning Just in the comfort of your Home. Access Up to 140 Courses
Self-Paced Home Study, Online Courses
with Accredited Certificates
Home Study, ELearning, Online Courses, Classes to Enhance Your Career,
Personal Development, Sales and Workforce in Business and Management
Develop yourself, improve your management skills, promote
efficiency, sales and acquire leadership competence with
online learning that enhances you Skills and Knowledge.
STEPS TOWARDS ENGAGING IN ONLINE LEARNING
Step 1- Access up to about 140 Courses in Soft Skills including Administrative Skills, Career
Development, Human Resources, Personal Development, Sales and Marketing and also
Information Technology in Microsoft Office.
Step 2. Pay the sum of N80,000 ( eighty thousand Naira only ) per head for Four Months.
Step 3- Access 140 courses for Four Months. Learn, Practice, Take Notes, Improve your Skills.
Step 4- Choose the 6 courses you would wish to obtain Certificates.
Step 5- Obtain your Certificates after successful completion of the 6 courses within
Four Months.
Step 6- Become more creative, strategic, organized and confident with enhanced knowledge
in Administration, Information Technology, Leadership, Marketing, Project and Human
Resource Management. These will lead to Career Advancement, Personal Development that
will strengthen your knowledge in Business, Management and Microsoft Office Skills.
Copyright 2007-Till Date@thewodia.org
Telephone: +234 (0)8023079485;
+234 (0 8133754358
Excel 2016 Essentials Course Outline:
Module One: Create and Manage Worksheets and Workbooks
Create Worksheets and Workbooks
Create a workbook
Import data from a delimited text file
Add a worksheet to an existing workbook
Copy and move a worksheet
Navigate in Worksheets and Workbooks
Search for data within a workbook
Navigate to a named cell, range, or workbook element
Insert and remove hyperlinks
Format Worksheets and Workbooks
Change worksheet tab color
Rename a worksheet
Change worksheet order
Modify page setup
Insert and delete columns or rows
Change Workbook themes
Adjust row height and column width
Insert headers and footers
Customize Options and Views for Worksheets and Workbooks
Hide or unhide worksheets
Hide or unhide columns and rows
Customize the Quick Access toolbar
Change workbook views
Change window views
Modify document properties
Change magnification by using zoom tools
Display formulas
Configure Worksheets and Workbooks for Distribution
Set a print area
Save workbooks in alternative file formats
Print all or part of a workbook
Set print scaling
Display repeating row and column titles on multiple worksheets
Inspect a workbook for hidden properties or personal information
Inspect a workbook for accessibility issues
Inspect a workbook for compatibility issues
Module Two: Manage Data Cells and Ranges
Insert data in cells and ranges
Replace data
Cut, copy, or paste data
Paste data by using special paste options
fill cells by using Auto Fill
Insert and delete cells
Format cells and ranges
Merge cells
Modify cell alignment and indentation
Format cells by using Format Painter
Wrap text within cells
Apply number formats
Apply cell formats, apply cell styles
Summarize and organize data
Insert sparklines
Outline data
Insert subtotals
Apply conditional formatting
Module Three: Create tables
Create and manage tables
Create an Excel table from a cell range
Convert a table to a cell range
Add or remove table rows and columns
Manage table styles and options
Apply styles to tables
Configure table style options
Insert total rows
Filter and sort a table
Filter records
Sort data by multiple columns
Change sort order
Remove duplicate records
Module Four: Perform operations with formulas and functions
Summarize data by using functions
Insert references
Perform calculations by using the SUM function
Perform calculations by using MIN and MAX functions
Perform calculations by using the COUNT function
Perform calculations by using the AVERAGE function
Perform conditional operations by using functions
Perform logical operations by using the IF function
Perform logical operations by using the SUMIF function
Perform logical operations by using the AVERAGEIF function
Perform statistical operations by using the COUNTIF function
Format and modify text by using functions
Format text by using RIGHT, LEFT, and MID functions
Format text by using UPPER, LOWER, and PROPER functions
Format text by using the CONCATENATE function
Module Five: Create charts and objects
Create charts
Create a new chart
Add additional data series
Switch between rows and columns in source data
Analyze data by using Quick Analysis
Format graphic elements
Resize charts
Add and modify chart elements
Apply chart layouts and styles
Move charts to a chart sheet
Insert and format objects
Insert text boxes and shapes
Insert images
Modify object properties
Add alternative text to objects for accessibility.
ONLINE COURSE, ONLINE CLASSES, ELEARNING
COURSE CONTENTS OF
EXCEL 2016 ESSENTIALS