Data analysis with Excel Mastercourse: Pratish Sharma has been an experienced course designer and presenter for more than ten years. He is an IT tutor and systems consultant at BPP professional education.
| Author | Sharma, Pratish |
| Position | What you learn on the... |
Before the turn of the millennium, I initiated an "Experience IT" programme within the hospitality and service industry, and also worked on projects relating to the "millennium bug". I have vast experience, presenting and developing course materials over three decades, as well as managing teams and projects, one-to-one coaching and mentoring.
This one-day, hands-on course is designed for those who use Excel on a regular basis and for those with underdeveloped skills in this area. It appeals not just to finance people, but also analysts and those who want to perform various forms of analysis that involve Excel skills.
The course offers quick tips in utilising the power of Excel. It involves analysis, error-checking, reporting tools, scenario and sensitivity analysis and data manipulation.
At the start of the day I like to open up a spreadsheet and introduce a few useful keyboard short-cuts and "hot keys". I usually ask people which short-cuts they know and already use, which people find interesting, and this is a good way of getting everyone enthusiastic and warmed up right from the start. We then work from a large, data-heavy Excel workbook containing a number of worksheets inside the file.
[ILLUSTRATION OMITTED]
During the day we use a course manual for reference at various stages, but focus on different topics that are each split into bite-sized sections. These might include time-savers, data searching, functions such as logical, error, text and nesting (for increased power), and pivot tables-basic to advanced, scenario building, problem-solving and simple automation using macros.
Key functional areas covered are: IF STATEMENTS AND NESTED STATEMENTS
Conditional and logical functions are worked with in depth. We explain the advantages of using IF statements to perform various forms of analysis by using them to create an output. These are taken even further by nesting the IF statement with multiple functions to perform more diverse calculations in just one formula.
A nested statement is a multifunctional formula that contains...
To continue reading
Request your trialCOPYRIGHT GALE, Cengage Learning. All rights reserved.
