Excel is a spreadsheet application packaged with the Microsoft Office suite. It is a very powerful and flexible tool for organising and analysing data. Excel’s functionality and popularity have made it an essential component on computers in countless organisations, businesses, and other institutions throughout the world.

Excel is comprehensive enough to meet the needs of beginners and experienced users. With Excel you can do a wide range of tasks, from building basic spread sheets, to performing advanced data analysis. If you start at the beginning and work your way up, it won’t be difficult to learn and work with Excel at any level you want.

Because of its layout and widespread availability, it is often used as a tool to create and maintain a list. More seasoned users use it to store database records, create charts or graphs. A lot of organisations use Excel to manage their budgets, business planning, customer records, business intelligence, analysis of sales data, customer data, performance dashboard, etc.

Outcomes

This course is intended for current Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks. Upon completion of this course, students should be able to use advanced techniques to manage, manipulate and analyse complete data.

BRIEF REVISION OF EXCEL FOUNDATIONS
• Basic formulae
• Conditional Formatting
• Hiding & Displaying
CHARTS
• Secondary Axis
• Chart Tools

FORMULAS & FUNCTIONS
• Creating/copying formulas
• Relative/Absolute cell referencing
• Using Insert Function button
• Using nested functions
• Using TODAY /DAY/MONTH/YEAR/NOW
• Using SUMIF/RANDBETWEEN
• Using COUNT/MAX/MIN/AVERAGE
• Using CONCATENATE/TRIM
• Using VLOOKUP
• Using IF

MANIPULATING DATA
• Inserting/Deleting rows & columns
• Resizing rows & columns
• Freeze panes
• Inserting Comments
• Printing comments
• Using the Series function
• Creating Custom Lists
• Creating a chart with a secondary axis

NAMED RANGES
• Naming a range or cell
• Rules for naming cells and ranges
• Named ranges within formula
• Creating named ranges automatically based
on cell values
• Deleting named cells/ranges
• Filters & Lists

DATABASE & LIST MANAGEMENT
• Sorting data by multiple columns
• Creating/removing Subtotals
• Using Auto-filter
• Using Advanced filter

Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.

  • 1-day workshop or customise a program to suit your organisation’s specific needs.

Company specific courses are available for organisations that have a group of employees who need training. These closed courses are ideal where tailoring of the standard course content is required. They typically provide cost benefits, particularly where 3 or more workshops are scheduled.

  • Comprehensive Learning Guide
WHAT ARE CLIENTS ARE SAYING