Learn Microsoft Excel 2013 - Advanced
Course Description
Master
Excel's Powerful Data Functions in this Information-Packed 9-hour Video
Training.
·
Personal
and Professional Financial Functions
·
Statistical
Functions for Description, Prediction and Interference
·
Connecting
to External Data
·
Tables,
Charts and Pivots
·
Data
Analysis
The
Versatility of Excel
If
you have already been using Microsoft Excel then you know that the calculation,
graphing and tables available help you track, manipulate and report important
data. There is more to excel than a few SUMs, though, and this is the training
course to get you into the advanced uses of Excel so you can really use the
data and numbers you are tracking to your advantage.
This
course is designed for students that are already familiar with Excel, but wish
to improve their skills and open the possibilities with this versatile
spreadsheet program. Bring your basic knowledge of Excel 2013 or previous
software versions to this class and learn how to reach the next level of database
tracking and reporting.
Contents
and Overview
Through
52 lectures and over 12.5 hours of content, this course will take you through
learning how to use functions in everyday work environments. Personal and
professional financial functions are covered including payments, future value
and depreciations. Students will learn statistical functions like averages,
percentiles, and regression.
In
order to improve efficiency, students will also cover concepts for connecting
to external data like other workbooks or web data; tables including style,
selection and sizing. Pivot tables and data analysis will be key concepts
helpful to the work environment.
For
help with reporting, students will learn surface charts, stock charts, radar
charts and bubble charts and graphs. Lastly, students will cover important web
applications.
Upon
completion of this course, students will be able to create colorful charts and
databases that communicate data and financial records efficiently and
effectively. Students will be able to apply data to various reporting forms
like tables, graphs and pivot tables in order to show important analysis like
depreciation, percentiles and regression for use with strategizing and
planning. Students who finish this course will have an advanced knowledge of
the versatility of Excel that is immediately applicable to their work with the
database.
What are the requirements?
·
Microsoft
Excel 2013
What am I going to get from this course?
·
Over
52 lectures and 12.5 hours of content!
·
Working
with dates and times
·
Averages,
percentiles, and LINEST functions
·
Calculating
depreciation
·
Payments
·
Inserting
and formatting tables
·
Sparklines
and data bars
·
Pivot
charts
·
Bonus
practice files
What is the target audience?
·
Users
with basic knowledge of Excel 2013 and those upgrading from previous software
versions
Total learners in this course:5900 +.
Money back guaranty with in 30 days.
click below image to learn the course:
