-
All
-
Online
-
Filters
Excel courses Scotland
- Training
- Aberdeen
- Different dates available
- 1 Day
...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, MS Excel, Microsoft excel training...
- Course
- Aberdeen
- Different dates available
...manipulation, editing, printing and storage of workbooks. Excel Intermediate will allow you to gain the skills necessary to create templates... Learn about: Templates Module, Manipulating Worksheets, Manipulating data...
- Course
- Aberdeen
- Different dates available
...participants will have their own personal computer and colour monitor to work on. You will have the ability to create, manipulate, edit, print and store workbooks... Learn about: A First Look at Pivot Tables, Microsoft excel training, Communication Skills...
- Course
- Aberdeen
- Different dates available
...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, Import and Export...
- Course
- Aberdeen
- Different dates available
...Terminology and techniques are introduced to ensure knowledge and confidence is instilled allowing the participant to administer their duties and Excel tasks proficiently... Learn about: Number Formatting, Moving & Deleting, Alignment Formatting...
- Course
- Glasgow
...Moving Average Smoothing Seasonal fluctuations analysis Comparing Populations Confidence Interval for the Mean Test of Hypothesis Concerning the Population... Learn about: MS Excel, Data analysis, Excel Sheet...
- Course
- Glasgow
...charts, AutoShapes) Database management (list) Data consolidation Grouping and outlining data Sorting data (over 4 columns) Advanced data filtering Database... Learn about: Database training, Visual Basic, MS Excel...
- Course
- Glasgow
...trap Loop for ... next, loop ... each Loops for ... loop while, until Instructions loop break (exit) Visual Basic in action Download and upload data to a spreadsheet (Cells... Learn about: Construction Training, MS Excel, Data analysis...
- Course
- Glasgow
...Enter a Function Math and trigonometry function Statistical Functions Logical Functions Search and address Information functions Date and Time Functions... Learn about: MS Excel, Ms Office...
- Course
- Glasgow
...vs ADO Using the functionality in Access VBA code in Excel Outlook and Excel Automation Sending emails from Excel Reading data from Outlook Creating Applications... Learn about: MS Excel...
- Course
- Glasgow
...the correctness Recording and editing macros Visual Basic for Applications Create your own functions Results in VBA VBA Forms... Learn about: Visual Basic, Database training, Data analysis...
- Course
- Glasgow
...code protection from tampering and preview Key Excel objects: Application, Workbook, Workbooks, Worksheet, Worksheets, ThisWorkbook, ActiveWorkbook... Learn about: Data analysis, MS Excel, Construction Training...
- Course
- Glasgow
...Web Query Analytical issues Option Goal Seek The Analysis ToolPack addition Scenarios, Scenario Manager Solver and optimization data Macros and create... Learn about: Database training, Financial Training, MS Excel...
- Course
- Glasgow
...column width and row height Auto-fit AutoFormat Remove formatting from cells Working with Graphic Objects Graphical objects Drawing Toolbar Drawing objects... Learn about: Office IT, MS Excel, Microsoft excel training...
- Course
- Edinburgh
...Error GoTo On Error Resume Next Excel Model Object Application Object Workbook Object and Workbooks Collection Worksheet Object and Worksheets Collection ThisWorkbook... Learn about: Visual Basic, MS Excel, Visual Basic training...
- Course
- Aberdeen
...Mean Test of Hypothesis Concerning the Population Mean Difference Between Mean of Two Populations ANOVA: Analysis of Variances Goodness-of-Fit Test... Learn about: Microsoft Excel, Data analysis, Confidence Training...