Price: EGP 600
  • Location: Heliopolis - Cairo
  • Duration: 5 Days
  • Timings: Part Time, Weekday evening classes

    Course details

    Chapter 1: Office Workspace Basics
    • Basic Window Elements
    • Exploring Microsoft Office Backstage
    • Working with the Ribbon
    • Customizing the Quick Access Toolbar
    • Working with KeyTips
    • Using the Status Bar
    • Getting Help
    Chapter 2: Introduction to Excel
    • What is Excel?
    • Getting to Know the Excel Window
    • Moving the Cell Selector
    • Opening a Workbook
    • Navigating a Workbook
    • Selecting Cells
    • Creating Workbooks
    • Saving a Workbook
    • Closing a Workbook
    Chapter 3: Entering and Editing Data
    • Entering Text, Numbers, and Data
    • Editing Data
    • Using AutoComplete and AutoFill
    • Copying Data
    • Moving and Clearing Data
    • Using Undo and Redo
    • Finding and Replacing Data
    Chapter 4: Introduction to Formulas and Functions
    • What are Formulas and Functions?
    • Entering Formulas
    • Entering Functions
    • Using the Insert Function Tool
    • Using AutoSum
    • Copying and Moving Formulas
    Chapter 5: Working with Functions
    • Using Statistical Functions
    • Using Financial Functions
    • Testing Conditions with IF
    • Using Date and Time Functions
    • Using Linked Values in Formulas
    • Copying Formula Values
    • Controlling Automatic Calculations
    Chapter 6: Formatting Data 
    • Introduction to Formatting
    • Applying Number Formats
    • Applying Font Formats
    • Changing Cell Alignment
    • Applying Cell Styles
    • Copying Formats
    • Clearing Formats
    • Finding and Replacing Formats
    Chapter 7: Formatting Worksheets 
    • Inserting and Deleting Rows and Columns
    • Inserting and Deleting Cells
    • Adjusting Column and Row Sizes
    • Hiding Worksheet Components
    • Inserting and Deleting Worksheets
    • Copying and Moving Worksheets
    • Customizing Sheet Tabs
    • Adding a Worksheet Background
    Chapter 8: Adding Charts and Graphics 
    • Creating a Chart
    • Enhancing a Chart
    • Modifying Chart Data
    • Changing Chart Types
    • Drawing Shapes
    • Inserting Pictures
    • Creating SmartArt
    Chapter 9: Viewing and Printing Workbooks
    • Changing View Options
    • Splitting and Freezing a Worksheet
    • Sorting and Filtering Data Info about Slicers
    • Customizing the Page Layout
    • Adding Headers and Footers
    • Modifying Page Breaks
    • Previewing and Printing the Worksheet
    • Printing Selected Data
    Chapter 10: Managing Workbooks 
    • Arranging Multiple Workbooks
    • Adding Hyperlinks
    • Working with Comments
    • Saving Workbooks in Different Formats
    • Saving a Workbook as a Web Pages
    • Creating Folders
    • E-Mailing a Workbook Updated on 15 January, 2024

    Job roles this course is suitable for:

    Office Manager , accountants , engineers

    About INFORM

    INFORM provise Training Services, Software Solutions & Consultations, and Outsourcing Services
    We are one of the world’s leading providers of training, information and knowledge on standards, management systems, business improvement and the achievement of regulatory approval for products. 
    INFORM واحدة من رواد فى مجال تكنولوجيا المعلومات تضم ‌فريق متميز لتقديم خدمات تكنولوجيا المعلومات, وحلول لتطوير انظمة الشركات والقيام بعمل انظمة خاصة متكاملة تسمح بزيادة كفاءة وسرعة الاتصال لتنسيق جميع الموارد والمعلومات  See all INFORM courses
    Courses you can instantly connect with... Do an online course on Microsoft Excel starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or