ADVANCED EXCEL TRAINING WORKSHOP - 22ND & 23RD NOVEMBER 2018

Looking To Finally Be an Advanced Excel User?

Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?

Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.

What you get from this advanced Excel training course

Learn everything you need to be a world-class financial analyst

Received advanced Excel spreadsheet training

Master advanced formulas and functions

Create sophisticated outputs for financial analysis, including beautiful tables, charts, and graphs

Use advanced graphs in minutes instead of wasting hours trying to figure them out

Increase interactivity by automating your spreadsheets with macros and VBA

Solve complex problems with superpower functions 

Turn raw data into ‘must make’ decisions using PivotTables and PowerPivots.

And more!

Course Description

You’ll learn:

Time-saving techniques that’ll allow you to get your work done faster with Excel

Adding and using the Analysis ToolPak to make complex data analysis a snap

How to create a PivotTable® report to quickly analyze volumes of data, generate summary views, see comparisons and reveal patterns in your data

How to add power to your spreadsheets with Visual Basic® for Applications, including a quick way to learn VBA syntax

And much more!

You may use Excel daily, or maybe only casually, but one thing’s for sure—you’ve probably wished you knew more about this dynamic program. That’s why you’ll want to attend this workshop. In it, you’ll learn ways to make your job easier and increase the sophistication of your data reporting and analyzing. Each session focuses on saving-you-time techniques, advanced “how-to’s,” exploring those previously “programmer only” features and more. Along with this practical and usable training, you’ll learn how to integrate your work within the Office “family” for even greater results. If you’ve ever been frustrated using Excel because you knew there had to be a better way of accomplishing your tasks, you’ll soon be on your way to getting more done—and more efficiently—with this power-boosting workshop. Enroll today!

Day 1

Time-saving techniques

To really get the most out of Excel, you need to know not only how to accomplish certain tasks but how to accomplish them fast. That’s what this session is all about. You’ll learn some quick keyboard shortcuts that’ll get you where you want to be many times faster than using your mouse to maneuver through your worksheets. You’ll also uncover some amazing techniques for importing data so you don’t have to re-enter data from other applications. You’ll also learn …

Quick and easy techniques to import data from virtually any kind of file or database system, such as Microsoft SQL Server®, into Excel

How to format large blocks of cells quickly and efficiently with the power of Format Painter

Make your titles and headings stand out by using the Merge and Center formatting feature

Simple techniques to import and export your data to and from XML files

Merge data from multiple worksheets and keep the information up to date using external references

How to quickly create custom AutoFilters to view your data the way you want to and how to take advantage of the new search filter

Designing forms and formatting

Using Excel to create custom forms such as invoices, purchase orders and others is a great way to take advantage of some of the advanced features it has to offer. This session will show you how to create virtually any type of form quickly—and with features you might not have thought were even possible. You’ll discover …

How to create stunning 3-D effects with your cells and implement the new artistic effects on images in your worksheets

Using templates to create your worksheet can have you finished and on to the next project in a fraction of the time

How to use Excel to quickly create professional-looking forms in minutes (not hours!)

How to implement conditional formatting, take advantage of the new icon sets and a dozen other formatting tips and techniques for making your data stand out

How to add control items to your worksheets, including combo boxes, option buttons and many others

Data analysis and formulas

The real power of Excel is in data analysis, and that’s what this session is all about. You’ll dive headfirst into the data analysis techniques and formulas found in Excel, but you won’t have to be a mathematician to make sense of all the possibilities Excel has to offer. We’ll explain the most commonly used functions and analysis tools in plain English so you’ll walk away with the skills you need to get the most out of Excel. You’ll learn …

A technique that allows you to sum only the data that meets conditions you specify

Using the Goal Seek function to help determine how to get your desired result

The right way to use the Lookup Wizard to help you write a formula that finds the value at the intersection of a column and a row

What the Excel Solver is, how to load it and how to take advantage of the new user interface to get the most out of it

