ΠΕΡΙΓΡΑΦΗ

The "Ms-EXCEL Basic Level" course is designed to equip participants with foundational skills in Microsoft Excel, enabling them to efficiently manage data, create and edit spreadsheets, and utilize basic formulas and functions. Through practical, hands-on training, attendees will develop the competence required to enhance productivity and accuracy in professional settings that demand proficiency in MS-Excel.

ΣΚΟΠΟΣ ΣΕΜΙΝΑΡΙΟΥ

The aim of this seminar is to familiarize participants with the basic functions and capabilities of MS-Excel, providing them with the necessary tools to manage data, create and edit spreadsheets, and use basic formulas and functions. Through practical training, participants will gain the knowledge and skills needed to work more efficiently and accurately in workplace environments that require the use of MS-Excel.

ΣΕ ΠΟΙΟΥΣ ΑΠΕΥΘΥΝΕΤΑΙ

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.

Training method

Our instructor conducts the seminar live on Zoom, offering an interactive virtual training experience that includes real-time collaboration, hands-on activities, dynamic presentations, and practical demonstrations.