Microsoft Excel 2013 Training Tutorials, Notes and Discussions
Become an ExcelPert with self-paced online training & full support from the instructors
Our mission : We'll make you ExcelPERTs! And in the process, we'll make this the best Microsoft Excel 2013 Training Course Online, anywhere!
The Microsoft Excel 2013 Training Online Course is designed for everyone. You don't need any background in Excel or even MS-Office. The lessons are rigorous but focused. You'll take back one key idea from each video tutorial and to start working, we'll give you enough cheat-sheets and formula books.
What is Microsoft Excel 2013 and why should I be concerned?
Microsoft Excel 2013 is a spreadsheet (i.e. it has rows and columns where you can enter data). Excel also allows you to perform basic functions (adding all the cells in column for instance), automated functions (if the value in this row is "x", the value in this row should be "y") and advanced functions like tax planning, bookkeeping, statistical analysis and charts. Whether you work as an accountant, teacher, student, scientist, business manager or mathematician, if you play with data of any kind, Microsoft Excel 2013 is a fairly versatile tool to learn.
Why should I choose this Microsoft Excel 2013 Training Course?
- The instruction is thorough : The course is created by a cross-functional team of professionals from different backgrounds - accounting, teaching, business, technology and marketing.
- Lucid self-paced instruction : Video tutorials, notes you can download and discussions you can participate in - this is what 360-degree learning should be like, online.
- Brand new, yet, cost-effective : Unlike many other courses where you will get *only* videos for several hundred dollars, here you'll share with other learners and teachers at fraction of a cost.
What happens after I enroll in this course?
- You'll see our welcome note :)
- You'll find all the videos, discussions and notes under one course.
- You'll always find them there.
- Just log in to WizIQ and find the course in the left panel. That is it.
- A small note : You'll need a flash enabled browser to view the content (its free to download from Adobe.com). If you have questions, post it in the course feed
What does the course outline look like?
A. Excel 2013 Overview
- Understanding Excel 2013 Workbook
- Understanding The Ribbon
- Customizing The Quick Access Menu
- Understanding the back stage view
- Different ways to view a worksheet
- Creating a New Workbook
- Saving a Workbook
- Saving a workbook into other formats
- Pinning a workbook onto excel home screen
B. Working on Excel 2013
- Entering Data
- Editing Data
- Modifying Height & Width of Cells in Rows and Columns
- Using Cut, Copy & Paste Feature
- Using Cut, Copy, Paste on Multiple Cells & Worksheets
- Inserting & Deleting Rows or Columns
- Moving, Hiding & Unhiding Rows & Columns
- Using Wrap Text Feature
- Modifying Text Font & Size
- Modifying Text Alignment in Cells
- Learning How to Merge Cells
- Drawing Borders
- Learning to Enter various Date & Time Formats
- Entering Numbers - Currency, Percentage, Fraction etc.
- Adding Colours to your Worksheet
- Using Pre-Defined Cell Styles
- Using The Fill Handle Tool to Enter Data Quickly
- Using the Flash Fill (Magical) Feature in Excel 2013
- Using Find & Replace Feature
- Create, Delete, Rename & Protect a Worksheet
- Hide, Move, Copy & Colour a Worksheet
C. Using Formulas & Functions in Excel 2013
- Understanding Cell Range and Formula Bar
- Entering Your First Formula
- Doing Basic Addition
- Doing Basic Subtraction, Multiplication & Division
- Doing Complex Calculations
- Using Fill Handle on Formulas
- Editing a Formula
- Relative & Absolute Cell References in Formulas
- Introduction to Functions
- Using Functions for Sum, Average, Maximum & Minimum
- Count, Counta, CountBlank & CountIf Functions
D. Tables in Excel 2013
- Creating a Table
- Growing Your Table
- Formatting a Table
- Sort in a Table
- Filtering Data in a Table
- Filtering Numerical Data in a Table
- Removing Duplicates
- How to Write a vLookup Formula
- Using Absolute Cell References in vLookup
Language of instruction: English