تفاصيل الدورة
This course is designed for those who are familiar with the normal office Excel.To extract more on the advanced options in Excel to improve the productivity.The course gives a detailed and systematic way to cope with the advanced techniques in M.S Excel.
Course Content
- Introduction - Excel Specifications and Limits.
- Excel Formulas.
- Logical Functions.
- Conditional Formatting.
- Data Validation.
- Pivot Table and Charts.
- Advanced Sorting Options.
- Advanced Filter.
- Worksheet, Workbook and Workspace.
- Hyperlink Worksheets.
- Linking Sheets Workbooks.
- Data tables.
- Scenarios.
- Paste Special Options.
- Formula auditing
- Formatting Workbook.
- Advance Chart Options.
- Working with Date and Time.
- Freeze Pane and Split Pane Options.
- Use of Watch Window.
- LOOKUP, VLOOKUP & HLOOKUP Functions.
- Protecting Workbooks.
- Protecting worksheet with Permission to edit a Range.
- Microsoft Excel Tips.
- Introduction to Macros.
- Workbook sharing.
- Tracking changes.
- Merging workbooks
نبذة عن معهد Family Computer Center
Family Computers is one of the pioneering companies to open computer training centre in Qatar and provides training services to corporate houses and individuals alike. we provide training for a wide range of topics related to computers and have trained in excess of 40,000 students. A figure which is more than most of the training providers put together.
We are always in the forefront in launching job oriented, practical computer training courses. We emphasis on the importance of individual attention to students and limited students in a batch. This also helps us to improve the quality of our service.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Microsoft Office Complete Diploma Alpha Academy91 ريال قطري
1,235 ريال قطريمدة الدورة التدريبية: Upto 2 Days - Microsoft Excel Power Query Course Central82 ريال قطري
363 ريال قطريمدة الدورة التدريبية: Upto 3 Hours
