The Central Objectives of this programme are as follows:

• Create and use defined names in a workbook.
• Work with logical function in excel.
• Use a variety of data validation techniques.
• Use a range of lookup and reference functions.
• Create summaries in your spreadsheets using subtotals.
• Understand and create simple pivot tables.
• Construct and operate pivot tables using some of the more advanced techniques.
• Perform a variety of analytical tasks using PowerPivot.
• Use the data consolidation feature to combine data from several workbooks into one.
• Create and work with scenarios and the scenario manager.
• Use solver to solve more complex and intricate problems.
• Import data into excel and export data from excel.
• Create and use a range of controls in a worksheet.
• Create recorded macros in excel.
• Import data into excel and export data from excel.

Designing Approach

Tailor-Made for Your Needs: Solid State Training Solutions works closely with every client as a long-term strategic partner. We conduct pre-training requirements process which includes collecting details of the registered delegates and conducting training needs analysis meetings to align the training solution with the client’s objectives.

Delivery Methodology

• Simulation – providing life-like scenarios through structured learning experiences and to improve business awareness and management skills.
• Role Play – acting-out situations in groups, under the supervision and feedback of a lead coach.
• Presentations, Videos and Video Recording – visual materials to support presentations of theory.
• Games – learning is fun with Solid State Training Solutions! Using a variety of tools and games to emphasize the learning experience.
• Discussions – use two-way communication between the trainer and the trainees to increase learning opportunities.
• Questionnaires – to gather information from the participants, attributed or anonymous, free-form questions and multiple-choice.
• Case Study Analysis – a key tool for such workshops, either individuals or groups review the materials provided to understand a key message and then present their findings to the other participants.

Microsoft Excel spreadsheet software has become an integral part of most business organizations across the world. MS Excel is used for various purposes by business establishments. Some organizations use this spreadsheet software for generating memos, track sales trends, and other business data. Microsoft Excel spreadsheets software come with million rows of data and automate number crunching, but this popular spreadsheet software is capable of doing more than just figures. MS Excel has a simple interface that allows users to easily understand this software and also perform basic activities.

Microsoft Excel is commonly used for financially-related activities. The reason for its popularity is that the user can define custom formulas for calculating quarterly, half yearly and annual reports. This spreadsheet software also helps the individuals and professionals to effectively keep a track of sales leads, project status reports, and invoice reports. Microsoft Excel is also very popular among professionals from science background as it allows them to easily work with statistical formulas and graphing.

By the end of this course, participants will be able to gain the following:

• Use the fill operations available to fill a data series.
• Understand and use formula cell referencing to create more complex formulas.
• Use a range of logical functions.
• Apply conditional formatting to ranges in a worksheet.
• Create and use labels in a workbook.
• Work with various elements of a worksheet.
• Use a range of techniques to work with worksheets.
• Use a range of find and replace techniques.
• Apply a variety of page setup techniques.
• Sort data in a list in a worksheet.
• Filter data in a table.
• Create effective charts in Microsoft excel.
• Use a range of techniques to enhance charts.
• Apply formatting techniques to text on charts.