- 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 05 March, 2024
Eligibility / Requirements
Basic knowladge of computer and internet
Job roles this course is suitable for:
Services Sales Manager , Business Development Leader , Senior Sales ProfessionalCourse Location
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.
Microsoft Excel Related Questions
Enquire about this course
You may add more courses here,
your list will be saved.