Excel courses

...This one day course focuses on building on existing knowledge of Excel and the elements include: ♦ More advanced formulas and functions ♦ How to use “IF”...

...Cells & Autoformat * Rows & Columns * Printing & Print Preview New Age Training offers an extensive programme of PC training all featuring the latest release of software...

...based on experience in the real world. Let's get Excel to do some simple calculations. Charts / Graphs in 0.5 seconds! It really works! Automatically completing...

...charts, graphics, and formulas. Prerequisites We recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Excel...

...A basic understanding of mathematics is also required. Objectives Delegates will be able to : Change the view of a spreadsheet to show a different layout...

...within Excel and from an external source. Prerequisites To ensure your success, you must have a good grounding in Excel (to at least our Level 2 course standard or equivalent)...

...Users who want to gain a broader understanding of Excel, and utilise its more complex features to work with a greater degree of efficiency and sophistication in their spreadsheets...

...moving, adding and deleting. Enter data in to a new and existing worksheet. Apply formatting to change the appearance of text. Apply cell borders and shading...

...Calculate using multi-sheet and cross-book references in formulae. Summarise information using data consolidation. Sort data in alphabetical...

...expand on these and increase their speed. Each participant will be given a comprehensive reference manual to take away with them. The training session...

...Delegates will learn basic worksheet techniques and how to work with data in worksheets. Delegates will learn how to create a worksheet, perform simple calculations...

...Objectives How will you and your organisation benefit… Upon completion of this course you will be able to: ¨ Customise toolbars and create styles and templates...

...with using computers and have used a mouse and keyboard. Delegates should be comfortable in the Windows environment and be able to use Windows to manage...

...Change styles Freeze frames and control view Generate charts, non-adjacent data, picture charts, multiple charts Provide analysis, forecasts and trends...

...Excel program The Workbook environment Entering data and navigating in a worksheet Entering and correcting data Saving a file Using formulas Navigation...

...training support Certificate of attendence Course Outline Customising the Work Area Working with built-in toolbars Using custom toolbars Creating and using...

...customising and automating the built-in functionality of Microsoft Excel. This course is aimed at people who want to begin expanding their knowledge into enhancing...

...Files and Folders with VBA Controlling Other Applications with VBA Using Excel with Microsoft Access Enhancing the User Interface Dialog Boxes and Custom... Learn about: Analytic Expert...

...on Data in Microsoft Office Excel 2007 Formatting and Printing Worksheets in Microsoft Office Excel 2007 Filtering and Summarizing Data in Microsoft Office... Learn about: Microsoft Office...

...if preferred, courses can be tailored to suit delegates’ needs: select those areas where specific training is required. w Working with Advanced Filters...