Microsoft Excel is one of the most used corporate programs on the planet allowing you to store and share data in a simple and professional format. With too much functionality to even considering listing learning it properly will give you a great advantage in the workplace that not many people have.
The following tutorials will start right from the very basics of excel for those that have never used it before and then continue onto some of the most advanced features of excel that will give you the edge in a professional environment.
- Microsoft Excel – 01: Spreadsheet Basics
- Microsoft Excel – 02: Formula Basics
- Microsoft Excel – 03: Data Types
- Microsoft Excel – 04: COUNT and COUNTA
- Microsoft Excel – 05: SUM
- Microsoft Excel – 06: AVARAGE, MIN and MAX
- Microsoft Excel – 07: Nesting Formulas and Rounding
- Microsoft Excel – 08: Dates
- Microsoft Excel – 09: Dates and Times
- Microsoft Excel – 10: Working with text 1
- Microsoft Excel – 11: Working with text 2
- Microsoft Excel – 12: Referencing other Sheets
- Microsoft Excel – 13: Hiding and Grouping Cells
- Microsoft Excel – 14: Sorting and Autofilter
- Microsoft Excel – 15: Merged Cells
- Microsoft Excel – 16: COUNTIF
- Microsoft Excel – 17: SUMIF
- Microsoft Excel – 18: Graphs
- Microsoft Excel – 19: Pie Charts
- Microsoft Excel – 20: Scatter Graph and Trend-lines
- Microsoft Excel – 21: Line and Area Graphs
- Microsoft Excel – 22: IF Statements
- Microsoft Excel – 23: Nested IF Statements
- Microsoft Excel – 24: IF Statements and Fixing Errors
- Microsoft Excel – 25: VLOOKUP
- Microsoft Excel – 26: VLOOKUP Across Worksheets
- Microsoft Excel – 27: HLOOKUP
- Microsoft Excel – 28: Conditional Formatting
- Microsoft Excel – 29: Validation + Drop Down Menu
- Microsoft Excel – 30: Named Ranges
- Microsoft Excel – 31: Named Ranges in Formulas
- Microsoft Excel – 32: Creating Your Own Formulas
- Microsoft Excel – 33: Pivot Tables 1
- Microsoft Excel – 34: Pivot Tables 2
- Microsoft Excel – 35: Pivot Tables 3
- Microsoft Excel – 36: Pivot Charts
- Microsoft Excel – 37: Mail Merge
- Microsoft Excel – 38: Running the Mail Merge
- Microsoft Excel – 39: R1C1 Referencing
- Microsoft Excel – 40: Importing Data from MS Access
- Microsoft Excel – 41: Importing Data from Another Spreadsheet
- Microsoft Excel – 42: Importing Data from a Website
- Microsoft Excel – 43: Array Formulas
- Microsoft Excel – 44: Array Formulas – Count
- Microsoft Excel – 45: Array Formulas – Sum
Once finished why not continue onto VBA in Excel
peace
Can you upload the samples for this series for free! ??? please
Hi please could you tell me where to find the datasheets in order to follow along with your tutorials. I am very impressed with the pace and content.
Thanks,
Mervin