Excel

Microsoft Excel 2016 Course Overview

Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spreadsheet program in many business activities, classwork and even personal data organisation. Excel was first released in the year 1985. Since then, it has played a vital role in performing formula based arithmetic and calculations, and other activities that may require mathematical calculations. Many businesses, personal and institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for different applications. To possess the excel skills, we provide three different classes for three different levels. Which are Basic, Intermediate and Advance.

Microsoft Excel 2016 - Basic

Microsoft Excel 2016 - Intermediate

Microsoft Excel 2016 – Advanced

Find Out More About Us!

Microsoft Excel 2016 - Basic

If you have little or no experience with Microsoft Excel, this 1-day Excel course will provide you with a comprehensive introduction to use all features in Excel. You will gain practical skills to use immediately in the workplace. Learn to create, edit, format, and print basic Microsoft Excel worksheets. Our Excel master will share tips that will help you save time and better display your data on screen and in print. At the end of this course, you will be able to:

Create basic worksheets using Microsoft Excel
Modify and manage Excel workbooks
Learn to insert the right data
Manage to format and align the data
Print the content of an Excel worksheet

Basic Excel Course Outline

Basic 1 - Becoming Acquainted with Excel

What is Excel?
Excel Navigation Basics
Creating, Saving, and Opening Workbooks
Using Dialog Box Launchers
Quick Access Toolbar
Switch between Touch and Mouse Mode
Screen Tips
Excel’s Tell Me What You Want to Do Feature

Basic 2 - Navigating and Working with Worksheets

Moving Between Cells Using the Keyboard
Select Cells by Using Their Cell References in the Name Box
Going Directly to Any Cell
Worksheets
Reordering and Copying Worksheets
Using Tab Buttons to Move through the Worksheets

Basic 3 - Best Ways to Enter and Edit Data

Data Types
Correcting Typing Mistakes
Returning a Cell to Its Original Value
Creating, Viewing, Editing, Deleting, and Formatting Cell Comments
Clearing the Contents of a Cell That Has Already Been Accepted
How to View all the Comments at the Same Time
How to Change the Default Name for Comments

Basic 4 - Formatting and Aligning Data

Formatting Your Text Using the Font Group
Using the Font Group’s Dialog Box Launcher
Formatting with Color
Check Which Formats Have Been Applied to the Current Cell
Accessing the Format Cell Dialog Box

Basic 5 - Different Ways of Viewing and Printing Your Workbook

Views
Page Break Preview
Page Layout View
Printing
Freezing Rows and Columns
Synchronizing Scrolling
Custom Views How to Create, Show, and Delete

Microsoft Excel 2016 - Intermediate

Choose this Excel level if you are comfortable doing basic tasks in spreadsheets and want to learn to create more powerful and dynamic spreadsheets. This level trains you to streamline and analyze data. Learn to keep data organized by managing large data sets with lists and tables especially Pivot tables and Vlookup functions. At the end of this course, you will be able to:

Create and understand the concept of formula
Insert and modify other function in worksheets
Learn and work with table and charts
Learn to use conditional formatting and styles
Utilise the Pivot tables to obtain a desired report

Intermediate Excel Course Outline

Intermediate 1: Excel’s Pre-existing Functions

Excel’s Built-in Functions
Function Construction
Functions That Sum Values
SUM Function
Using the Insert Function Option
Adds the Cells That Meet a Specified Criteria
Adds the Cells That Meet Multiple Criteria
Returns Different Values Depending upon If a Condition Is True or False
Returns TRUE if All of Its Arguments Are TRUE
Returns TRUE If Any Argument Is TRUE
Returns the Current Date
Returns the Current Date and Time
Returns the Serial Number of the DATE
Returns the Number of Days Between Two Dates

Intermediate 2 - Using Hyperlinks, Combining Text, and Working with the Status Bar 39

Working with Hyperlinks
Concatenation and Flash Fill
Using the Status Bar
Flash Fill Blank Cells and Flash Fill Changed Cells
Scroll Lock
Fixed Decimal
Macro Recording
Average, Count, Numerical Count, Minimum, Maximum, Sum
View Shortcut
Zoom and Zoom Slider

Intermediate 3 - Transferring and Duplicating Data to Other Locations

Moving and Copying Data
Moving and Copying Cells Using the Drag-and-Drop Method, Cut and Copy Buttons , Keyboard
Copy Data to Other Worksheets Using Fill Across Worksheets
Copy Data from One Workbook to Another
Using Paste Special
Using Paste Special to Transpose Rows and Columns
Using Paste Special to Perform Calculations
Inserting Copied or Moved Cells
Using the Microsoft Office Clipboard
Entering Data into Multiple Worksheets at the Same Time

