The Excel Environment - Increase your knowledge
- Identify the elements of the user interface
- Customize the excel interface
- Enter data in an excel workbook
- Navigate and Select Cells in Worksheets
- Create Formulas and Insert Function in a Worksheet
- Copy formula & functions
- Freezing row and column titles
- Using auto format
- Custom number formats
- Conditional formatting
Modifying the Appearance of a Worksheet
- Apply Font Properties
- Add Borders and Colors to Cells
- Align Content in a Cell
- Apply Number Formatting
- Apply Cell Styles
Outlining and Subtotals
- Outlining and consolidating data
- Creating subtotals
- Cell and range names
- Creating and using names
- Managing names
- Data structure and tables
- Sorting and filtering data
- Working with tables
Modify & Formatting an Excel Worksheet
- Modify fonts
- Check a worksheet for spelling errors
- Apply number formatting
- Add borders & colors for cells
- Align the content in cells
- Apply cells styles
- Find and Replace Data
Functions & Formulas for Optimization
- Moving and copying data & formulas
- Adding and Copying with Subtotals
- Table format
- Lookup functions
- Text functions
- Naming cells
- Understanding Logical Function
- Using IF To Calculate Values
Managing an Excel Workbook
- Manage Worksheets
- View Worksheets and Workbooks
- Format worksheet tabs
- Printing Excel Workbook
- Set the page layout options
- Set page breaks
- Print a workbook
Abu Dhabi National Exhibition Centre
Since last two years My Company is working with Simfotix, and every time it is great learning experience. MS Excel is one of the most recommended Program with distinctive methodology and valuable deliverables.
A very good training by Simfotix on HRBP with their International Partner Human Capital Institute. We covered high level including strategy.
Dubai Islamic Bank
Great training course and materials. Super helpful to learn shortcuts and their best application. Thank you!
The in-house training met the desired objectives for improvement in the Finance function. Group work throughout the two days and team presentation on various analytics put thing in the focus learning direction. Good output Simfotix.
Finance House Abu Dhabi
Inhouse Training with Simfotix Training for Credit Transformation Program goes with a Wonderful learning experience of our Credit Risk Team. Looking forward to engage them in other upcoming training.
Abu Dhabi Terminals
A combination of learning and sharing through activities and self presentations. Learning Art of Public Speaking with Simfotix Training is truly a good experience.
Arab Bank, UAE
The session was engaging and informative. Overall program outcome is what we agreed and delivered to department.
Emirates Islamic Bank
Simfotix In-House training is well organized and our team learned lot of new things. We consider this as a value addition and meeting our objectives.
Ministry of Human Resources & Emiratization
A very good training we attended with Simfotix Training.
Al Ghurair Group
Easy way of transferring knowledge makes the learning more digestible. Great work Simfotix for the in-house session of Advance Excel.
MAF Carrefour International
Thank you Simfotix for a comprehensive and value training to our Saudi Arabia Finance Team. Case Study and exercises were the key element of this workshop. As Learning & Development we are satisfied to work with them in future.
Selecting Simfotix as sour training and learning development supplier is a wonderful experience. They have done various inhouse programs. Their trainers carry in-depth knowledge and expertise and kept the participants well engaged.
The Executive Council of Dubai
Simfotix Trainer bear a Persuasive approach in training and the company is professional in the arrangement of training till end to make it a memorable experience. The In-house session and the follow-up session is excellent approach.
Department of Economic Development, Dubai
Excellent Training conducted by Simfotix Professional Development. The whole day was full of fun and learning in Advance MS Excel.
It is very important to analyze the need for Training along with the level of knowledge you require. This session give you a liberty to choose the modules you need, discuss it with the trainer how you want to be delivered, decide the place at your convenience and allocate number of hours to solve your problem. This does not include any development as a consulting but will include solution if you are facing a particular problem.