How to use the Scenario tool to do a what-if analysis

Advanced charting and graphing functions

Virtually anyone can put some numbers down in a spreadsheet, select them and then click the Chart Wizard button to create a reasonable-looking chart, but it takes advanced skills to make charts and graphs with stunning effects that really capture the reader’s attention. In this session, you’ll learn how to create some amazing special effects that’ll give your charts a professional appearance without taking hours to complete. You’ll find out …

How to quickly create a basic chart with a single keystroke

Use pictures to create exciting charts that are even more descriptive than typical line and bar charts

How to insert a Sparkline into a cell to instantly reveal patterns in your data

How to know which chart or graph type to use

How to add a chart—or virtually any kind of image—to a comment that displays when the user moves the mouse over a cell

Day 2

Getting the most out of PivotTable and PivotChart® reports

Trying to view and understand worksheets that contain hundreds or even thousands of rows of data used to be a nearly impossible task. But now you can use PivotTable reports to view and organize your Excel data quickly and easily, and that’s what you’ll learn in this session. You’ll discover how you can organize your data with just a few simple mouse clicks to see comparisons, reveal patterns and analyze trends. You’ll also find out …

The in’s and out’s of Excel PivotTable and PivotChart reports, including the terminology used in PivotTable reports

How to use slicers and other techniques to quickly drill down in your PivotTable without having to go back to your source data to identify specific information

The quick and easy way to create a PivotTable using the PivotTable Wizard

The techniques that allow you to instantly restructure your PivotTable and change the information reported

How to change your PivotTable field settings to a variety of options such as average, minimum, maximum or even custom settings

Maximizing the power of Excel with VBA and macros

You don’t have to have a degree in computer programming to take advantage of the power and flexibility of Visual Basic for Applications. In fact, in just this one session, you’ll gain the skills necessary to take Excel to a whole new level and uncover the real potential it has to offer. This session begins by showing you how to use the macro recorder. Then you’ll find out how to manually create macros and how to modify and tweak the code behind them. You’ll discover …

A simple tool for learning VBA syntax, including how to reference specific cells, a range of cells, worksheets and more

How to use loops to repeat commands multiple times

View and modify modules, forms and other worksheet code using the Project Explorer and Visual Basic Editor

How to write conditional If/Then statements in your code that can be used to execute other functions, control program flow, allow user input and perform many other functions

How to programmatically customize both the ribbon and the new Backstage view

Excel and the Internet

Microsoft has made it easy to publish your data on the Internet or your local intranet, but you have to know the right techniques to use in order to get the right results, and that’s just what you’ll learn in this session. We’ll show you how to save your spreadsheet to the Web quickly and easily, with professional-looking results that look like it took you hours to create. You’ll learn …

How to get continuously updated data from a Web site into a worksheet

Creating a macro that will update a chart published to a Web page at regular intervals

How to make the right choices when saving data to a Web page

Save time with the Excel Web Data add-in feature by using Web page data as a data source in your spreadsheet

Understanding how to collaborate and share a workbook both with and without using Excel Service

Validating and securing your data

Having data in your spreadsheet is only half the battle. Making sure your data is valid and secure is extremely important, and that’s what this session is all about. Your spreadsheets are only as good as the data they contain, and human error in data entry is an extremely common problem. We’ll show you some of the best techniques to help eliminate human error from your data management equation. You’ll learn …

How to lock values and formulas in your Excel worksheets

Track down mistakes in your worksheet using the Formula Auditing tools

How to use Information Rights Management (IRM) to protect your Excel files

How to share your Excel workbook and not worry about someone making changes that’ll ruin your work

How to use Data Validation to make sure the data going into any cell meets the criteria you’ve specified

Event Properties

Event Date 22-11-2018 8:00 am
Event End Date 23-11-2018 5:00 pm
Individual Price Ksh30,000
Ksh30,000

Copyright © 2018 Institute of Advanced Technology