Excel courses Scotland

...of turning numerical data into charts and graphs. This functionality, combined with many powerful and sophisticated features allow the creation... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

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

...Auditing Module 5: Data Validation Module 6: Hyperlinks Module 7: Macros Module 8: Sharing Workbooks & Track Changes... Learn about: Microsoft Excel, Advanced Functions, A First Look at Pivot Tables...

...sort and filter data, import and export data, analyze data, and work with Excel on the Web. You will have the ability to create templates, sort and filter... Learn about: Import and Export, MS Excel, Manipulating data...

...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: Moving & Deleting, MS Excel, Formulas And Functions...

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

...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, Visual Basic, MS Excel...

...On Error Resume Next, On Error GoTo label , On Error GoTo... Learn about: MS Excel, Data analysis, 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...

...tricks to use other Excel features, for example double pie,and extracting numeric values ​​from text... Learn about: MS Excel...

...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...

...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: Construction Training, MS Excel, Data analysis...

...your own functions Starting and recording macros Working with VBA code Conditional Formatting Advanced conditional formatting using formulas and form elements... Learn about: MS Excel, Financial Training, 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: MS Excel, Ms Office, Microsoft excel training...

...This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in... 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: MS Excel, Confidence Training, Data analysis...