Home / Course catalog / Excel Level 1 – 1 Structuring ... (Bus_Excel_01-01)

Business tools

Excel Level 1 – 1 Structuring stable operational tables (Bus_Excel_01-01)


Description
Excel Level 1 – 1 Structuring stable operational tables focuses on the fundamentals of creating and managing tables in Excel. This includes learning how to organize data effectively, use proper formatting, and implement sorting and filtering techniques. Participants will gain skills in structuring datasets for clarity and consistency, ensuring that tables are easy to read and analyze. Key topics may include defining table headers, applying cell styles, and employing basic formulas to enhance data functionality. The goal is to provide a foundational understanding of tables that supports efficient data management and reporting.


Content
  • Introduction to MS Excel
  • Excel Spreadsheet
  • Insert Multiple Rows or Columns Easily
  • Workbooks in Microsoft Excel
  • Hide and Show Rows, Columns and Entire Worksheets
  • Worksheets in Excel
  • Find and Delete Empty Cells Located Outside of Your Data
  • Cell References in Excel
  • Absolute vs. Relative Cell References
  • Optional : Dynamic Named Range in Excel
  • Optional : File Formats in MS Excel
  • Use Tables Like a Pro
  • Layout Pages and Print Like a Boss
Completion rules
  • All units must be completed