Learn Excel 2013 in 1 Hour (+9 Excel Templates)

1.) Work files to download for the course.

1.) Part 1 - Using workbooks.
2.) Part 2 - Using worksheets.

1.) How to create a workbook within Excel.

1.) Using various methods to save a workbook.

1.) Learning how to navigate throughout Excel.
2.) Excel fundamentals - Cells, name box, formula bar & worksheets.

1.) Adding and removing worksheets.

1.) Renaming a worksheet.

1.) How copying and moving worksheets between workbooks will boost your productivity by at least 25%.

1.) Hiding and unhiding worksheets.

1.) To ensure you fully understand how workbooks and worksheets operate.
2.) Take action - experiment and use workbooks and worksheets within Excel.

1.) Part 1 - Data types: Numbers, text & dates.
2.) Part 2 - Cells.
3.) Part 3 - Columns & rows.

1.) Inputting various data types within cells.

1.) Editing data within cells and the formula bar.

1.) How to copy, cut and paste cells.

1.) Learning how to drag and and drop cells.
2.) Dragging and dropping cells between worksheets.

1.) Adding and deleting columns and rows.

1.) Learning how to effectively use find and replace.

1.) How to adjust column widths and row heights.

1.) Looking at the various methods of sorting several columns of data.

1.) To ensure you have fully understood how you can edit and enter data.
2.) Take action - test out and practice editing and entering data.

1.) Part 1 - Borders.
2.) Part 2 - Cell manipulation.
3.) Part 3 - Cell formatting.

1.) Going over the various methods of applying borders to cells.

1.) Learning how to merge cells.

1.) Understanding how to wrap cells to allow multiple lines of text.

1.) How to change merged cells into standard cells.

1.) Learning how to enhance the appearance of worksheets with font size, type and color.

1.) Learning how to use and apply the date format.

1.) Going over various types of number formats.
2.) Applying number formats to cells.

1.) How to create a table within Excel.

1.) Ensuring that you fully understand how to format cells within Excel.
2.) Take action - Test out and experiment your knowledge and understanding of formatting within Excel.

1.) Part 1 - Printing fundamentals.
2.) Part 2 - Page layout.
3.) Part 3 - Printer setup.

1.) Learning how to apply print titles to worksheets.

1.) How to print a selected area within Excel.

1.) Using the correct paper size and orientation.

1.) Learning how to use margins to fit more data within worksheets.

1.) Going over various methods of scaling worksheets.
2.) How to correctly scale worksheets.

1.) Various methods of using headers and footers.
2.) How to customize headers and footers.

1.) How to efficiently print worksheets.
2.) How to optimally configure printer settings.

1.) To ensure you fully grasp the print options available in Excel.
2.) Take action - test out and experiment print options and settings within Excel.

1.) Part 1 - Basic formulas.
2.) Part 2 - The SUM function.
3.) Part 3 - Other functions.

1.) How to make the most effective use of addition & subtraction formulas.

1.) How to make the most effective use of multiplication & division formulas.

1.) Understand the power of the SUM function.

1.) The best and most effective way to copy formulas.

1.) The cheat sheet which you will want to keep for your entire Excel career.

1.) The incredible importance of absolute cell referencing.
2.) How to make the best use of absolute cell referencing.

1.) This will literally skyrocket your result rate with Excel.
2.) Learn how to use formulas across worksheets.

1.) Learn about the hidden power of VLOOKUPS.
2.) Understand the various ways of accurately using VLOOKUPS.

1.) How IF STATEMENT will change the way you look at Excel forever.
2.) Understand how to properly use IF STATEMENTS.

1.) Your exclusive bonus which contains all the functions that you need to know.

1.) To ensure you fully comprehend how functions and formulas work.
2.) Take action - experiment and test out various functions and formulas.

1.) Part 1 - Graphs and charts creation.
2.) Part 2 - Modifying Graphs and charts.

1.) The quick way of creating graphs and charts.

1.) The even quicker way to creating graphs and charts.

1.) Understanding and using filters.

1.) How to use pie charts in the best possible way.

1.) Learn how you can make the most use of sparklines.

1.) To ensure you have a good grasp of graphs and charts.
2.) Take action - Test out and produce graphs and charts.

1.) Part 1 - Creating pivot tables.
2.) Part 2 - Modifying pivot tables.

1.) How to create the best possible pivot tables.

1.) How to sort and analyse data using pivot tables.

1.) To ensure you fully understand how pivot tables work.
2.) Take action - Practice and test out pivot tables.

1.) Part 1 - Working with values.
2.) Part 2 - Using various rules.

1.) How to change cell appereances based on their value.

1.) Finding duplicate values is super simple!

1.) Find out the big difference between top and bottom rules.

1.) Find out why being average is actually a good thing.

1.) Discover the power of removing conditional formatting rules.

1.) How to make full usage of color scales, data bars and icon sets.

1.) To ensure you have a good understanding of conditional formatting.
2.) Take action - Try conditional formatting yourself.

1.) Putting all the knowledge together for the final action step.

1.) Sources for the images used within this course.