Our Microsoft Excel course is very flexible – you will have the freedom to take the Excel lessons at with support on hand should you need it. And a workbook will be yours to take away as a handy reference guide. This Excel course comprises several lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace.
Microsoft Excel is one of the most commonly used spreadsheet programmes, whether used in businesses for customer data and accounting purposes or at home for household budgets. Having proven skills in this software will demonstrate to employers that you have had practical, hands-on experience and give you full confidence in your ability to navigate your way around the software with ease. Various interactive role plays are used to utilize skills in the participant-driven learning environment. Instructor feedback is provided to all participants so as to allow changes in the training process, habits and other skills to affect effective career. Lectures, comprehensive materials and roundtable discussions all function to improve participant success.
What to expect
This course is a highly practical, vocational, “how-to” programme based around real-world tools, checklists and processes that will be immediately useful to you back in your day job. You will not have to sit through long lectures or presentations – this course uses active learning to help you internalize the topic and apply it in the real world.
11) Data Manipulation in Excel
iii. Sorting and Conditional Formatting to identify trends
iii. Formatting for email
iii. Bar chart and when to use it
3) Pivot Table, Pivot Chart and PowerPivot
iii. Pivot Table Filtering
4) Business Data Analysis
iii. To make extremely intelligent reports
iii. Looking up the last data or pattern in a particular row or column
iii. COUNTIFS, SUMIFS, AVERAGEIFS and others, to make dynamic summary tables
5) Executive Dashboards and Reporting
iii. Determining the KPIs and tracking them
6) Excel to PowerPoint and Word
7) Excel VBA
Outlines, Subtotals & Consolidation
Protection and Sharing
The Scenario Manager
Practical: This course is heavy on reality and light on theory. Your trainer will introduce the concepts clearly, and then focus on real-world skills that connect the big picture to your job. Courses are updated regularly and trainers are active in the industry so your knowledge will be fresh and relevant.
Active: Training consists of concise briefings on best practice, backed up by interactive learning activities like workshops, role-plays, case study analysis, coaching, brainstorms and structured group discussions. You will not sit passively through long lectures.
Stimulating: This course is interesting, intellectually stimulating and delivered in a relaxed and professional style.
Inspiring: All REMOIK Pinnacle trainers are hands-on communication professionals with years of experience. We don’t employ academic teachers – we insist on good-humoured enthusiasts who will inspire your creativity