Tel:020 7920 9500
Microsoft Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction..
For more demanding uses, Excel can be used to create charts, Analyse Data, used as a data repository and of course keep track of your accounts.
Benefit From our Smart Training
Excel Introduction Training Course Overview
Our Excel Introduction Training Course ideal for complete novices or those who have basic knowledge of Microsoft Excel. Taking this course will provide you with the skills you need to work quickly and produce functional and well-formatted spreadsheets.
Delegates will leave feeling confident about creating professional worksheets with Excel and be able to navigate the interface intuitively and enhance their productively.
Excel Introduction Training Course Five Core Topics
- Create new worksheets
- Format text and numbers
- Create Excel formulas
- Sort and Filter data
- Present data visually using Excel Charts and Sparklines
Excel Introduction Training Course Details
Course Location : Face to face group / Online & Onsite training available.
Class Size : As a guide we recommend class sizes to be no more than six.
Virtual / Online training Format : Teams or Zoom.
Tailored Course Content : Our Excel Introduction Training Course can be tailored to your requirements
Tailored Courses : We offer a free consultancy service to help tailor the course to meet your requirements.
- Starting and exiting from Excel
- Using the Excel ribbon
- Displaying Help information
- Using and creating Custom Lists
- Using the Fill Handle and Drag and Drop
- Creating and opening workbooks
- Adding data to a worksheet
- Selecting ranges of cells
- Entering worksheet data
- Saving a workbook
- Using the Spell Checker
- Adjusting column widths
- Inserting and deleting a range of cells
- Copy, move and delete cell entries
- Find and Replace specific entries in a worksheet
- Inserting and renaming sheet tabs
- Changing the font style, size and colour
- Adding alignment options, wrap text, orientation and merge cells
- Applying borders and patterns
- Adjusting row height and column widths
- Changing the number format of cell entries
- Using Styles for consistent formatting
- Conditional formatting; icon sets and rules
- Creating basic formulas
- Brackets and the order of calculation
- Excel functions
- The SUM, AVERAGE, MAX, MIN, COUNT and COUNTA functions
- Using the AutoSum tool
- Copying formulas with AutoFill
- Absolute and relative references
- Previewing a worksheet
- Changing the Page setup of a worksheet
- Setting the print area
- Printing certain rows or columns on each page
- Printing selected worksheet entries
- Using Recommended Charts
- Adding new data to an existing chart
- Including multiple data ranges in a chart
- Understanding the different chart types
- Creating Sparklines
- Conditional Formatting : Data Bars, Colour Scales and Icon sets
- Splitting the workbook window into panes by freezing panes
- Hiding rows and columns
- Changing the zoom level for a worksheet
- Sorting and filtering worksheet data
Services
Online or Your Venue
Unlimited access to out online training manuals
Courses delivered by Certified Trainers
Our Trainers
our lead trainers, have many years of delivering training courses from basics to development levels in their chosen field . All our trainers are encouraged to become Microsoft Accredited within their first year of working for us.
Our instructors are very approachable, making the driest subject matter fun.
