Basic and Intermediate Microsoft Excel 2013 for anyone

S$30.00
Take This Course
Basic and Intermediate Microsoft Excel 2013 for anyone

Course Description
In this Microsoft Excel 2013 course, I will introduce you to the basic concepts of Microsoft Excel 2013 and together we will slowly work through all that Microsoft Excel 2013 has to offer.

Whatever age, background or job, my course is intended on teaching anyone a comprehensive and solid foundation of Microsoft Excel 2013, that also applies to Microsoft Excel 2007 and 2010.

Furthermore, this course will cover most aspects that someone is required to know in order to successfully take the MOS (Microsoft Office Specialist) Excel exam.

Each video will contain me talking you through a certain concept in Microsoft Excel 2013, while at the same time showing how to use this concept in the video. I will go step-by-step so that everyone will be able to follow and understand what I am doing.

The lectures will contain a clear structure of:

Why the contents of the lecture are important to know.
What you can do with the contents of the lecture
How to do what I am explaining in the lecture
Throughout the course there are several videos where, together with me, you will create a basic Excel tool using the knowledge you have thus far obtained. This will serve to show you what you can do with Microsoft Excel 2013, as well as solidify the learnt concepts.

Upon completion of the course you will be able to work with Microsoft Excel 2013 in any basic office, school, university or personal setting.

What are the requirements?
You should already have installed Microsoft 2007, 2010 or 2013.
What am I going to get from this course?
Use excel in the best way possible to enhance your (professional) life
What is the target audience?
This Microsoft Excel 2013 course is meant for beginners and intermediates who want to learn or enhance their skills in and usage of Microsoft Excel 2013. No prior knowledge is needed when starting this course.

Curriculum

Section 1: The Beginnings
Course Introduction
02:03
What will you be working towards?
01:10
The File Menu – Saving, Opening, Exporting and More
05:36
The Ribbon
04:42
Customization and Personalization
04:45
The Beginnings Quiz
4 questions
Section 2: The Worksheet
Printing and Exporting to PDF
04:27
Navigating, Naming and Creating Multiple Worksheets
02:49
Protecting your worksheet
02:32
Hiding and Unhiding
02:04
Interacting with rows and columns
03:51
Summary of The Worksheet
05:30
Section 2 Assignment
03:55
The Worksheet Quiz
8 questions
Section 3: Layout
Freezing, Splitting Panes and other Sheet Options
05:05
Themes
02:47
Backgrounds
01:35
Summary of Layout
01:51
Section 3 Assignment
03:02
The Layout Quiz
5 questions
Section 4: Data Basics
Entering Data and Data Formats
08:36
Referring to Cells and other Worksheets
02:08
Copying, Pasting and Absolute/Relative Referral
07:10
The FILL Handle, AutoFill and Flash Fill
05:11
Undoing and Redoing things
02:41
Finding and Replacing Data
03:09
Different Paste Options (Transposing, Only Values, Only Formatting etc.)
04:43
Data Validation
06:01
Summary of Data Basics
05:57
Section 4 Assignment
07:07
The Data Basics Quiz
9 questions
Section 5: Formatting
Changing Cell Fill, Font and Border
04:32
Merging and Wrapping Cells
03:11
Content Alignment and Direction of a Cell
04:09
Format Painter and Clearing Cells
03:06
Summary of Formatting
02:26
Section 5 Assignment
04:19
The Formatting Quiz
7 questions
Section 6: Basic Formulas & Functions
Creating a basic Formula

Preview

