Excel courses Scotland

...features of Microsoft Excel. The course is designed to augment the trainee’s existing spreadsheet skills, thereby utilising Excel 2010 to its full potential... Learn about: Microsoft Excel, Microsoft excel training, MS Excel...

...Microsoft Excel is a spreadsheet application that incorporates tools for assisting in the recording and analysis of numerical data and which has the ability... Learn about: Linking & Consolidating Data, Manipulating Worksheets, Display Techniques...

...manipulation, editing, printing and storage of workbooks. The advanced course introduces the trainee to Microsoft Excel 2007 and the important advanced... Learn about: Microsoft excel training, Data validation, What-if Analysis...

...manipulation, editing, printing and storage of workbooks. Excel Intermediate will allow you to gain the skills necessary to create templates... Learn about: Manipulating data, Manipulating Worksheets, Sort & Filter Options...

...of turning numerical data into charts and graphs. This functionality, combined with many powerful and sophisticated features allow the creation... Learn about: Alignment Formatting, Number Formatting, Customizing Excel...

...Aggregating Data in Excel Statistical Functions Outlines Subtotals Pivot Tables Data Relation Analysis Normal Distribution Descriptive Statistics Linear... Learn about: Confidence Training, Microsoft Excel, Excel Sheet...

...of cells and ranges Protect worksheet and workbook Secure and encrypt files Collaboration and track changes, comments Inspection sheet Create your own templates... Learn about: Database training, MS Excel, Visual Basic...

...how to create Strainers having access to the filter criteria Fast text-to-column Delete duplicate data Forcing input the correct data - how to ensure... Learn about: Construction Training, Data analysis, MS Excel...

...workbook Windows workbooks Save files to disk Opening an existing workbook The use of functions in formulas Functions Construction features The function arguments... Learn about: Ms Office, MS Excel...

...of objects only available in Excel VBA code and how to create your own control library. Finally, participants will learn how to create a complete application... Learn about: MS Excel...

...Functions Subtotal (partial) Tables and Pivot Charts Cooperation with other applications Get External Data (CSV, TXT) OLE (static and link) Web Queries... Learn about: Visual Basic, Database training, MS Excel...

...Data tab Access to external data - do you really need to visit the bank's website every day to get to know the current exchange rate CHF? Defining connections... Learn about: Construction Training, Data analysis, MS Excel...

...(eg box - checkbox) Time value of money The current and future value of capital Capitalization and discounting Interest made ​​simple Nominal and effective... Learn about: Database training, MS Excel, Financial Training...

...the Page Setup Print preview A dialog box, printing Using lists Lists Transforming the range of the list Application forms AutoFilter Advanced filters... Learn about: MS Excel, Ms Office, Microsoft excel training...

...Functions and Sub-routines Data Types Control Flow If ...Then.Elseif.Else.Endif Case Do...Loop , While For... Next Exit Arrays and Loops Strings Visual... Learn about: Visual Basic training, Visual Basic, MS Excel...

...Audience Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel... Learn about: MS Excel, Microsoft excel training, Data analysis...