Excel courses Scotland

...Advanced Functions Module 2: A First Look at Pivot Tables Module 3: What-if Analysis Module 4: Auditing Module 5: Data Validation Module 6: Hyperlinks Module... Learn about: MS Excel, Microsoft excel training, Microsoft Excel...

...manipulation, editing, printing and storage of workbooks. Excel Intermediate will allow you to gain the skills necessary to create templates... Learn about: Charting Techniques, Display Techniques, Linking & Consolidating Data...

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

...of turning numerical data into charts and graphs. This functionality, combined with many powerful and sophisticated features allow the creation... Learn about: Manipulating Worksheets, Import and Export, Manipulating data...

...Font Formatting Module 8: Alignment Formatting Module 9: Number Formatting Module 10: Formulas and Functions Module 11: Charts & SmartArt Graphics Module... Learn about: Alignment Formatting, Excel 2007 Foundation, Moving & Deleting...

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

...charts, AutoShapes) Database management (list) Data consolidation Grouping and outlining data Sorting data (over 4 columns) Advanced data filtering Database... Learn about: MS Excel, Database training, Visual Basic...

...On Error Resume Next, On Error GoTo label , On Error GoTo... Learn about: Construction Training, Data analysis, MS Excel...

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

...and how to secure it. Advanced Features of Excel Functions Panel The properties of an object from VBA Events Sheet, Workbook and Application Formula repeatedly... Learn about: MS Excel...

...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Visual Basic, Data analysis, MS Excel...

...Range) Download and upload data to the user (InputBox, MsgBox) The extent and lifetime of variables Operators and their priorities Useful module options Securing... Learn about: Construction Training, Data analysis, MS Excel...

...of values Validate the value entered in the cell Database Functions Summary data by using the histogram Circular references - Practical Aspects Tables... Learn about: Financial Training, MS Excel, Database training...

...Inserting Images We work with graphics The order set of graphic objects Creating Charts Charts Chart wizard Relationship data sheet of graph Data series... Learn about: Office IT, Ms Office, Microsoft excel training...

...of Variables and Objects Operators and Their Priorities Modules Options Creating Worksheet Functions Objects, Classes, Methods and Properties Locking Project... Learn about: Visual Basic training, Visual Basic, MS Excel...

...It will explain what Excel limitation are and how to overcome them. Aggregating Data in Excel Statistical Functions Outlines Subtotals Pivot Tables... Learn about: Data analysis, Microsoft excel training, Confidence Training...