- Duration / Course length: Upto 12 Hours
- Timings: Flexible
Course details
Microsoft Excel Intermediate:
Course Outline:
1. 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
- Tracing Precedents and Dependent cells
2. 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
- Clear Filters
- Advanced Filtering (Criteria Range) o Summarizing worksheets with hidden and filtered rows (subtotal and aggregate functions)
- Data Validation
3. Reordering and Summarizing Data
- Sort Data
- Custom Lists
- Organizing data into levels using subtotals
- Creating an outline
- Lookup Functions
4. Combining Data from Multiple Sources
- 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
Eligibility / Requirements
- Basic knowledge of Computer and Internet.
Job roles this course is suitable for:
Services Sales Manager , Business Development Leader , Senior Sales Professional , AccountantsAbout 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.
Enquire about this course
You may add more courses here,
your list will be saved.
