Join us for this free 1 day course on Excel.
Course Content:-
What we will learn:
Review of Excel Formulas
Accurately enter an Excel formula
Review Basic Excel Functions
Accurately enter SUM, MIN, MAX, AVERAGE, COUNTA and TODAY functions
Absolute References
Accurately enter a formula that uses absolute references
Paste Special
Instantly swap rows and columns of data around
Link cells into other sheets accurately
Paste only the values from cells to remove a formula
The IF Function
Construct IF function correctly to enter data into cells based on the result of a test
Conditional Formatting
Analyse data by applying conditional formatting based
on criteria e.g.: colour red cells with numbers greater
than 100
Using Quick Analysis to apply Conditional Formatting.*
Using Flash Fill*
How get Excel to automatically fill columns with
“patterns” of data
Examples of using Flash fill
Introduction to the VLOOKUP Function
Correctly construct the VLOOKUP function to find data
based on a lookup value
Using VLOOKUP to find values in an Excel Table Using Quick Analysis
Entering formulas using the Quick Analysis feature
Creating Charts
How to insert a chart to show your data accurately
Modifying a chart
Work with different charts
Using Quick Analysis to create charts.*
Printing Techniques
Work with Page Layout View
Print Titles so that your data headings repeat on new pages
Control the printing of Headers and Footers
Using an Excel Table
Use Table Styles to format substantial amounts of data for readability
Use Table Styles to analyse data
Using Quick Analysis to format as a Table
Using Slicers in an Excel Table*
Inserting Slicers
Using Slicers to filter data in an Excel Table
Customising Slicers
Sorting and Filtering Data
Sort data into alphabetical or numeric order
Use Custom Sorting to sort to more than one level
Filter data to show only the data you want to see
Creating Subtotals
Create subtotals on sorted data
Use an Outline to analyse Subtotals
Date: 15th November 23
Venue: Brecon
Time: 9.30am - 4.30pm
Cost: Free
Booking is essential as places are limited. To reserve your place please book below.