Midas Group

Microsoft Excel

 

Overview:

Microsoft Office Excel is aimed at people who want to improve their knowledge of features and their productivity in whatever job role they have.  Job roles such as accountants, clerical or office professionals, consultants, executives/managers as well as help desk personnel and instructors/trainers would benefit greatly by taking this course.  The concepts taught will enable you to create and understand complex formulae, produce models to determine specific required end results, create, edit and print high quality charts and be able to competently use a range of filtering and sorting options to reduce the size of large lists based on specific criteria.

 

As more and more employers begin looking for verification of employee software skills, there is no better way to stand out from the crowd than to show your credentials as a specialist in the software.

 

If you are hoping to gain employment, or wishing to change jobs, you will have the confidence of knowing that they you can use the software to a very high level which in turn improves your chances of finding your dream job. 

Course Content:

The topics covered include:

 

  • Navigate through a worksheet
  • Print a worksheet or workbook
  • Personalize environment by using Backstage
  • Creating complicated formulae
  • Apply conditional logic in a formula
  • Apply cell ranges in formulas
  • Apply AutoFill
  • Create charts based on worksheet data
  • Apply Sparklines
  • Share spreadsheets
  • Sorting, filtering and using conditional formatting
  • Apply and manipulate hyperlinks
  • Formatting Cell and Worksheets
  • Create row and column titles
  • Hide and unhide rows and columns
  • Manipulate Page Setup options for worksheets
  • Protecting ranges, worksheet and workbooks
Book Online:

€195.00 Add to cart

ACCREDITED BY
FOLLOW US ON