Learn Microsoft Excel 2016 in 1 Hour (+12 Excel Templates)

1.) Work files to download for the course.

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

1.) How to create a new workbook within Excel.

1.) Knowing how to save a new workbook within Excel.

1.) Going over how to navigate within Excel.
2.) An overview of Excel basics such as the namebox, formula bar, cells and worksheets.

1.) How to add and remove worksheets.
2.) Renaming worksheets.

1.) How copying and moving worksheets between workbooks will save you a tremendous amount of time.

1.) How to hide and unhide worksheets.

1.) To make sure you fully understand how worksheets and workbooks function.
2.) Take action - Test out and experiment using worksheets and workbooks within Excel.

1.) Part 1 - Data types: dates, numbers & text.
2.) Part 2 - Working with cells.
3.) Part 3 - Columns and rows.

1.) Using various data types within Excel.

1.) How to edit data within cells and the formula bar.

1.) Using copy, cut and paste within Excel.

1.) Gaining an understanding of drag and drop.
2.) How to drag and drop cells between worksheets.

1.) Learning how to add and delete columns and rows.

1.) Knowing how to use find and replace in the most effective manner.

1.) Going over how to adjust column widths and row heights.

1.) Going over different methods of sorting columns and rows of data.

1.) To make sure you have a good knowledge of how to enter and edit data.
2.) Take action - Experiment and test out entering and editing data.

1.) Part 1 - Using borders.
2.) Part 2 - Cell modification.
3.) Part 3 - Cell formatting.

1.) Adding different types of borders to cells.

1.) An overview of how to merge cells together.

1.) How to wrap text in cells,
2.) Allowing multiple lines of text in cells.

1.) Transforming the appearance of worksheets with font size, color and text.

1.) Applying the date format to cells.

1.) Looking at various types of number formats.
2.) Applying number formats to cells.

1.) Going over how to create a table within Excel.
2.) Creating your own weekly planner.

1.) To Ensure that you fully comprehend how to format cells.
2.) Take action - Practice and test out your understanding of formatting within Excel.

1.) Part 1 - Formula basics.
2.) Part 2 - Working with functions.

1.) How to effectively use addition and subtraction formulas.

1.) How to effectively use multiplication and division formulas.

1.) Knowing how to use the SUM function.

1.) Understanding the most effective method of copying formulas.

1.) The importance of absolute cell referencing.
2.) How to effectively use absolute cell referencing.

1.) Boost your work rate with using formulas across worksheets.
2.) Master how to use formulas across worksheets.

1.) Demystifying VLOOKUPS.
2.) Understanding the various methods of using VLOOKUPS.

1.) Mastering IF STATEMENTS.
2.) Understanding the various methods of using IF STATEMENTS.

1.) Your exclusive #1 guide for Excel functions and formulas.

1.) To make sure you have a good understanding of functions and formulas.
2.) Take action - Experiment using various types of functions and formulas.

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

1.) Going over how to add print titles to worksheets.

1.) A guide on how to print a selected area within Excel.

1.) Going over various types of paper sizes.
2.) Selecting the appropriate orientation.

1.) Learning how to use margins in order to fit more data onto a worksheet.

1.) Looking at the different methods of scaling worksheets.
2.) How to apply the correct scaling to your worksheets.

1.) Working with various methods of using headers and footers.
2.) How to use custom headers and footers.

1.) Everything you need to know about getting the most out of printing worksheets,
2.) Adjusting printer settings for optimum functioning.

1.) To make sure you fully understand print options within Excel.
2.) Take action - Practice and test out print options and settings within Excel.

1.) Part 1 - Graphs And Charts Creation.
2.) Part 2 - Graphs And Charts Alteration.

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

1.) The even easier way of creating graphs and charts.

1.) How to effectively create pie charts.

1.) Learning how to use sparklines within Excel.

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

1.) Part 1 - Pivot Table Creation.
2.) Part 2 - Pivot Table Modification.

1.) How to create outstanding pivot tables.

1.) An overview of how to analyse and sort data using pivot tables.

1.) To ensure you have a good comprehension of how pivot tables function.
2.) Take action - Experiment and test out using pivot tables.

1.) Part 1 - Utilizing Values
2.) Part 2 - Working With Rules

1.) Understanding how to change a cell's appearance based on its value.

1.) Working with duplicate values.

1.) Looking at how top and bottom rules function and operate.

1.) Learning how average rules work.

1.) How to remove conditional formatting rules.

1.) How to use data bars, color scales and icon sets.

1.) To make sure you have a good understanding of conditional formatting.
2.) Take action - Test out and experiment with conditional formatting.

1.) Wrapping up all knowledge and information together for the final action step.