Our beginners' Microsoft Excel course. This one day course is ideal for users new to Excel and assumes no knowledge of Excel. You will learn how to use the Excel user interface, enter data, use formulas and functions, format your work to look attractive and print and save your worksheets.
This course will extend your Excel knowledge and skills. If you have been using Excel for some time it'll take your skills to the next level and streamline your work. This course shows you how to use advanced formulas, organize worksheet and table data, create advanced charts and graphics and analyze data using Pivot Tables, Slicers and PivotCharts. You will insert and modify graphic objects and customize and enhance workbooks. Why not find out what Excel can do for you?
In our advanced Excel course we will show you how to use Excel's most powerful functions. You'll skills that let you: Enhance productivity by streamlining workflow, Collaborate with others, Audit worksheets and analyze data. In addition you'll: Work with multiple worksheets, Import and export data, Integrate Excel data with the web and Structure workbooks with XML.
IOn our 2 day Excel VBA course, you'll learn Applying Macros, Developing using Procedures and Functions, Using Objects, Controlling Program Flow, Utilising Variables and Expressions, Debugging the code, Handling Errors and Employing Forms and Controls.
This 1 day course will prepare you to create advanced workbooks and worksheets that you can use to produce dashboards. The ability to analyze large amounts of data, extract actionable intelligence from it, and present that information to decision makers is the key to operating a successful organization that is able to compete at a high level..
Upon successful completion of this one day Microsoft Excel training course, you will be able to use Power Pivot to analyze data from a variety of sources.
Upon successful completion of this one day Microsoft Excel training course, you will be able to use Pivot Tables to work with Excel data from a variety of sources.