Microsoft Excel: Practical Skills for Daily Work

Module 1: Introduction to the Excel interface

• Navigating the ribbon, tabs, menus, formula bar, and status bar
• Understanding workbooks, worksheets, rows, columns, cells, and ranges
• Creating, opening, saving, and closing Excel files
• Moving through worksheets and selecting cells and ranges efficiently

Module 2: Entering and editing data

• Entering and changing text, numbers, dates, and simple lists
• Copying, moving, deleting, and filling cell content
• Using AutoFill for sequences, dates, and repeated values
• Correcting common data entry and formatting issues

Module 3: Creating and formatting tables

• Adjusting column widths, row heights, alignment, and text wrapping
• Applying number formats, borders, shading, and basic cell styles
• Structuring headings and data areas for better readability
• Converting data ranges into simple Excel tables

Module 4: Organizing and reviewing worksheet data

• Sorting and filtering lists by relevant criteria
• Finding and replacing values within worksheets
• Freezing rows and columns for easier navigation
• Using simple validation and review habits to identify errors