Microsoft Excel 3 Course Bundle – Basic, Intermediate
& Advanced Courses-3035530865
Description
The
online Microsoft Excel Beginner, Intermediate & Advanced course will
provide learners with a core understanding of how to effectively operate and
use the Excel spreadsheet software at an advanced level. Whether you need to
learn the skills for work, fill the gaps in your CV or simply fancy learning
something new, this Excel Advanced course is perfect.
Course
Syllabus
Basic Level:
- Introduction
to Spreadsheets
- Understanding
Microsoft Excel
- Excel
Workbook Windows
- Basic
Spreadsheet Skills
- Excel
Help System
- Opening
and Closing Workbooks
- Understanding
Workbook File Formats
- Creating
New Workbooks
- Selecting
Cells
- Auto
Sum and Auto Fill Function
- Cell
Referencing and Request
- Formatting
Cells
- Formatting
Numbers
- Placing
Cell Alignment
- Cell,
Rows and Columns
- Understanding
Worksheets
- Editing,
Copying and Moving Cells
- Page
Layouts in Excel
- Proofing
Workbooks
- Basic
Options, Ribbons and Toolbar
- Final
Assessment
Intermediate Level:
- Introduction
to Excel Spreadsheet Intermediate Level
- Defining
Names in Excel
- Sorting
Data
- Using
Excel Tables
- Filtering
Data in Excel
- Understand
Charts
- Chart
Design Options and Tools
- Chart
Format Tools
- Combo
Charts
- Functions
within Excel
- Understanding
Date Function
- Information
Functions
- Logical
Functions
- Financial
Functions
- Find
and Replace
- Headers
and Footers
- Adding
Comments
- Conditional
Formatting
- Final
Assessment
Advanced Level:
- Introduction
to Excel Advanced
- Using
Text to Columns
- The
Paste Special Function
- Data
Validation
- Subtotals
and Grouping
- Consolidating
Data
- Scenario
Analysis
- Data
Tables in Scenario Analysis
- What-if
Analysis
- Mats
and Trig Functions
- Text
Functions in Excel
- Using
Lookup Functions
- Vlookups
- HLookups
- Using
Statistical Functions
- Databse
Functions
- Formaula
Auditing and Error Tracing
- Hyperlinks
in Excel
- Linking
Data
- Understanding
Pivot Tables
- Using
Pivot Charts
- Workbook
Properties
- Protecting
and Sharing Worksheets
- Data
Encrypting and Finalising Workbooks
- Understanding
to Macros
- Custom
Number Formats in Excel
- Using
Custom Lists
- Working
with Templates
- Tracking
Changes in Excel
- Merging
and Compare Excel Workbooks
- Final
Assessment
- Microsoft
Excel Software
This
course relates to Microsoft 2013 software. In order to complete the course,
learners should have their own copy of Microsoft Excel 2013. If learner does
not own a copy of the software, Microsoft provide a free trial version of
Microsoft Excel 2013.
Assessment
To
assess the learners ability and knowledge to effectively understand the topics
contained within the Microsoft Excel Basic, Intermediate & Advanced course,
the course features a number of end of module interactive quiz questions.
Additionally,
at the end of the course learners will also take an online multiple choice
assessment test. This online multiple choice test is marked automatically so
you will receive an instant grade and know whether you have passed the course.
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel –
Intermediate Course -3035530865
Description
Some of the highlights of the intermediate Excel course
include the following:
- Learning
more about intermediate Excel functions including ABS, AVERAGEIF,
AVERAGEIFS, and AVERAGEA
- Data
validation with date, list, time, and numbers
- Functions
such as RANK, MIN, MAX, CHAR, MODE, MEDIAN, CODE, CLEAN, and EXACT
- How
to remove duplicates in Excel
- Creating
random numbers
- Changing
text case
- How
to use Templates
- Insert
Charts
- Adding
custom backgrounds
- How
to use Tables
- How
to auto fill data
- Adding
special characters
- Changing
border colour and theme
Course Modules/Lessons
Module
1: SumProduct Formula
Module
2 : Data Validation With Date
Module
3 : Data Validation with Whole Numbers
Module
4 : Data Validation with List Feature
Module
5 : ABS Function
Module
6 : CHAR Function
Module
7 : CLEAN Function
Module
8 : CODE Function
Module
9 : EXACT Function
Module
10 : AVERAGEA Function
Module
11 : AVERAGEIF
Module
12 : AVERAGEIFS Function
Module
13 : CELL Function With 10 Variations
Module
14 : LARGE Function
Module
15: MAX Function
Module
16: MEDIAN Function
Module
17: MIN Function
Module
18: MODE Function
Module
19 : N Function
Module
20 : RANDBETWEEN Function (Insert Random Numbers)
Module
21 : RANK Function
Module
22 : Remove Duplicate Values
Module
23 : ROUND Function Up/Down
Module
24 : Add Custom Background Image
Module
25: Change Text To Lower Case
Module
26: Change Text To Upper Case
Module
27: Change Text To Proper Case
Module
28: Insert Special Character
Module
29: Use Autofill : A Time Saving Trick
Module
30: Treemap Chart
Module
31: Sunburst Chart
Module
32: Use Tables
Module
33: Use Templates
Module 34: Use Themes
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel - Advanced-3035530865
Description
Course Syllabus includes 24
intermediate/advanced level lessons
- Essential Formula Knowledge - Understand the most common and essential
formula categories in Excel and how to use them.
- Understanding Dates - Understand how dates work in Excel using
the TODAY, YEAR, MONTH, DAY and DATE functions.
- Understanding Time - Understand how time works in Excel, and
how to change from whole numbers into time increments and back again.
- · Intermediate Formula Knowledge
- Learn
more advanced formulas and gain a deeper understanding of how Excel
formulas work.
- Formula Auditing - Learn to work with formula auditing tools
including tracing precedent and dependent cells and formula evaluation.
- Temporal Functions - Learn to work with the EOMONTH and EDATE
functions that easily shift dates from one month or year to another.
- VLOOKUP with Approximate Match - Learn to use VLOOKUP to find an
approximate match and return it or the corresponding value from another
column.
- VLOOKUP with Exact Match - Learn to use VLOOKUP to find an exact
match and return it or the corresponding value from another column.
- Other Lookup Methods - Learn to work with INDEX, MATCH and
HLOOKUP, as alternatives to the VLOOKUP function.
- · Optimizing Data - Get your data into a usable form and
unleash Excel's most powerful tools with it.
- Naming Ranges - Learn about creating named ranges, and the
benefits of doing so.
- Excel Tables - Learn about creating Excel tables, and their
advantages.
- Recording Macros - Learn to record basic Excel macros to
automate your actions (instead of doing them manually).
- · Data Analysis - Analyze, summarize and highlight data
quickly and easily using Excel's PivotTables.
- Creating PivotTables - Learn to create and modify basic
PivotTables (for quickly summarizing and highlighting data).
- Formatting PivotTables - Learn to control formatting and other
options in PivotTables.
- Calculated Fields in PivotTables - Learn to create and modify basic calculated
fields for PivotTables.
- What-If Analysis - Learn to perform what-if analysis in Excel
using the Scenario Manager and Goal-Seek.
- · Presenting and Reporting - Interpret your data and turn it into
information using Excel's advanced formatting tools.
- Outlining - Learn about adding and working with
Excel’s outlining tools to quickly hide irrelevant sections of your
worksheet.
- Custom Number Formats - Learn to build your own custom number
formats to display dates, values and variances how you want to see them.
- Conditional Formats with Built-In Rules
- Learn
to create top/bottom and highlight cell rules, as well as to apply icon
sets and data bars.
- Conditional Formats with Custom Rules
- Learn
to create custom conditional formatting rules based on formulas.
- Building Combination Line and Area Charts
- When
you want to graph 3 line series, but only want 2 in focus most of the
time.
- · Validating and Updating - Increase the integrity and longevity of
your spreadsheet so that the right data is entered and can be easily
updated.
- Data Validation - Learn how to use Data Validation to ensure
that users enter valid data in input cells.
- Styles - Learn how to apply built-in number styles
and create your own custom styles packages.
- Preparing to Deploy - Set up Excel's aesthetics, including
preparing to print, and protect your spreadsheet's key components.
- Custom Views - Learn how to create and manage Custom
Views in a worksheet.
- Page Setup Options - Learn about page setup options, fitting
print jobs on a page, headers and footers, and other ways to customize
print jobs.
- Security Considerations - Learn about the setup and weaknesses of
Excel’s security systems.
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
Microsoft Excel 2007 Intermediate-3035530865
Description
Learning Outcomes
- Learn
how to summarise data and correct errors in calculation
- Learn
formatting and calculation
- Learn
how to customise appearance of charts
- Learn
how to print charts separately from worksheets
- Learn
how to create an outline, showcase different groups of data
Course Titles
- Module
01: Using Multiple Worksheets and Workbooks
- Module
02: Advanced Formatting
- Module
03: Outlining and Subtotals
- Module
04: Cell and Range Names
- Module
05: Lists and Tables
- Module
06: Web and Internet Features
- Module
07: Advanced Charting
- Module
08: Documenting and Auditing
- Module
09: Templates and Settings
Access Duration
The
course will be directly delivered to you, and you have 12 months access to the
online learning platform from the date you joined the course. The course is
self-paced and you can complete it in stages, revisiting the lectures at
anytime.
Method of Assessment
At the
end of the Microsoft Excel 2007 Intermediate course you will be required to
take a multiple choice question assessment test. The multiple choice question
assessment will be automatically marked with learners receiving an instant
grade.
Certification
Those
who successfully complete the exam will be awarded the certificate in Microsoft
Excel 2007 Intermediate.
Awarding Body
The certificate will be awarded by CPD and
iAP. This internationally recognised qualification will make your CV standout
and encourage employers to see your motivation at expanding your skills and
knowledge in the IT enterprise.
Whatsapp:
+923035530865, 03219606785, 3315145601,
03495021336
IPATS Government Recognized Education Zone-Khanna Pul Rawalpindi-Islamabad
No comments:
Post a Comment