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.
|Section 1: The Beginnings|
What will you be working towards?
The File Menu – Saving, Opening, Exporting and More
Customization and Personalization
The Beginnings Quiz
|Section 2: The Worksheet|
Printing and Exporting to PDF
Navigating, Naming and Creating Multiple Worksheets
Protecting your worksheet
Hiding and Unhiding
Interacting with rows and columns
Summary of The Worksheet
Section 2 Assignment
The Worksheet Quiz
|Section 3: Layout|
Freezing, Splitting Panes and other Sheet Options
Summary of Layout
Section 3 Assignment
The Layout Quiz
|Section 4: Data Basics|
Entering Data and Data Formats
Referring to Cells and other Worksheets
Copying, Pasting and Absolute/Relative Referral
The FILL Handle, AutoFill and Flash Fill
Undoing and Redoing things
Finding and Replacing Data
Different Paste Options (Transposing, Only Values, Only Formatting etc.)
Summary of Data Basics
Section 4 Assignment
The Data Basics Quiz
|Section 5: Formatting|
Changing Cell Fill, Font and Border
Merging and Wrapping Cells
Content Alignment and Direction of a Cell
Format Painter and Clearing Cells
Summary of Formatting
Section 5 Assignment
The Formatting Quiz
|Section 6: Basic Formulas & Functions|
Creating a basic Formula
The SUM, AVERAGE and COUNT Functions
The IF, SUMIF, AVERAGEIF and COUNTIF Functions
The MAX and MIN Functions
The RIGHT, LEFT and MID Functions
The TRIM, UPPER, LOWER and CONCATENATE Functions
Name Ranges and the Intersection Operator
Calculation Operators and Order of Operations in Excel
3D Referencing Cells
Cell Grouping and Subtotals
The Circular Reference Error and Tracing Precedents/Dependents
Summary of Basic Formulas & Functions
Section 6 Assignment
The Formulas & Functions Quiz
|Section 7: Applying Our Knowledge 1|
Building an elegant budgeting tool
|Section 8: Tables|
Creating a Table
Table Sorting and Searching
Table Filters and Slicers
Summary of Tables
Section 8 Assignment
The Tables Quiz
|Section 9: Basic Graphs|
Creating a basic Graph
Explaining the different Graph Types
Different Graph Options
Summary of Basic Graphs
Section 9 Assignment
The Graphs Quiz
|Section 10: Graphical Objects|
Screenshots and Pictures
Summary of Graphical Objects
Section 10 Assignment
The Graphical Objects Quiz
|Section 11: Advanced Formatting|
Built-In Conditional Formatting
Custom Conditional Formatting
Summary of Advanced Formatting
Section 11 Assignment
The Advanced Formatting Quiz
|Section 12: Security|
Revisiting Workbook Protection & Locking/Hiding Cells
Several Cell Protection options & Workbook Security
Summary of Security
Section 12 Assignment
The Security Quiz
|Section 13: Advanced Navigation & Handling|
Hyperlinks & Objects
Summary of Advanced Navigation & Handling
Section 13 Assignment
The Advanced Navigation & Handling Quiz
|Section 14: Applying our Knowledge 2|
The Final Challenge – Try to rebuild it from scratch
|Section 15: Introduction to Intermediate Concepts|
Data and What-If Analysis
Pivot Tables & Consolidation
Advanced Functions & External Data
Excel Tool Development
What to do next?
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!