04:04
The SUM, AVERAGE and COUNT Functions
03:58
The IF, SUMIF, AVERAGEIF and COUNTIF Functions
11:01
The MAX and MIN Functions
02:58
The RIGHT, LEFT and MID Functions
04:02
The TRIM, UPPER, LOWER and CONCATENATE Functions
03:14
Name Ranges and the Intersection Operator
08:12
Calculation Operators and Order of Operations in Excel
06:20
3D Referencing Cells
03:18
Cell Grouping and Subtotals
05:10
The Circular Reference Error and Tracing Precedents/Dependents
05:52
Summary of Basic Formulas & Functions
05:13
Section 6 Assignment
07:50
The Formulas & Functions Quiz
10 questions
Section 7: Applying Our Knowledge 1
Building an elegant budgeting tool
19:58
Section 8: Tables
Creating a Table
04:32
Table Sorting and Searching
03:56
Table Filters and Slicers
04:38
Summary of Tables
01:21
Section 8 Assignment
02:44
The Tables Quiz
5 questions
Section 9: Basic Graphs
Creating a basic Graph
04:04
Explaining the different Graph Types
10:36
Different Graph Options
07:40
Sparklines
03:25
Summary of Basic Graphs
01:22
Section 9 Assignment
03:16
The Graphs Quiz
8 questions
Section 10: Graphical Objects
SmartArt
02:49
Shapes
02:28
Screenshots and Pictures
02:48
Summary of Graphical Objects
01:43
Section 10 Assignment
04:40
The Graphical Objects Quiz
4 questions
Section 11: Advanced Formatting
Comments
02:48
Built-In Conditional Formatting
06:02
Custom Conditional Formatting
05:50
Summary of Advanced Formatting
01:09
Section 11 Assignment
03:43
The Advanced Formatting Quiz
5 questions
Section 12: Security
Revisiting Workbook Protection & Locking/Hiding Cells
02:45
Several Cell Protection options & Workbook Security
04:00
Summary of Security
02:28
Section 12 Assignment
02:54
The Security Quiz
5 questions
Section 13: Advanced Navigation & Handling
Useful Short-Cuts
03:03
Quick Analysis
02:16
Hyperlinks & Objects
02:26
Summary of Advanced Navigation & Handling
01:19
Section 13 Assignment
02:06
The Advanced Navigation & Handling Quiz
6 questions
Section 14: Applying our Knowledge 2
The Final Challenge – Try to rebuild it from scratch
06:48
Section 15: Introduction to Intermediate Concepts
Data and What-If Analysis
04:57
Pivot Tables & Consolidation
04:55
Advanced Functions & External Data
06:13
Excel Tool Development
02:27
What to do next?
02:07

Instructor Biography
Tobias Vermeer, Easy Excel for Everyone
My name is Tobias Vermeer, but you all can call me Toby, and I am an International Business Adminsitration student from The Netherlands.

My experience in Excel is quite extensive. I have been able to obtain my Microsoft Office Specialist certificate in Excel, which is an official certificate by Microsoft handed out after taking part in an exam to show your expertise within a certain part of Microsoft Office. For me this was Excel. Furthermore, I have developed (financial) tools and databases in excel for a Dutch pharmaceutical company with both the use of pure Excel functions and formulas and Visual Basic (VBA). These tools ranged from simple financial statements to project analysis, revenue tracking and more. Also, I have done statistical & economical analysis using Excel as part of the excellency program at my university and have done risk and investment analysis within Excel as well. The statistical & economical analysis involved using Excel for simulating demand and supply curves within the global coffee market to prove and visualize certain economical occurrences. The risk analysis involved creating a large market simulation in Excel to accurately define the risk rate of an investment project for a company. Alongside that I have adopted Excel as a hobby and try to constantly find new ways to improve my skills and create new, useful tools and programs. As such I have already been able to create a wide range of useful tools, like personal budgeting tools, planning tools, economical simulations and more. I am constantly trying to learn and improve.

My goal here is to teach everyone who wishes to know more about Microsoft Excel in an easy and understandable way, so that everyone can enjoy the power of Excel!

Course Features

  • Lectures
    Fatal error: Uncaught Error: Call to undefined method LP_Course::get_lessons() in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php:624 Stack trace: #0 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/single-course/content-landing.php(64): thim_course_info() #1 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #2 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/content-single-course.php(65): learn_press_get_template('single-course/c...', Array) #3 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #4 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(1563): learn_press_get_template('content-single-...') #5 /home2/waf6oo0adwwo/public_html/wp-includes/class-wp-hook.php(286): learn_press_content_single_course('') #6 /home2/waf6oo0adwwo/public_html/wp-i in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php on line 624