Excel courses

...Excel 2007 Intermediate Excel XP Excel 2003 Excel 2000 ECDL Module 4 - Spreadsheets Courses take approximately 2-4 hours to complete (as and when)...

...· Excel Environment · Toolbars · Office Assistant Workbooks and Worksheets · Creating And Opening Workbooks · Working With Workbooks · Working With Worksheets...

...Spreadsheets Freeze panes Split window Arrange windows Consolidating Data Consolidating worksheets Consolidating workbooks Lookup Functions VLOOKUP HLOOKUP... Learn about: MS Excel...

...entering text and numeric data, navigation, saving, naming and closing, opening an existing spreadsheet, editing cell contents, accessing help Lesson Two – Including...

...Inputs vs. formulae, PDF document tricks for efficient data extraction into Excel Building Flexible Formulas in Excel: Relative vs. Absolute referencing... Learn about: MS Excel, Financial Professionals, Intermediate Excel...

...View Options · Displaying And Customising Toolbars · Hiding Workbooks And Worksheets · Freezing Panes · Grouping And Ungrouping Worksheets More Formatting...

...Create a PivotChart Create Scenarios Use Goal Seek Macros Record and run a macro Relative vs. absolute recording Edit a macro Macro security Customising... Learn about: MS Excel...

...plus much more. We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of... Learn about: Microsoft Office, Microsoft Excel, Microsoft excel training...

...And with short sections, you can work through a new topic in 30 minutes. Technical Requirements Computer Pentium-class PC or equivalent... Learn about: MS Excel...

...Text Files · Using Microsoft Query · Querying Data From The Web · Refreshing Data Templates and Styles · Working With Templates · Working With Styles Analysing...

...2. Course description For anyone who is already confident using Excel and wants to learn all the necessary skills to utilise Excel pivot tables and pivot charts for data analysis... Learn about: MS Excel, Data analysis...

...When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see... Learn about: Microsoft excel training, PC training, Design techniques...

...from Excel We are one of only five colleges in the UK to be granted Foundation Degree Awarding Powers by the Privy Council – meaning our higher education... Learn about: MS Excel...

...to Excel who want to learn new skills and apply them effectively. Core Topics A First Look at Excel • Starting Excel • Entering numbers and text • Worksheets...

...insert tables, record macros and much more. On successful completion, you will have a solid knowledge of how to utilise the world’s leading spreadsheet... Learn about: Office IT, Excel Commands, Microsoft Excel...

...Master the art of Project Management with our online training and become one of the most valuable people in your company – you won’t regret it. We all... Learn about: Microsoft Excel, IT Project Management, Project Management...

...To be able to conduct statistical analysis of data using Microsoft Excel. Suitable for: Researchers, Graduates, Engineers 2 days practical data analysis using microsoft excel... Learn about: Microsoft excel training, Data analysis, Microsoft Excel...

...summarise, analyse and manipulate your data with Excel Lists Single & Multi-level sorting Auto Filter & advanced filter Get external data Extract... Learn about: Manipulating data, Microsoft Excel, Excel 2016...

...Pre-requisites Basic keyboard and PC skills and a knowledge of the windows environment is assumed Objectives The aim of this course is to have the participant... Learn about: Excel 2010, MS Excel, Excel Sheet...

...Options Customise Quick Access Toolbar Customise the Ribbon Excel Options Advanced Autofill Fill Weekdays Fill Values Only Growth Trend Format Worksheets Apply accounting... Learn about: Create multi function calculations, Formula referencing, MS Excel...