Excel Introduction
£300
About this course
For Versions: Excel 2013, 2016, 2019 and Office365
Prerequisites: No previous experience of using Excel is required, however attendees should be familiar with using a Keyboard and Mouse.
Excel Environment
Exploring Excel 2016 Ribbons Working with the Excel layout Introducing the Excel Sheet and tools
Working with Ranges
Working with ranges Selecting ranges with the keyboard and mouse Entering values into a range Copying/cutting and pasting data Using the AutoFill feature Filling cells
Using Formulas
Entering formulas Using the SUM function Using MAX, MIN, AVERAGE and COUNT functions Creating an absolute cell reference Copying and Moving Data Working with Quick Analysis
Sorting and Filtering
Sorting data alphabetically and numerically Creating a Custom Sort Filtering Data Applying a Custom Filter
Formatting Cells/Numbers
Applying Currency, Date, % and Number Formatting Applying Cell colours Adjust Row/Column height and width Add, Delete and Adjust Rows/Columns
Printing
Setting Print Areas Repeating Print Heading Headers/Footers
Charting
Creating a default Column Chart Changing the Chart type Customising chart colours and fonts
Sparklines
What is a Sparkline? Creating Sparklines Changing Sparkline type Customising the Sparkline
I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Syllabus
Week 1 0/5
Useful Expressions
Tools for Professional Approach: It’s not just about learning, it’s about having the confidence to use English in real life and upgrade your business communication skills.
Week 2 0/4
Diplomatic Language
Tools for Professional Approach - Step 2: It’s not just about learning, it’s about having the confidence to use English in real life and upgrade your business communication skills.
Reviews
Lorem Ipsn gravida nibh vel velit auctor aliquet. Aenean sollicitudin, lorem quis bibendum auci elit consequat ipsutis sem nibh id elit. Duis sed odio sit amet nibh vulputate cursus a sit amet mauris. Morbi accumsan ipsum velit. Nam nec tellus a odio tincidunt auctor a ornare odio. Sed non mauris vitae erat consequat auctor eu in elit.