Excel for Productivity – Analytical & Modeling Skills

Microsoft Excel is an invaluable tool for any one that needs to control, organize, analyze, and quickly refer to any kind of data. It also one of the most, if not THE most popular spreadsheet tool for the personal computer. Any business professional must have at least a cursory knowledge of the program. While some may think that mastery of Excel is a skill only accountants and financial analysts must hone, Excel can help anyone in any discipline become more efficient at working with data.

For every reason one has to compile analyze, Excel provides a different technique to streamline the process. The technical information may seem overwhelming at first but with a few tricks and some practice, anyone can get to know the in’s and out’s of an Excel spreadsheet. One uses a spreadsheet in a few different ways. A financial analyst or an accountant will use one to compile and analyze data and construct a financial model for his or her business, as well as crunch a large amount of that data to achieve a specific result. In our course, we will look at the ways one can you excel using real life examples. You will practice entering and customizing data and will also be asked to analyze a problematic spreadsheet. Fixing these problems will force you to identify mistakes in your own spreadsheets.

With the speed at which software development becomes more and more sophisticated, there is little need to memorize every formula and every function that you will ever need to use in excel. Part of our class will be teaching you tips and tricks to quickly find the information that tells you how to compute a group or groups of data for the purposes of you organization or even just a project you may need to work on. Have you ever been presented with large sheet full of hard to read, unorganized data? Our class will teach you how to articulate why you think the sheet could be better, and how to fix it. You will impress management and IT in no time.

Excel offers a sophisticated and easy to learn programming language called VBA (Visual Basic for Applications) that allows users to customize their Excel experience; this allows users to automate tasks in Excel and use “user defined functions.” These tools will enable you to get the most out of Excel by making you more efficient and customizing Excel in terms of what your organization needs you to do.

The topics covered in the course will run the gamut from basic windows commands like copy and paste, and formatting tools to programming macros, concatenation of data, and advanced formatting of data. In the beginning, we may concentrate on basic commands and concepts in Excel like entering and editing data and using basic mathematical formulas. We will continue with more intricacies like data labels and freeze panes, and go even further into data analysis functions and commands. Controlling print output will be covered as well because creating a clean, organized spreadsheet goes hand in hand with presenting it well.

Microsoft Excel can be used for tasks as simple as scheduling and pay role, and as complex investment banking tasks and financial modeling. Whatever your task, Manhattan Review can help you complete it faster and more accurately with our knowledge of Excel. This course is designed for you to receive and expound upon this knowledge, so in the future you can accommodate your Excel skills to whatever organization you happen to work for. With Manhattan Review’s Excel for Productivity course, we will take you from basic spreadsheet tools to advanced formatting and calculations in a way that fits the busiest professional’s schedule. Learn how to take advantage of the tools Excel has to offer: Develop your computer skills and develop your career.

Topics Covered

  • Macros
  • Intro to visual basic
  • Create and use pivot tables
  • Relative and absolute references
  • Computing data with formulas
  • Ways to be more efficient and minimize labor
  • Control print output
  • Use functions
  • Extract, combine, and transpose data
  • Create and embed objects
  • Develop workbooks and worksheets
  • Customize layouts
  • Create and modify templates