Microsoft Excel Intermediate
Microsoft Excel Intermediate Training contains all formulas that are required to be known in all jobs. It can also be beneficial for those who just finished the university studies and looking for a job in any sector.
Only relevant and essential exercises that you will need to know in work. It will require a good understanding of basic Excel knowledge.
This course will help you to learn all formulas that could be required for any jobs, and with the help of this course, your Excel knowledge will be outstanding.
We will guide you step by step through the Intermediate Microsoft Excel formulas to advanced level and beyond. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into the more advanced level topics, array functions.
At the completion of this Microsoft Excel Intermediate course, you will be able to complete any Excel tasks with efficiency and proficiency.
This Microsoft Excel Intermediate training course is suitable whatever version of Excel you use, from 2007 – 2016, you will expand your knowledge and skills. By the end of this course, you will be able to create charts, work efficiently with multiple sheets in workbooks, use essential functions effectively, use productivity tools and work with the Excel list/database features.
Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks.
The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyze data in spreadsheets, such as sorting, filtering, conditional formatting, and auditing.
You will also organize table data and present data as charts.
You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates.
You might be interested in MS Excel Advanced training as a next step.
This officially accredited Microsoft course.
- COURSE TYPE Intermediate
- COURSE NUMBER
- DURATION 2 days
- COURSE ACCREDITED BY Microsoft
YOU WILL LEARN HOW TO
• Quickly summarise multiple sheets of data into one
• Turn long lists and reports into easy to read tables
• Formulas to check whether cells pass or fail your rules
• Create links between cells so that they all update automatically
• Highlight targets, trends, duplicates and errors with Conditional Formatting
• Formatting and layout consistency by saving as a Template
IMPORTANT COURSE INFORMATION
Requirements
Students should have strong basic skills with Microsoft Excel.
Certificate
Students will receive official Microsoft Certificate.
COURSE OUTLINE
Modules:
Module 1: Advanced Formulas
Using Named Ranges in Formulas
Naming a Single Cell
Naming a Range of Cells
Naming Multiple Single Cells Quickly
Using Formulas That Span Multiple Worksheets
Using the IF Function
Using AND/OR Functions
Using the SUMIF, AVERAGEIF, and COUNTIF Functions
Using the PMT Function
Using the LOOKUP Function
Using the VLOOKUP Function
Using the HLOOKUP Function
Using the CONCATENATE Function
Using the TRANSPOSE Function
Using the PROPER, UPPER, and LOWER Functions
The UPPER Function
The LOWER function
The TRIM Function
Using the LEFT, RIGHT, and MID Functions
The MID Function
Using Date Functions
Using the NOW and TODAY Functions
Creating Scenarios
Utilize the Watch Window
Consolidate Data
Enable Iterative Calculations
What-If Analyses
Use the Scenario Manager
Use Financial Functions
Module 2: Working with Lists
Converting a List to a Table
Removing Duplicates from a List
Sorting Data in a List
Filtering Data in a List
Adding Subtotals to a List
Grouping and Ungrouping Data in a List
Working with Large Worksheets
Working with Multiple Worksheets and Workbooks
Working with dates
List Management
Documenting and Auditing
Using Templates
Module 3: Working with Illustrations
Working with Clip Art
Using Shapes
Working with SmartArt
Module 4: Visualizing Your Data
Creating a Custom Chart Template
Inserting Charts
Add and Format Objects
Insert a Text Box
Create a Custom Chart Template
Module 5: Working with Tables
Mastering Excel Tables
Organising Worksheet Data
Charts
Format Data as a Table
Move between Tables and Ranges
Modify Tables
Define Titles
Auditing a Worksheet
Analysing Selected Data
Module 6: Advanced Formatting
Applying Conditional Formatting
Working with Styles
Creating and Modifying Templates
Advanced Pivot Tables
Module 7: Microsoft Excel Features that Were New in 2013
New Functions in Excel 2013
Using New Chart Tools
Using the Quick Analysis Tool
Using the Chart Recommendation Feature
Module 8: Features New in 2016
New Charts
Treemap
Sunburst
Histogram
Waterfall
Box and Whisker
Pareto
-
In The Classroom
-
Live, Online
-
Private Team Training
-
Indiviual Private Session
Please Register for More Information
COURSES RECOMMENDED AS A NEXT STEP
Enterprise Architecture Essentials
Enterprise Architecture Essentials – you’ll discover proven development methods to help you develop an IT architecture that meets the needs of your business. During the last 20 years, organizations worldwide have spent billions of dollars and expended centuries of human effort on information technology (IT). The results delivered by a majority of these IT projects…
View Details
ITIL® Foundation
ITIL, formally an acronym for Information Technology Infrastructure Library, is a set of detailed practices for IT service management (ITSM) that focuses on aligning IT services with the needs of the business. ITIL describes processes, procedures, tasks, and checklists which are not organization-specific but can be applied by an organization for establishing integration with the organization’s strategy, delivering…
View Details
Strategic Business Intelligence BI
Strategic Business Intelligence – Practical Training to Move BI toward ROI. To successfully compete in today’s global business environment an organization must continuously monitor, recognize and understand every aspect and every issue of its operations, its industry and the overall business environment. Setting up a business intelligence within an organization takes more than just installing the…
View Details