Excel Data Management: Data Import, Handling, and Basic Analysis
Course
This course introduces foundational Excel skills for working with data, including basic data entry, simple calculations, and essential data handling techniques.
Skills you’ll gain: basic data entry and editing, performing simple calculations using formulas, using basic Excel functions (SUM, AVERAGE, IF, COUNT, MAX), sorting and filtering data, using copy and paste options effectively, and applying basic data cleaning techniques such as find and replace.
Here is the course outline:
1. Data Entry and Basic Data ManagementCovers essential data handling techniques, including manual data entry, copying and pasting, appending data to worksheets, importing external data, and using Find and Replace to update and manage datasets efficiently. 4 sections
|
||||
|
2. Data Sorting, Filtering, and Basic FormulasFocuses on organizing and analyzing data using sorting and filtering tools, along with applying basic formulas such as SUM, AVERAGE, and COUNT for simple calculations. 4 sections
|
||||
|
3. Data Importing and Data Handling TechniquesCovers importing and exporting data, working with CSV files, using copy and paste techniques including Paste Special, applying AutoFill, and managing data efficiently using essential tools. 3 sections
|
|||
|
4. We want to hear from you!Learning Management System — NPS 1 section
|
|
|