Excel Essentials

At AMP, we can give you the skills and confidence to use every part of your IT infrastructure properly and efficiently. We know just how important it is that you and your staff can get the most from your systems, so we offer bespoke courses that are developed with your needs in mind: your team, your operations, your industry and your commercial aspirations.Our purpose-built IT training centre is the ideal venue for skills development and learning about all things IT. Boasting sophisticated audio-visual facilities and excellent connectivity, it’s where we deliver most of our own training courses and refresher sessions, but it’s also available for hire to other trainers.Whether you’re looking to develop your own skills or those of your workforce, take your next steps with AMP.

AMP Information Systems

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.
Creating & Managing Workbooks & Worksheets Overview of the user interface Creation of worksheets and workbooks Navigation within worksheets and workbooks Formatting of worksheets and workbooks The configuration of page setup and headers/footers Customisation options and views for worksheets and workbooks The configuration of worksheets and workbooks for distribution to others 
Creation of Charts and Objects Creating charts Formatting charts Inserting and formatting objects
Managing Data Cells and Ranges Insert data in cells and ranges Formatting cells and ranges Summarise data with conditional formatting Summarise and organize data 
Creation of Tables Creation and management of tables Management of table styles and options Filtering and sorting tables
Performing Operations with Formulas and Functions Summarise data by using functions Using conditional operation functions: IF and COUNTIF functions Using conditional operation functions: SUMIF and AVERAGEIF Formatting and modifying text by using functions Combining text using functions and flash fill
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.

AMP Information Systems Limited

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Excel Essentials

More events from AMP Information Systems

Discover more events from AMP Information Systems, from Business to other experiences you might love.

Excel Essentials

More events from AMP Information Systems

Discover more events from AMP Information Systems, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.