Excel Advanced
Microsoft Excel Advanced Courses in Malawi
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)