Magazine article Financial Management (UK)

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

Magazine article Financial Management (UK)

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

Article excerpt

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. …

Search by... Author
Show... All Results Primary Sources Peer-reviewed

Oops!

An unknown error has occurred. Please click the button below to reload the page. If the problem persists, please try again in a little while.