Free Excel Tutorials and resources

Video tutorials

• XLOOKUP introduction
• Excel functions basics
• Pivot Tables
• Shortcuts: Moving fast around
• Flash fill: Best function ever
• Freeze panes
• In-cell dropdown
• Date and time
• Conditional formatting
• Compare two tables with XLOOKUP
• Excel Number as text: Explanation and solution
• Excel: Charts best practice

Other resources

• Convert Kindle clippings.txt to an Excel table
• Excel: lookup multiple lines with a wildcard
• My collection of sample macros