Microsoft Excel Intermediate Training
Microsoft Excel is commonly used by businesses UK-wide, but few know how to make the most of its many features.
In this introductory session, we explain some of the most useful features that Excel has to offer. We look at formulas and workbooks, and how you can present data in various forms.
Learn how to make the most of Excel.
Who is this course for?
Aimed at regular users, this session is all about working more efficiently by understanding Excel’s many time-saving features and some of the tasks you can usefully automate.
It will also help you add polish to reports and generate more insights from your data. To find out more, please contact us.
Work more efficiently.
Excel Intermediate Course Content
- Options and settings
- Customising the ribbon
- Tailoring the quick access toolbar
- Protecting worksheets and workbooks, including hiding, locking and setting permissions
- Advanced formulas
- Introducing further operators
- Relative and absolute cell references
- Array formulas
- Range names in formulas
- Adding linking formulas
- Circular references
- Overview of statistical functions
- Logical functions
- Creating IF formulas
- Tracing precedents
- Using DATE/TIME functions
- An overview of Math, IS and text functions
- Understanding and creating charts for different data sets
- Embedded charts versus chart sheets
- Refining and modifying a chart
- Inserting and formatting objects
- Chart formatting
- Create custom formats (number, time, date)
- Create conditional formatting rules using formulas
- Using styles and themes
For more information contact us...
If you need responsive and reliable IT solutions that are tailored to your business, then contact the experts at AMP. Our skilled engineers provide outstanding IT support and technical expertise you can depend on.
