- Duration / Course length: Upto 10 Hours
- Timings: Flexible
Course details
Microsoft Excel Basic1. 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
- Changing Workbook Appearance
- Format Cells
- Changing Font, Font size and Font
- 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
- 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 06 January, 2021
Eligibility / Requirements
Basic knowledge of computer and internet
Job roles this course is suitable for:
Administrative Assistant , Accounting Manager , Business Leader - MarketingAbout Elegant Training Center
Elegant Professional and Management Development is a leading training center in Al Barsha, Dubai, specialized in affordable and effective face-to-face training programs in variety of courses like Engineering & IT, Finance, Sales & Marketing and HR & Administration.
We design and customize courses and program for people of different walks whether trying to enter into the job market or employees willing to achieve professional development and qualification to secure advancement in their careers and improve their performance level.
Our training is stretching, motivating and tailored to the individual learner. We develop and deliver training courses for organizations across all sectors. All of our courses can be tailored specifically to your team’s needs and delivered at your site as well
Enquire about this course
You may add more courses here,
your list will be saved.