- Duration / Course length: Upto 12 Hours
- Timings: Flexible
Course details
Microsoft Excel Intermediate1. Performing Calculations
- Naming groups of Data using Named Ranges
- Creating Formulas to Calculate Values
- Summarizing data meets specific condition
- using If function
- Formula Auditing
- Adding a watch Window o Tracing Formula Errors
- Changing workbook appearance
- Defining Styles
- Making Numbers easier to read
- Transposing data
- Changing Cell Orientation and Merging Cells
- Change appearance of data based on its value
- Focusing on specific data by using filters
- Inserting Filters
- Sort A to Z using Filters o Number Filters
o Advanced Filtering (Criteria Range) o Summarizing worksheets with hidden
and filtered rows (subtotal and aggregate functions)
- Data Validation
- Sort Data
- Custom Lists
- Organizing data into levels using subtotals
- Creating an outline
- Lookup Functions
- Using Excel’s Built-in Templates
- Using workbooks as templates for other workbooks
- Linking to data in other workbooks
- Consolidating data
- Saving workbooks as a workspace
- Comments in cells and workbooks
- Viewing Comments in a worksheet
- Adding and Removing comments
- Adding comments to a workbook
- Protection
- Password protect a worksheet and workbook
- Unlock cells and protecting part of a worksheet
- Track Changes
- Mark a workbook as final
Updated on 06 January, 2021
Eligibility / Requirements
Basic knowladge of computer and internet
Job roles this course is suitable for:
Services Sales Manager , Business Development Leader , Senior Sales ProfessionalAbout 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.