Home » Courses » Office Productivity » Microsoft Excel Courses » Advanced Excel Course – beyond the basics

Advanced Excel Course

This Advanced Excel Course runs from our Dublin Training Centre

This Advanced Excel Course will supercharge your Microsoft Excel Skills to the next level. You'll learn how to be an expert at Functions, Formulas, Pivot Tables, PowerPivot and lots more

g

Intermediate

2 Day Classroom Course

Certification Awarded

Includes Free Online Course

Skills You will have at the end of the Course

  • Protect workbooks and worksheets
  • Filter and subtotal lists
  • Work with V/H lookups
  • Analyse data better using Pivot tables
  • Restrict what’s entered into a spreadsheet using validation in a spreadsheet
  • Perform proficient data analysis
  • Create advanced charts
  • Understand more complex spreadsheets
  • Use conditional formatting to highlight key data
  • Share workbooks with other users

Course overview

This course builds on the Excel Foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.

Requirements

Essential to have a good understanding of Excel before attending this course

Certification

At the end of the course, you’ll be Certified by the Irish Academy of Computer Training

Who would benefit

If you work with Excel on a regular day to day basis this is the right course for you. There is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to make the most of Excel and what it has to offer.

Why take the Course

This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have a powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role

Online Option Available

Course curriculum

What's covered
  • Advanced Formatting – custom lists, conditional formatting, custom number formats
  • Transposing lists
  • Autofill
  • Conditional formatting
  • Data validation – creating rules, and drop-down menus
  • Data protection – sheet and workbook protection and locking cells
  • Basic formulas and functions review
  • Name Manager – applying absolute references to cells in formula
  • Order of precedence
  • Sum, Min, Max, Average, Count, Countblank
  • Relative and Absolute referencing
  • Countif and Sumif
  • Countifs and Sumifs
  • IF and nested IF statements
  • Concatenate
  • Vlookup and Hlookup functions in single and multiple worksheets
  • Charting
  • Tables – applying table styles to lists of data
  • Sorting and Subtotaling
  • Advanced sorting and using subtotal filters
  • Pivot table and Pivot charts
  • Named ranges
  • Introduction to Macros, assigning macros to buttons and icons

To get Dates, Pricing & more info please enter your details and we will get back to you.

Or call us on 01 434 7600 

Course Enquiry

  • This field is for validation purposes and should be left unchanged.

*Required info. We treat your data with care, please see our Privacy Policy for more details

IACT - Ireland's leading training provider