Intermediate 4 - Working with Tables

Creating and Formatting Tables
Sort and Filter a Table
Adding to the Excel Table
Filtering Data with a Slicer
Applying and Defining Cell Styles
Conditional Formatting

Intermediate 5 - Working with Charts

Chart Types
Creating and Modifying Charts
Pie Charts
The Standard Pie Chart
Pie of Pie Subtype
Combination Chart
Hierarchical Charts
Treemap Chart
Sunburst Chart
Sparklines

Intermediate 6 - Using PivotTables and PivotCharts

Working with PivotTables
Creating a PivotChart
Creating PivotTable on a Relational Database

Microsoft Excel 2016 – Advanced

Already comfortable using Microsoft Excel? Take your skills to the next level in this Advanced Excel course. Our Excel master will share Excel’s most powerful and advanced tools, including Advanced Formula, PivotTables, Macros, and more. You will gain skills for better collaboration, including tracking changes, learn to audit worksheets, validate data to ensure consistency, and use other essential business tools in Microsoft Excel. At the end of this course, you will be able to:

Enhance Formula in Worksheets
Learn to auditing, validating and protecting workbook
Create advanced charts, graphs and Pivot tables
Import and export data
Create, use, edit and manage Macros

Advance Excel Course Outline

Advance 1 - Creating and Using Formulas

Introducing Formulas
Auto Calculate Tools
Average, Count Numbers, Max, Min
Viewing Formulas
Creating Named Ranges and Constants
Naming Ranges and Noncontiguous Ranges
Using Column or Row Headings for Range Names
Selecting Named Ranges Rather Than Typing Them into Formulas
Absolute Cell References
Mixed Cell References
Order of Precedence

Advance 2 - Auditing, Validating, and Protecting Your Data

Validating Your Data and Preventing Errors
Data Validation
Using IFERROR
Formula Auditing
Tracing Precedents and Dependents
Using the Watch Window
Using the Evaluate Formula Feature to Evaluate a Nested Function One Step at a Time
Proofreading Cell Values—Have Excel Read Back Your Entries
Spell Checking
Thesaurus

Advance 3 - Transferring and Duplicating Data to Other Locations

Moving and Copying Data
Moving and Copying Cells Using the Drag-and-Drop Method
Moving and Copying Cells Using the Cut and Copy Buttons
Moving and Copying Cells Using the Keyboard
Paste Button Gallery
Copy Data to Other Worksheets Using Fill Across Worksheets
Copy Data from One Workbook to Another
Paste Special
Using Paste Special to Transpose Rows and Columns
Using Paste Special to Perform Calculations
Inserting Copied or Moved Cells
Insert Copied Cells
Insert Cut Cells
Using the Microsoft Office Clipboard
Entering Data into Multiple Worksheets at the Same Time

Advance 4 - Working with Tables

Creating and Formatting Tables
Sort and Filter a Table
Adding to the Excel Table
Filtering Data with a Slicer
Using Themes
Applying and Defining Cell Styles
Conditional Formatting

Advance 5 - Working with Charts

Chart Types
Creating and Modifying Charts
Pie Charts
The Standard Pie
Chart Pie of Pie Subtype
Combination Chart
Hierarchical Charts
Treemap Chart
Sunburst Chart
Sparklines

Advance 6 - Importing Data

Importing Data into Excel
Importing Text Files
Delimited Text Files
Fixed-Width Text Files
Importing Data from an Access Database
Importing Data from a Web Site
Importing Data Using a Query

Advance 7 - Using PivotTables and PivotCharts

Working with PivotTables
Creating a PivotChart
Creating PivotTable on a Relational Database

Advance 8 - Enhancing Workbooks with Multimedia

Adding Pictures to the Worksheet
Using Screenshot
Working with WordArt
Adding and Modifying Shapes
Using SmartArt
Inserting Sound into a Worksheet
Inserting Video into a Worksheet
Using Bing Maps

Advance 9 - Automating Task with Macros

Creating (Recording) a Macro
The Problem with Absolute Cell References
Saving a Macro-Enabled Workbook
Creating a Macro Using Relative Cell References
Adding Macros to the Quick Access Toolbar and Other Objects
Sharing the Personal Workbook with Others
Looking at VBA Code
Creating Macros from Code

Find Out More About Us!

Instagram

Facebook

Website

Page updated

Google Sites

Report abuse