Excel Advanced

Microsoft Excel Advanced Courses in Zambia

This 2KO Microsoft Excel Advanced course provides students with the knowledge and skills that are needed to use Microsoft Excel proficiently. 2KO Africa offers IT consulting, technical IT services and top-of-the-range IT training on multiple platforms. Our best-of-breed computer courses are presented as instructor led classes or as online internet-based elearning. from the comfort of home or work.

 

Excel 2016 Advanced explores ways to enhance Excel workbooks with topics in analyzing data, collaborating and workbook security, and adding graphical elements. This series covers important Excel functionality such as format as table, conditional formatting, shared workbooks and tracked changes, and data validation. While Excel 2016 Advanced is a continuation from the Excel 2016 Essentials series, it can be viewed as a standalone show for users looking to excel to the next level of skills. This series is specifically for locally installed Excel 2016 on Windows operating system.
 

To buy a course now using Credit Card, click the icon below

Analyze Data
Overview
Sort And Filter
Conditional Formatting
Outline And Subtotals
Tables
Overview
Sort And Filter
Conditional Formatting
Outline And Subtotals
Tables
Data Tables
Consolidate Data
Scenarios
Goal Seek
Remove Duplicates
Advanced Filter
 
Graphical Elements
Image: Basics
Images: Format
Shapes: Add And Format
Shapes: Multiple Shapes And Icons
Smart Art
Create An Invitation
 
Collaboration And Security
Shared Workbooks
Track Changes
Data Validation
Workbook Security
Document Properties

Additional Topics
Customize Interface

 

Details about this course
Almost 11 hours of learning
Includes video, presentations, workbooks, quizzes, flashcards & games
Receive a Certificate of Excellence on successful completion
Presented by highly qualified, industry leading experts
12 Months access (Unless indicated otherwise)