Elegant Training Center Basic Excel for Administrator and Professional Elegant Training Center
50% Off for Laimoon Users! Get This Deal
Price: AED 900
AED 1,800
100% Money Back Guarantee
No questions asked refund With a goal of giving you a worry-free and secure enrollment experience, We offer a 24 hour money-back guarantee. Just send us a refund request via email within 24 hours after first class and we will refund 100% of your payment, no questions asked!
Instructor led live virtual classroom online. Classes may be individual or in group.
  • Location: Al Barsha - Dubai
  • Duration / Course length: Upto 12 Hours
  • Timings: Flexible

Course details

Microsoft Excel Basic

Enhance your skills with our Excel courses, specifically designed for administrators and professionals. Our Microsoft Excel training provides hands-on experience to help you manage data effectively. With convenient Excel online classes, you can learn at your own pace and boost your career prospects with essential Excel proficiency.

 

Content / Syllabus

1.    Setting up a Workbook:

  •  Creating Workbooks
  • Excel Terminology
  • Excel Environment
  • Customizing Quick Access Toolbar
  • Creating a New Workbook
  • Entering Data into Workbook
  • Saving a workbook
  • Open a workbook
  • Zoom
  • Insert a new worksheet
  • Renaming a new worksheet
  • Changing the tab colour of worksheet
  • Rearranging the order of worksheets
  • Move or Copy worksheet
  • Hide/Unhide Worksheet
  • Switch Windows
  • Modifying Workbooks and Worksheets 
  • Changing column widths and row heights
  • Insert Columns/Rows
  • Delete Columns/ Rows
  • Hide/Unhide columns or rows
  • Insert Cells
  • Moving Data by dragging
  • Customizing Excel
  • Arranging multiple workbook windows
  • Customizing the ribbon
  • Minimizing the ribbon

2.  Working with Data and Excel Tables:

  • Entering Data
  • Copy, Cut and Paste
  • Pick from drop down list
  • Find and Replace data
  • Spell Check
  • Thesaurus
  • Defining an Excel Table
  • Format as table
  • Table design
  • Basic Formulas
    • How to create a basic formula
    • Operators
    • Copy Formula down
    • Absolute cell reference
  • Basic Functions
  • What is the difference between formulas and functions
  • Insert a function
    • AutoSum, sum, min, max and average

3. Changing Workbook Appearance:

  • Format Cells
  • Changing Font, Font size and FontColour
  • Borders
  • Bold, Italic and Underline o Fill Colour
  • Themes
  • Format Numbers as percentage, currency and general
  • Insert a Picture
  • Picture Styles, remove background, picture effects
  • Insert Background

4.    Printing:

  • Inserting Headers and Footers
  • Print Preview
  • Page Setup
  • Page break preview
  • Print active worksheets
  • Print entire workbook
  • Print Selection
  • Print titles
  • Set Print Area
  • Centre data on page

 

 
 
 

Updated on 30 September, 2024

Eligibility / Requirements

Basic knowledge of Computer and Internet

About Elegant Training Center

Elegant Professional and Management Development Training stands as a distinguished training center in Al Barsha1, Dubai, UAE setting the standard for excellence in face-to-face training programs. As a KHDA-approved and Autodesk Authorized center, we pride ourselves on offering affordable, effective, and industry-recognized courses across diverse fields, including Engineering & IT, Finance, Sales & Marketing, and HR & Administration.
As a KHDA-approved center, our dedication to quality education is recognized by the regulatory authority, assuring you of our commitment to delivering courses that meet the highest standards.
Moreover, being an Autodesk Authorized center in Dubai underscores our expertise in providing cutting-edge training in engineering and technology.

See all Elegant Training Center courses

Enquire about this course

You may add more courses here,
your list will be saved.