About
We offer a wide range of high-quality and affordable training and events to help you develop and succeed at Carrowbreck House - our spacious and comfortable training centre in Hellesdon.
We can also ...
Intermediate Excel
Contact person
Scan me or visit www.getinvolvedskills.org.uk/o/Carrowbreck-Courses/Trainings/Intermediate-Excel/103827 to join
Summary
This course develops many of the features of Microsoft Excel. We will look at the most useful elements, including formulas and functions..Detailed description
using Excel as a database and sharing text and data with other applications. Everything will be explained in straightforward terms. It is also an opportunity to iron out any bad habits that you may have picked up.
Review
Brief review of general Excel principles:
Arithmetic formulas
Looking at +, -, * & /
Brackets
BODMAS
Advanced AutoSum
Unusual ranges
Auto-Average/Max/Min/Count
AutoFill
Building Functions
Using the Paste Function dialog
Basic functions
Functions with one argument:
Statistical functions
Absolutes
When/how to use absolute references
Formulas and Functions between Sheets and Workbooks
Summarising data from multiple sheets
Linking workbooks
Advanced Functions
Functions with more than one argument
e.g. the IF Function
Named Ranges
Naming ranges
Navigating using named ranges
Using named ranges in formulas
Natural language formulas
Excel as a Database
Sorting your data
Filtering a list
Useful database features
Good Working Practice
Copy and Paste
Using the Windows clipboard
Paste-Special :–
Linking to other files and applications.
Replacing formulas with data
The Drawing Tools
Auto shapes
Layers
Rotation
Alignment
Grouping
An explanation of different versions
Equipment: Pen and note paper will be provided.
Lunch provided: For full day training courses a lunch with sandwich or salad, crisps and cake or fruit will be provided. Light refreshments will also be available throughout.
About Carrowbreck Courses
We can also look to offer bespoke training for your business either on-site, at Carrowbreck House or virtually to meet your needs on our whole range of available courses.
Room hire is also available on an hourly, half-day, full-day or multiple-day basis for meetings or training courses.