Knowledge Level

1. Identify and analyze various data processing methods.

2. Categorize commands based on their method of implementation.

3. Understand different techniques for structuring data environments.

4. Recognize where, how, and why to use each tool/smart feature.

Skills Level

1. Conduct training needs analysis using appropriate tools and techniques.

2. Use a combination of tools/formulas to solve the given task.

3. Gain speed and accuracy through experience and practice, regardless of task complexity.

4. Clearly determine which command, method, tool, or function to apply in each specific case.

5. Seek new approaches and techniques to tackle any emerging problem.

6. Communicate effectively and treat all learners equally within the training environment.

7. Manage challenging situations that may arise during training sessions.

Attitude Level

1. Show willingness and adopt ideas, opinions, and methods drawn from diverse experiences.

2. Embrace diversity and adapt to changes.

3. Persuade using sound arguments and confident body language.

4. Encourage and motivate all participants to actively engage in the seminar.

This seminar is designed for individuals with little to no prior experience in MS-Excel, who want to build a foundational understanding of its core functions. It is ideal for:

• Office staff, administrators, and clerical workers who need to perform basic data management tasks.
• Small business owners and entrepreneurs looking to organize and analyze business data more effectively.
• Students and professionals from various fields seeking to improve their digital skills and enhance productivity.
• Anyone interested in learning how to create, format, and manipulate spreadsheets for personal or professional use.

UNIT 1: INTRODUCTION TO “Ms-EXCEL” 

• Creating Folders to Save “Excel” Files
• Explanation of the “Excel” Menu
  (File, Home, Insert, Draw, Page Layout, Formulas, Data, Review, View, Help)
• 239 Excel Shortcuts
• Using the “Help” Function
• File > Excel Options (Useful Information to Know)
• Cut / Copy / Paste / Paste Special
  (Cut, Copy, Paste, Special Paste)
• Bold / Italic / Underline / Double Underline (Bold, Italic, Underline, Double Underline)
• Fonts / Font Color
  (Fonts, Font Colors)
• Cell Alignment
  (Alignment Within the Cell)
• Merge & Center
  (Merging and Centering)
• Using “Undo” – “Redo”
• View > Show Tab
  (Formula Bar, Gridlines, Headings)
• Data Table (Database)
  • Insert/Delete Rows
  • Insert/Delete Columns
  • Warnings for Deleting Cells
• Deleting Worksheets (Undo Doesn’t Work)
  (Worksheet Deletion)
• Hide / Unhide Worksheets
  (Hiding and Unhiding Worksheets)
• Practice on Topics Covered in Unit 1

UNIT 2: DATA MANIPULATION IN CELLS / WORKSPACE FORMATTING (WORKSHEET)

• Adjusting Row/Column Size
  (Rows/Columns Size)
• Cell Filling
  (Autofill With Numbers, Sequential Numbers)
• Find, Select, and Replace Cell Content
  (GoTo - Find & Select - Select & Replace)
• AutoSum
  (AutoSum “Σ” - Summation)
• Inserting Headers/Footers
  (Insert Header & Footer)
• Page Numbering
  (Insert Page Numbering)
• Inserting Images, Shapes, Text Boxes, WordArt, Symbols
  • Pictures
  • WordArt
  • Shapes
  • Symbols
  • Text Box
• Inserting Notes and Comments
  (Insert “Note” & “Comment”)
• Practice on Topics Covered in Unit 2

UNIT 3: PAGE LAYOUT – CELL FORMATTING

• Page Layout and Formatting
  (Margins, Orientation, Size, Set Print Area)
• Page Layout and Formatting – Continued
  (View / Print - Gridlines / Headings)
• Page Layout and Formatting – Continued
  (Insert Break – Page Break)
• Normal View – Page Layout View
• Zooming In/Out
  (Zoom – Only On Screen, CTRL + Mouse Wheel)
• Formatting Cell Content – Format Cells
  (Number, Alignment, Font, Border, Fill, Protection)
• Links / Hyperlinks
  (Creating Links / Hyperlinks)
• Using “Text to Columns” Option
  • Delimited (Data from One Column to Many Columns)
  • Fixed Width (Change Decimal & Thousand Separator)
• Practice on Topics Covered in Unit 3

UNIT 4: SCREEN LAYOUT - FREEZE/SPLIT SCREEN, CELL NAMING/RANGES

• Freezing Panes
  (Freeze Panes)
• Splitting Screen
  (Split)
• Printing Titles on Every Page of Long Content
  (Print Titles - On Multi-Screen Printouts)
• Creating Names for Cells or Cell Ranges
  (Create Names – Name Manager)
• Printing Worksheets/Entire Files – Settings Options
  (Printing of Worksheets/Workbooks - Options / Properties)
• Data Validation / Drop-Down Lists
  (Data Validation / Drop-Down Lists)
• Practice on Topics Covered in Unit 4

UNIT 5: AUTOMATED DATA TABLES

• Password Protecting Files
  (Save Workbooks Using Password)
  File > Save As > Tools > General Options
  • Password to Open
  • Password to Modify
• Relative and Absolute Cell Addressing
• Custom Lists
  (Custom Lists)
• Linking Between Two or More Worksheets/Files
  (Link Between Two or More Worksheets / Workbooks - Cell by Cell)
• Audit Relationships Between Formulas and Cell Values
  (Auditing – Dependents – Precedents – Trace Errors)
• Graphs / Charts – Editing and Formatting
  (Graphs / Charts – 3D Charts)
• General Options in Ms-Excel – Settings
  (Excel General Options – File > Options)
• Practice on Topics Covered in Unit 5

UNIT 6: FUNCTIONS / CALCULATIONS - CONVERSIONS, DATA SORTING/SEARCH

• Functions / Tools / Calculations / Formulas
  (Functions f(x) – SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MAX, MIN,
  ROUND, RAND, MOD, DATE Functions, Random Values)
• File Conversion: From “PDF” to “Excel” and “Excel” to “PDF”
• Sorting Data
  (Alphabetically, Numerically, Chronologically)
• Filtering Data Based on Criteria
  (Filtering)
• Practice on Topics Covered in Unit 6
  Questions, Answers, Discussion.