Our Excel Training workshops are tailored to meet your specific needs, taking you through all the features of Excel you require, often focussing on a specific business requirement. Detailed below are a selection of the topics which can be covered during training:
Excel Foundation
- Excel Fundamentals
- Text Wrap / Merge & Centre
- Rows & Columns
- Find & Replace
- Sort & Filter
- Headers & Footers
- Freeze Panes
- Organising Worksheets
- Number Formats
- Entering Valid Data
- Introduction to Formulas
- Basic Functions
- Absolute References
- Basic Charts & Graphs
- Introduction to Conditional Formatting
Excel Intermediate
- Insert Function
- Show Formulas & Formula Auditing
- Quick Access Toolbar
- Named Ranges
- Data Validation
- Data Transfer between Worksheets and Spreadsheets
- Charts & Graphs
- Conditional Formatting
- VLOOKUPs
- Pivot Tables / Slicers
- Recording & Replaying Macros
- Storing file on OneDrive / SharePoint
- Version History & Show Changes
- Clipboard
Excel Advanced
- Accessing files via Teams
- Excel / Power BI comparison
- XLOOKUP
- What If
- Forecasting
- Clipboard via non-Windows Apps
- Spreadsheets in specific work-related situations
For further information, please call 0114 4040 160 or Contact Us.