Microsoft Excel 2013 - Advanced

Learn to Master Microsoft Excel In Easy To Follow Step-By-Step Training
Course Created by Christine
Dr Christine has a BSc Computer Science and a Masters in Computer Science from University of Wollongong, Australia. She also has a PhD in the area of Intelligent Tutoring Systems from University of Malaya. She is currently the Deputy Head of School of Engineering and Computing at one of the leading colleges in Malaysia. Her passion and expertise is in Java Programming, Software Design and Implementation (C++), Visual Programming, Security Technologies and Artificial Intelligence. She has travelled to United Kingdom and Hong Kong to present at Conferences. In September 2014, she was invited by NCC Education, United Kingdom to conduct the Teacher Standardization Event in Myanmar.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

In this Microsoft Excel 2013 (Advanced) Training, your instructor, Christine, will lead you step-by-step in mastering the Advanced aspects of Microsoft Excel.

You will learn the advance functionality of Excel from working with Pivots, What Ifs, and Charts, to customising your Workbook and Excel for a more personal experience.

Check out our Course Outline for a more comprehensive listing of topics covered!

21 Videos (120 minutes of video content)

Why you should learn from this course?

  • Easy to follow and understand tutorials
  • Step-by-step detailed instructions
  • Hands on examples
  • Taught by an excellent instructor

Course Objectives

  • To learn the advance functionality of Excel
  • To understand and use functions such as Pivot Table and Pivot Charts, WhatIfs, etc
  • To equip the user to maximise Excel's capability

Who Is This For?

  • Excel users who wants to master the software
  • Power Excel users who wants to harness the full power of the program

Course Outline

Chapter 1: Pivottable and Pivotchart

  • Lesson 1
    Using Outlines
    11:51
  • Lesson 2
    Working with Pivottable
    13:06
  • Lesson 3
    Creating Pivotchart
    01:07

Chapter 2: Working with Charts and Graphics

  • Lesson 4
    Working with Charts
    15:05
  • Lesson 5
    Insert Online Pictures
    03:55
  • Lesson 6
    Adding Shapes
    03:34
  • Lesson 7
    Adding a Text Box
    01:06
  • Lesson 8
    Customizing Graphic Objects
    01:02
  • Lesson 9
    Working with SmartArt
    03:03

Chapter 3: What-If Analysis and Consolidate Data

  • Lesson 10
    Goal Seek
    02:58
  • Lesson 11
    Scenario Manager
    06:43
  • Lesson 12
    Consolidating Manager
    04:13

Chapter 4: Customizing Workbook

  • Lesson 13
    Import or Exporting Workbook
    03:58
  • Lesson 14
    Customizing Quick Access To…
    25:25
  • Lesson 15
    Custom Styles
    05:50
  • Lesson 16
    Custom View
    05:54
  • Lesson 17
    Document Theme
    02:21
  • Lesson 18
    Sending a Document
    01:46
  • Lesson 19
    Creating Web Pages
    01:40

Chapter 5: Customizing Excel

  • Lesson 20
    File Properties
    01:07
  • Lesson 21
    Customizing Excel
    14:36

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)