Microsoft Excel 2013 - Intermediate

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 (Intermediate) Training, your instructor, Christine, will lead you step-by-step in mastering the more aspects of Microsoft Excel.

You will learn to work with Advanced Functions, Databases and Tables, as well as using Arrays and Multiple Sheets. You will also learn to Link Workbooks up and collaborating on it with different parties.

This course also covers Advanced Formatting and Protection of your workbooks.

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

20 Videos (over 100 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 Excel beyond the basics of a simple worksheet
  • To empower Excel users to harness the capability of the software beyond the basic level
  • To turn casual Excel users to Power users

Who Is This For?

  • Casual Excel users who wants to learn more about what Excel is capable of
  • Power users who wants to master Excel further
  • Professionals who uses Excel in their work

Course Outline

Chapter 1: Advanced Functions, Database and Table

  • Lesson 1
    Finding and Replacing Data
    03:19
  • Lesson 2
    Using Block Names
    09:48
  • Lesson 3
    Working with Dates
    03:40
  • Lesson 4
    Using the IF, PMT and PV Fu…
    06:23
  • Lesson 5
    Working with Database
    13:21
  • Lesson 6
    Working with Tables
    06:13

Chapter 2: Using Arrays and Linking Workbooks

  • Lesson 7
    Using Arrays
    02:28
  • Lesson 8
    Linking Files
    04:20

Chapter 3: Protecting Worksheets and Workbooks

  • Lesson 9
    Protecting Workbooks
    06:16
  • Lesson 10
    Freezing and Unfreezing Col…
    02:18
  • Lesson 11
    Splitting Worksheet
    02:31
  • Lesson 12
    Hiding/Unhiding Columns
    01:47

Chapter 4: Working with Multiple Sheets

  • Lesson 13
    Working with Multiple Works…
    09:58

Chapter 5: Working with Chart Sheets

  • Lesson 14
    Inserting and Working with …
    08:15

Chapter 6: Collaborating Workbooks

  • Lesson 15
    Inserting Hyperlink
    03:21
  • Lesson 16
    Sharing Workbooks
    03:28
  • Lesson 17
    Tracking Changes
    05:59
  • Lesson 18
    Working with Comments
    04:18

Chapter 7: Advanced Formatting

  • Lesson 19
    Conditional Formatting
    02:13
  • Lesson 20
    Custom Formatting
    12:14

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