Functional Excel Skills by Skillshare

This class is intended for Excel users who use Excel every day. This class is for users who wish to improve their functional skills.

We'll cover:

• Keyboard shortcuts
• Absolute and relative referencing, when using Tables
• There are some useful formulas, including VLookup or the new XLookup.
• Delimiters
• Data Validation
• Conditional Formatting
• Raw data processing
• Inserting tables
• Inserting Slicers
• Statements of Nested IF
• OR Statement
• AND Statements

Bonus Videos:

• Logic is used to fill in the gaps
• Insert rows underneath alternating rows

Viewer request:

• Pivot Tables
• Multi-Column Comparison

You will find new videos uploaded every now and again, so keep checking back for the latest content.

If you have any questions about Excel, please let me know.