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...

... a conditional filter with AutoFilter Using the Top 10 AutoFilter Removing all AutoFilters ADVANCED FILTERS Using Advanced Filters Removing all Advanced Filters...

...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...

... of different sources, then explore the best ways to display and manipulate that data to give you a professional result. We also use a range of advanced functions and sheet controls and explore a number of advanced chart types... Learn about: Microsoft Excel, MS Excel, Business Intelligence...

...This course is about harnessing the power of Microsoft Excel to analyse business problems and identify solutions, allowing you to turn data into information to make sound decisions that, in today's fast-paced climate, can lead to a competitive business advantage. You gain the knowledge and hands... Learn about: Microsoft excel training, MS Excel, Financial Training...

... of different sources, then explore the best ways to display and manipulate that data to give you a professional result. We also use a range of advanced functions and sheet controls and explore a number of advanced chart types... Learn about: Microsoft Excel, Microsoft excel training, Business Intelligence...