Excel courses

...· 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, Financial Training...

...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 Excel, Microsoft Project, MS Excel...

...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: MS Excel, Microsoft Excel, 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: Microsoft Office Excel, Office IT, 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, MS Excel, Microsoft excel training...

...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: MS Excel, Statistical analysis, Pivot charts...

...summarise, analyse and manipulate your data with Excel Lists Single & Multi-level sorting Auto Filter & advanced filter Get external data Extract... Learn about: Excel 2010, MS Excel, Summarise Filter Sort Import and Export data...

...On receiving your request we will contact you to explain course content, including course dates and payment options. VBA Programming in Excel The topics covered are as follows... Learn about: VBA (Microsoft Access / Office), Microsoft Excel, Microsoft excel training...

...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: Office IT, MS Excel, Microsoft Office...

...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: Formula referencing, MS Excel, Create multi function calculations...