Essential Excel Formulas and Tools

Introduction 1 lecture 07:02 Introduction Introduction 1 lecture 07:02 Introduction Introduction Introduction Introduction Introduction Module 1 - Using Large Worksheets 3 lectures 25:54 Hiding Columns and Rows Freeze Panes Group and Outline Module 1 - Using Large Worksheets 3 lectures 25:54 Hiding Columns and Rows Freeze Panes Group and Outline Hiding Columns and Rows Hiding Columns and Rows Hiding Columns and Rows Hiding Columns and Rows Freeze Panes Freeze Panes Freeze Panes Freeze Panes Group and Outline Group and Outline Group and Outline Group and Outline Module 2 - Working with Multiple Files 2 lectures 10:35 Arrange All - Multiple Excel Files Multiple Sheets - New Window Module 2 - Working with Multiple Files 2 lectures 10:35 Arrange All - Multiple Excel Files Multiple Sheets - New Window Arrange All - Multiple Excel Files Arrange All - Multiple Excel Files Arrange All - Multiple Excel Files Arrange All - Multiple Excel Files Multiple Sheets - New Window Multiple Sheets - New Window Multiple Sheets - New Window Multiple Sheets - New Window Module 3 - Linking 1 lecture 13:06 Linking Data Module 3 - Linking 1 lecture 13:06 Linking Data Linking Data Linking Data Linking Data Linking Data Module 4 - Paste Special 1 lecture 15:31 Paste Special Module 4 - Paste Special 1 lecture 15:31 Paste Special Paste Special Paste Special Paste Special Paste Special Module 5 - Range Names and VLookup/HLookup 5 lectures 33:33 Introduction to VLookup and HLookup Range Names - Applying and Using VLookup Syntax Using VLookup Using HLookup Module 5 - Range Names and VLookup/HLookup 5 lectures 33:33 Introduction to VLookup and HLookup Range Names - Applying and Using VLookup Syntax Using VLookup Using HLookup Introduction to VLookup and HLookup Introduction to VLookup and HLookup Introduction to VLookup and HLookup Introduction to VLookup and HLookup Range Names - Applying and Using Range Names - Applying and Using Range Names - Applying and Using Range Names - Applying and Using VLookup Syntax VLookup Syntax VLookup Syntax VLookup Syntax Using VLookup Using VLookup Using VLookup Using VLookup Using HLookup Using HLookup Using HLookup Using HLookup Module 6 - IFs and Logic 5 lectures 48:14 Introduction to IF Statements Creating IF Statements Using CountIF Using SumIF Using AverageIF Module 6 - IFs and Logic 5 lectures 48:14 Introduction to IF Statements Creating IF Statements Using CountIF Using SumIF Using AverageIF Introduction to IF Statements Introduction to IF Statements Introduction to IF Statements Introduction to IF Statements Creating IF Statements Creating IF Statements Creating IF Statements Creating IF Statements Using CountIF Using CountIF Using CountIF Using CountIF Using SumIF Using SumIF Using SumIF Using SumIF Using AverageIF Using AverageIF Using AverageIF Using AverageIF Module 7 - Conditional Formatting 3 lectures 25:14 Applying Conditional Formatting Top/Bottom Rules Text, Duplicate and Formula Rules Module 7 - Conditional Formatting 3 lectures 25:14 Applying Conditional Formatting Top/Bottom Rules Text, Duplicate and Formula Rules Applying Conditional Formatting Applying Conditional Formatting Applying Conditional Formatting Applying Conditional Formatting Top/Bottom Rules Top/Bottom Rules Top/Bottom Rules Top/Bottom Rules Text, Duplicate and Formula Rules Text, Duplicate and Formula Rules Text, Duplicate and Formula Rules Text, Duplicate and Formula Rules Module 8 - Date and Text Functions 4 lectures 34:00 TODAY, NOW and NETWORKDAYS Functions YEARFRAC Function - Calculate number of years between dates TEXT, LOWER, UPPER, PROPER, TRIM Functions - Great for formatting text CONCATENATE When you need to join 2 or more cell contents together. For Example: First Name and Surname. Or Address Line 1, Address Line 2 etc Module 8 - Date and Text Functions. 4 lectures 34:00 TODAY, NOW and NETWORKDAYS Functions YEARFRAC Function - Calculate number of years between dates TEXT, LOWER, UPPER, PROPER, TRIM Functions - Great for formatting text CONCATENATE When you need to join 2 or more cell contents together. For Example: First Name and Surname