Pivot tables are really very easy to create, but very powerful. By using Excel pivot tables, one can get very interesting and valuable business intelligence from your data in very little time. This short session aims to give you the techniques to use this valuable Excel tool creatively. It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.
This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.
professional financial modelling and data analysis courses
This course was developed for one of the largest investment institutions in the world, a multi-trillion household name. We explain in detail our tips and tricks to build an accurate and rolling enterprise value, and then review different valuation methodologies, from DCF, through the sum of the parts and football field analyses to LTV/CAC based methods. We conclude with a series of case studies examining the valuation of individual stocks.
Pushy boardroom bullies... battling agendas... conflicts of interest. Here are the most common drivers of trouble in the boardroom, and tools for making things right.
This is an essential programme for managers or members of staff (or students) who need to be able to read and summarise information on screen faster and more effectively. The session focuses on the different types of reading style and encourages better retention of written material through the use of specific speed-reading techniques. By the end of this programme participants will be able to: Explain the principles of speed reading Understand the barriers to reading Use different reading styles according to the information being read Read more effectively from tablet and computer screens Co-ordinate eye movements better Minimise any poor reading habits Increase reading speed by over 50%, without losing comprehension Improve retention of information using specific techniques The programme focuses on how to maximise reading from electronic devices by exploring techniques which will reduce eyestrain and improve reading effectiveness. The session also explains different types of reading styles and how to learn new, positive reading habits. 1 An introduction to speed reading The history of speed reading Assumptions about reading The process of reading Schema and its influence on interpretation Eye/brain relationship How our brain processes written information 2 Minimising barriers to reading Understanding eye tics Mouthing The influence of different light sources Body clocks and making use of natural patterns 3 Reading styles Importance of choosing the right reading style Speeds and their influence on retention Reading for pleasure Proof reading Scanning Skimming Reading for retention SQRW principles 4 Reading from electronic devices The challenge of reading from screens Importance of breaks and proper display screen evaluation Calibrating screens and background colours Formatting documents Using eye guides
The principles of effective time management are applicable to all aspects of life. When successfully applied in a sales environment they can lead to improved performance, higher sales and increased customer satisfaction. All salespeople would benefit from learning the tools and techniques to introduce impactful time management to their working lives. We have developed this programme to be practical, fun and interactive. Participants will better understand how to increase the amount of time spent on high-value sales activities, be able to improve their self-motivation and ability to get more done, and be better able to plan, delegate and speed up routine tasks. This course will help participants: Learn key principles of managing sales priorities, meeting targets and getting 'everything' done! Learn proven techniques for structuring your day, week and normal routine Develop effective sales time management at the office and on the road Learn a seven-step process for setting goals and objectives in your work and personal life Understand how to make time for sales prospecting, designated call days Understand practical ways to improve your time management 1 Key principles of sales time management Course objectives and review of time log Essential principles of sales time management How do you use your time now? Reviewing your working day (from pre-course survey) Beliefs and feelings about time 2 Managing sales priorities and planning systems Managing priorities and planning systems Use organised persistence to plan your sales activity Planning your territory and prospecting activity How to use priority ratings not urgency to react to tasks 3 Dealing with distractions and communication skills Know your time 'bandits' and creating more positive habits to overcome them Making time by saying 'no' assertively and managing expectations Assertiveness techniques for handling colleagues and clients Making meetings worthwhile - preparation and planning 4 Sales goal setting and action planning Set clear, concise, and motivating sales goals and action plans How to set and use goal setting as way of managing your time and increasing results The principles of linking SMART objectives to action plans and daily activities 5 Creating results focus - every day, week, and month Batch sales tasks together, starting with emails Planning your day and week and protecting sales 'prime' time Apply the 80/20 to your sales contacts, clients, and prospects 6 Overcoming procrastination and structuring your day Understanding procrastination, what it is and how to recognise it in yourself and others How to stop procrastinating and start making progressing Build a power prospecting hour into every day Smart stuff to make more sales time: five automated tools Live the $64,000 dollar question
This very practical workshop is designed to enable participants to improve the impact, clarity and accuracy of their business documents - both internal and external.: This workshop will help participants: Identify the purpose of writing their documents - to themselves and to their readers Recognise and meet the needs of their readers Plan documents systematically and improve the layout, flow and structure Express the content more clearly, concisely and correctly Adapt the tone and style of writing to the circumstances Proof-read and edit work effectively, using formal marks and techniques Improve visual layout, format and appearance 1 Course objectives Welcome and Introductions The problems now - group discussion 2 Writing better business documents What points to highlight / exclude Starting off Introductions Conclusions Executive summaries 3 Rules and standards George Orwell's famous maxim Why write? - clarifying your aims and objectives A seven-step method for better preparation The three-stage process for writing well Grouping information for your reader 4 Proof-reading and editing The difference between proof-reading and editing Proof-reading methods and strategies Proof-reading marks and techniques Training your eye for detail Knowing what to look for 5 Effective editing Grammar and English standards Words - usage and spelling Sentences - units of thought Paragraphs - themes Punctuation - spotting and correcting common errors Say what you mean - active v passive language 6 How's your English? Grammar quizzes and punctuation test Spotting spelling errors Rephrasing jargons and clicheÌs Common error's and mistakes 7 Document layout House style Use of white space Fonts and effects 8 One-to-one workshops These are practical sessions with one-to-one consultation with colleagues and the trainer They are held at key points to consolidate the learning from different sessions 9 Course summary Summary of key points Action plans