Advanced excel courses

...In the Introduction course to Excel 2003, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will streamline and enhance your spreadsheets with templates...

... templates and using macros. Suitable for: This one day course is aimed at anyone who wishes to utilise the more advanced features within the Excel program. Customers who wish to learn how to link Sage 50 Accounts with Excel should attend the Linking Sage 50 Accounts with Microsoft Office course...

...Microsoft Excel 2007 - All Levels Course Summary: Course Content: This course is offered over four levels: Beginners, Intermediate, Advanced...

...For people who need more advanced Excel training. Suitable for: People who have a good understanding of the basic of Excel...

...This course will expand upon the skills you learned in the introduction course and give you an opportunity to work with some more advanced features of Excel, including templates; sorting and filtering; importing and exporting; advanced formulas; analysis tools; and collaboration...

...Advanced features within Excel...

...To teach the Excel 2007 program to an employable level and to cover the City & Guilds Spreadsheet Processing Techniques Intermediate exam as well as part of the Microsoft Certified Application Specialist test (MCAS) and ECDL Advanced (Word Processing) exam. Suitable for: Those who wish to learn...

...To develop automated procedures in Excel XP using the Visual Basic for Applications language. Suitable for: Anyone who has some experience of recording macros in Excel...

...Delegates will learn how to create more complex worksheets using a variety of Excel functions including, representing data graphically and maintaining and managing lists. Suitable for: This course is designed for delegates who are already familiar with using Excel and can create simple worksheets...

... who has some experience of Excel 2003 and wishes to examine some of the more advanced features. Pre-Course Requirements Delegates should be familiar with the basics...

...To create modify and customise charts to graphically represent worksheet data To enhance worksheets with graphics and drawing tools To sort data To locate and use information managed by specific conditions. Suitable for: Anyone with a working knowledge of Excel who would like to...

...More advanced formulas and functions. How to use 'IF' functions. Linking worksheets within a workbook. Conditional formatting. Creating templates. Creating and customising graphs. Using Pivot tables. Suitable for: This course is aimed at people who use Excel regularly including. being already...

...On completion of Microsoft Excel 2007 Introduction you will be able to: Understand the origins and basic uses for spreadsheets. Start Microsoft Excel. Navigate workbooks, and exit correctly. Create, modify, save, and close a simple workbook. Select ranges of cells in a workbook. Edit...

...Training Course Outline: 1). VIEWING WORKSHEETS CUSTOMIZING VIEW OPTIONS Customizing the Excel window display Customizing the Comments View options...

...If you're already up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create...

...Course Outcome: Participants will be able to use Excel to present information in different applications. They will be able to work more extensively with formula and charts...

...Suitable for: Our 1 day Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel... Learn about: Microsoft Office...

... in order to produce professional and interactive reports and charts. Delegates should have a very good existing knowledge of Excel and ideally would have attended, or have knowledge of the concepts covered in the Excel Introduction and Intermediate courses. Learning Objectives Do you need to... Learn about: Microsoft excel training, Business Intelligence, Microsoft Excel...

... and PivotChartsCreating and examining macros This course is applicable to all versions of Excel from Excel 97 to Excel 2013. Furthermore, you can complete the Hands-On exercises in either Excel 2013, 2010, 2007 or 2003, allowing you to choose the version that better suits your needs. Learning Objectives You Will Learn... Learn about: MS Excel, Financial Training, Microsoft excel training...

... in order to produce professional and interactive reports and charts. Delegates should have a very good existing knowledge of Excel and ideally would have attended, or have knowledge of the concepts covered in the Excel Introduction and Intermediate courses. Learning Objectives Do you need to... Learn about: Microsoft excel training, Business Intelligence, MS Excel...