Learn essential data analysis techniques in Excel through this comprehensive 50-minute video tutorial. Master real-time internet data retrieval, efficient data entry methods, and AutoFill functionality. Discover shortcuts for editing, copying, and moving data, while exploring formatting options, data alignment, and understanding various data types. Dive into Excel formula basics, explore functions, and grasp data referencing concepts. Conclude with a practical exercise to reinforce your newly acquired skills in spreadsheet analysis.
Overview
Syllabus
- Simon Sez IT Intro
- Viewing, Entering, and Copying Data
- Formatting and Data Types in Excel
- Excel Formula Basics
- Exploring Excel Functions
- Referencing Data
- Exercise 01
Taught by
Simon Sez IT
