Knowledge Level

• Identify and analyze various data processing methods.
• Categorize commands based on their method of implementation.
• Understand different techniques for structuring data environments.
• Recognize where, how, and why to use each tool/smart feature.

Skills Level

• Conduct training needs analysis using appropriate tools and techniques.
• Use a combination of tools/formulas to solve the given task.
• Gain speed and accuracy through experience and practice, regardless of task complexity.
• Clearly determine which command, method, tool, or function to apply in each specific case.
• Seek new approaches and techniques to tackle any emerging problem.
• Communicate effectively and treat all learners equally within the training environment.
• Manage challenging situations that may arise during training sessions.

Attitude Level

• Show willingness and adopt ideas, opinions, and methods drawn from diverse experiences.
• Embrace diversity and adapt to changes.
• Persuade using sound arguments and confident body language.
• 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.