Excel courses Scotland

...manipulation, editing, printing and storage of workbooks. The advanced course introduces the trainee to Microsoft Excel 2010 and the important advanced... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...sort and filter data, import data, analyze data, and work with Functions. SUMMARY Module 1: Functions Module 2: Manipulating Data & Named Ranges Module... Learn about: Protection and Security, Templates Module, Display Techniques...

...using the advanced features of MS Excel 2007. SUMMARY Module 1: Advanced Functions Module 2: A First Look at Pivot Tables Module 3: What-if Analysis Module... Learn about: MS Excel, Data validation, A First Look at Pivot Tables...

...SUMMARY Module 1: Functions Module 2: Manipulating Data & Named Ranges Module 3: Sub-Totalling Module 4: Templates Module 5: Formatting & Display Techniques Module... Learn about: Manipulating data, Linking & Consolidating Data, Sort & Filter Options...

...The course is also a pre-requisite to attending more advanced levels of training in MS Excel 2007. SUMMARY Module 1: A First Look at Excel Module... Learn about: Customizing Excel, Excel 2007 Foundation, Moving & Deleting...

...Moving Average Smoothing Seasonal fluctuations analysis Comparing Populations Confidence Interval for the Mean Test of Hypothesis Concerning the Population... Learn about: Confidence Training, Excel Sheet, Excel Formula...

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

...Do you feel that working in Excel, you come to a roundabout way of results? If you can answer YES to one of the questions then it's time stop this nightmare... Learn about: Data analysis, MS Excel, Construction Training...

...Text functions Format Cells Formatting numbers Aligning Formatting fonts Borders Shaded cells Style Conditional formatting Format painter Psychological... 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...

...Adjustment of the working environment Keyboard shortcuts, facilities Create and modify toolbars Excel Options (autosave, input, etc.). Options paste special (transpose)... Learn about: Database training, MS Excel, Data analysis...

...of similar operations to prepare the data for analysis? Do you know all the keyboard shortcuts in Excel, but you are not satisfied with the results?... Learn about: Data analysis, Construction Training, 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: MS Excel, Financial Training, Database training...

...column width and row height Auto-fit AutoFormat Remove formatting from cells Working with Graphic Objects Graphical objects Drawing Toolbar Drawing objects... Learn about: Microsoft excel training, Ms Office, Office IT...

...as a three day course. Macros Recording and Modifying Macros Assigning Macros to Toolbar, Buttons, Shortcut key Visual Basic for Applications Environment... Learn about: Visual Basic, Visual Basic training, MS Excel...

...Mean Test of Hypothesis Concerning the Population Mean Difference Between Mean of Two Populations ANOVA: Analysis of Variances Goodness-of-Fit Test... Learn about: Data analysis, Confidence Training, MS Excel...