Excel for Scientists
- Improved Efficiency -Master essential Excel knowledge, including cell references, tables, and Power Query, to streamline your workflow
- Advanced Data Analysis - Gain skills in using logical functions, array formulas, and analytical tools like Goal Seek and Solver for in-depth data analysis
- Effective Data Visualisation - Utilise Conditional Formatting, PivotTables, and PivotCharts to visualise trends and key information clearly
- Automation and Customisation- Develop creating macros and writing VBA code to automate tasks and create custom functions
What to expect
- 24 months post training support included .
- Tailored and bespoke programme options .
- Our experienced training and logistics team in the last 23 years have assisted 209,877 people .
- Over 14,204 organisations trained .
- We are rated 'Excellent' on Trustpilot and 98.7% of our customers recommend us .
- Delivery UK wide and international (75+ countries delivered) .
Suitability - Who should attend?
This two day course is a comprehensive course designed to equip scientists with essential Excel skills to enhance their productivity and data analysis capabilities.
The course covers a wide range of topics, from basic best practices in workbook planning to advanced data analysis techniques. Participants will learn how to efficiently organise and analyse data, create dynamic reports, and automate tasks using Excel VBA code.
Training Course Content
Excel best practice
Planning a WorkbookIdentifying the audience and co-users
Recognise inputs, workings and outputs
Creating consistency and durability
Structure and Organising source data
Essential Excel knowledge to improve efficiency
Absolute and Relative cell referencesThe Table tool
Power query introduction
Visualise trends and key information with Conditional Formatting
Use Microsoft’s rulesUser defined rules
Manage rules
Introduction to Array formulas
Using embedded Excel Array formulasTREND, GROWTH, FREQUENCY
UNIQUE, SPILL, SORT, SORTBY, FILTER, GET
Creating bespoke Array formulas
Using analytical options
Using Goal SeekCreating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables
Solver
Creating modelsProjecting scenarios with Solver
Macros
Creating macrosUsing the macro recorder
Viewing and editing macro VBA code
Analysing data with the Analysis ToolPak
Exploring the data analysis tools in Analysis ToolpakVBA Understanding Visual Basic
Working with the Visual Basic EditorWhat is an Object?
Examining the Excel object hierarchy
Using the object browser
How to explore methods and properties
Getting help in VBA
VBA Making decisions in code
Using logical comparisonsThe IF...ENDIF structure
VBA Repeating code with loops
The DO... LOOP structure
The FOR... NEXT structure
The FOR EACH... NEXT structure
How to debug problems with loops
Storing information with variables
How and why you should declare variablesDetermining which data type to use
Public v Private scope
Using variables to trap errors
Using the Locals window to observe variables
Creating functions
Writing your own User Defined Functions (UDFs)Working with multiple arguments
Using your function in Excel
Expenses
Prices on application. Contact us for quote.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads