Excel Training

Overview:

Excel is not only a very powerful and incredible tool that maximizes productivity and accuracy in many tasks, but it is almost a requirement in every office and business that needs to calculate prices, automize schedules and analyze sales and profits.

No previous experience in Excel is necessary, we will walk you through all of the knowledge and will tailor our class based on the student’s needs and priority.

Our course will teach you everything you need to know to get started in the use of Excel:

 Agenda:

Our training is hands-on and we will use realistic examples and most common functionalities based on our 20 years of experience in the IT Training industry:

• A complete and detailed introduction of Excel’s Tabs and features.
• Step-by-step on how to perform basic functionalities such as: formatting cells, alignment of content, color fills, borders and renaming files and worksheets.
• Essential formulas allowing the calculations of averages, totals and other arithmetic operations.
• Complex functions to identify the maximum or minimum values, remove or identify duplicates, conditional formatting.
• An introduction of standard Charts, Pivot Tables and VLookup formulas.
• The training will conclude with the creation of a Macro that will automate the formatting of cells and simple additions to a spreadsheet.

Every participant will receive a Certificate of Completion that showcases their knowledge and could be presented to any potential employers or clients.