Administration and Executive AssistantTier 030 minbeginner

File Formats: When to Use What

Understand .xlsx, .xls, CSV and when each one is the honest choice.

What you will learn

• Know what formats preserve formulas, formatting, and VBA
• Understand CSV limitations and advantages
• Save a workbook in multiple formats
• Recognize when a format change will lose information

Excel skills

Save As, file format options · File Formats

The quiz

5 scenario-based questions, each with an explanation once you answer.

Try this lesson free