Take this
course

Office Productivity / Microsoft

Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes

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.
Full details

Curriculum

  • Introduction
    Prerequisites of Excel 2013 Advanced Course
    9:56
  • Functions
    List of Functions; Common Types of Arguments; Basic Use of Functions
    13:39
    Advanced Aspects of Functions; Searching for a Function
    11:01
    Autosum
    6:19
  • Personal and Professional Financial Functions
    Payment
    12:49
    Future Value
    11:18
    Principle Payment
    12:03
    Depreciations
    13:26
  • Date and Time
    How Dates and Times are Stored
    11:58
    Dates and Times Calculation
    12:46
    Exercise on Date and Time Functions; Date and Time Settings
    7:26
  • Statistical Functions for Description, Prediction and Interference
    Average
    13:06
    Percentile
    10:22
    Regression
    14:03
    LINEST Function
    9:50
    Example of Functions for Inferential Statistics
    12:40
  • Text Functions
    Text Function Case Study - 1
    14:27
    Text Function Case Study - 2
    10:36
  • Lookup Functions
    Lookup and Reference Functions
    15:44
  • Logical Functions
    Logical Functions
    16:01
  • Connecting to External Data
    Connecting to Other Workbooks
    16:05
    Connecting to Access Data
    14:12
    Connecting to Web Data
    10:19
  • Tables
    Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
    13:49
    Inserting Columns and Rows; Resizing Tables
    15:03
    Table Reference
    9:19
    Table Styles
    7:08
    Table Selection
    4:09
  • Pivot Tables
    Basic Principles of Pivot Tables
    14:59
    Presentational Side of Pivot Tables
    15:41
    Filtering in Pivot Tables; Slices
    14:07
  • Data Analysis
    What if
    15:33
    Scenario Manager
    14:08
    Goal Seek
    7:52
    Solver
    14:39
  • Charts
    Area Charts
    10:40
    Surface Charts
    7:41
    Stock Charts - Part 1
    12:28
    Stock Charts - Part 2
    12:49
    Radar Charts
    5:09
    Bubble Charts
    10:22
  • Graphs
    Regression and Scatter Chart
    7:01
  • Pivot Charts
    Creating Pivot Charts
    12:33
  • Sparklines
    Using Sparklines
    15:31
  • Web App
    Creating Workbooks using a Web App
    15:16
    Sharing your Workbook
    10:01
  • Conclusion
    Closing
    0:20

Skills

  • Data Visualization
  • Microsoft Excel
  • Spreadsheet

Similar Courses

More Courses by this Instructor