ADVANCED SPREADSHEETS USING MS EXCEL
[visitor] Price: Ksh.5000 You are not yet enrolled in this course. [/visitor]
[student] You are enrolled in this course [/student]
This training program is meant to provide individuals with the necessary knowledge and skills to use office productivity tools. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world.
A candidate who passes this paper should be able to:
Learn to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others,
Topics for this course
Session 1: Formatting
Apply an auto format/table style to a cell range.
Apply conditional formatting based on cell content.
Create and apply custom number formats.
Copy, move worksheets between spreadsheets.
Split a window. Move, remove split bars
Hide, show rows, columns, worksheets.
Session 2: Functions and Formulas
Use date and time functions: today, now, day, month, year.
Use mathematical functions: round down, roundup, sumif
Use statistical functions: countif, count blank, rank.
Use text functions: left, right, mid,trim, concatenate.
Use financial functions: fv, pv, pmt.
Use lookup functions: vlookup,hlookup.
Use database functions: dsum, dmin,dmax, dcount, daverage.
Create a two-level nested function.
Use a 3-D reference within a sum function.
Use mixed references in formulas.
Create a combined column and line
Add a secondary axis to a chart.
Change the chart type for a defined data series.
Add, delete a data series in a chart.
Create, modify a pivot table/datapilot.
Session 3: Analysis
Modify the data source and refresh the pivot table/datapilot.
Filter, sort data in a pivot table/datapilot.
Automatically, manually group data in a pivot table/datapilot and rename groups.
Use one-input, two-input data tables/multiple operations tables.
Sort data by multiple columns at the same time.
Create a customized list and perform a custom sort.
Automatically filter a list in place.
Apply advanced filter options to a list.
Use automatic sub-totaling features.
Expand, collapse outline detail levels.
Create named scenarios.
Show, edit, delete scenarios.
Set, edit validation criteria for data entry in a cell range like: whole number, decimal, list, date, time.
Enter input message and error alert.
Session 4: Validating and Auditing
Trace precedent, dependent cells. Identify cells with missing dependents.
Show all formulas in a worksheet, rather than the resulting values.
Insert, edit, delete, show, hide comments/notes.
Name cell ranges, delete names for cell ranges.
Use named cell ranges in a function.
Use paste special options: add, subtract, multiply, divide.
Use paste special options: values /numbers, transpose.
Modify a template.
Linking, Embedding and Importing
Link data within a spreadsheet, between spreadsheets, between applications.
Update, break a link.
Import delimited data from a text file.
Record a simple macro like: change page setup, apply a custom number format, apply auto formats to a cell range, insert fields in worksheet header, footer.
Run a macro.
Turn on, off track changes. Track changes in a worksheet using a specified display view.
Accept, reject changes in a worksheet.
Compare and merge spreadsheets.
Session 5: Collaborative Editing
Add, remove password protection for a spreadsheet: to open, to modify.
Protect, unprotect cells, worksheet with a password.
Hide, unhide formulas
About the instructors
e-Learning Training and Consultation
Globopoint Consultants Limited is a fully registered Research, Training, and Consultancy firm based in Mombasa Kenya serving the entire East African region and beyond. The company is geared towards building professionals, entrepreneurs, growing businesses, and fostering sustainable economic development.
Globopoint Learning center is a fully accredited institution run by Globopoint Consultants Limited to specifically nurture modern-day professionals in the business field in an easy, practical, and convenient way.