Intermediate Excel

Core Excel Functions and Features (8 hours)
Introduction to Intermediate Excel (1 hour)

• Overview of intermediate Excel capabilities
• Importance of these skills in data management

Using Excel Functions (2 hours)

• Common functions (SUM, AVERAGE, COUNT, MAX, MIN)
• Date and time functions
• Text functions (LEFT, RIGHT, MID)

Creating Custom Templates (1 hour)

• Designing and saving templates
• Using templates for consistency

Using Styles (1 hour)

• Applying and modifying cell styles
• Creating custom styles
• Using themes for consistent formatting

Linking Formulas (1 hour)

• Creating and managing links between sheets
• Updating and troubleshooting links

AutoFill and 3-D References (1 hour)

• Using AutoFill for quick data entry
• Creating and using 3-D references

Review and Q&A (1 hour)

• Recap of key points
• Open floor for questions and discussion

Day 2: Advanced Excel Features (4 hours)
Absolute References (1 hour)

• Understanding relative vs. absolute references
• Using absolute references in formulas

Protecting Sheets (1 hour)

• Protecting cells and sheets
• Setting permissions and passwords

Filtering and Sorting (1 hour)

• Using filters to manage data
• Sorting data for analysis

Using Hyperlinks (0.5 hour)

• Creating and managing hyperlinks
• Linking to external documents and web pages

Final Review and Q&A (0.5 hour)

• Recap of key points
• Open floor for questions and discussion