MICROSOFT EXCEL 2016/2019:
INTRODUCTION

APPLY NOW

OVERVIEW

MS Excel 2016/2019: Introduction In the course MS Excel 2016/2019: Introduction, you will familiarise yourself with the Excel 2016/2019 environment and its documents and you will learn to control them. You will learn in each lesson to create tables step by step. You will find out how to enter values correctly into the cells and how to set the cell formatting, including conditional formatting. You will learn to manipulate each cell and cell range; you will learn to work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas.

REQUIREMENTS

  • Individuals who have no experience of the basics of Microsoft Excel and needs to understand how to use the software from beginning.
  • This course will help you start from scratch to support the beginner on their Information Technology journey
  • You can upgrade from the beginners’ course on conclusion to intermediate and advanced (see other courses to consider under the progression section).

CONTENT

INDICATIVE CONTENT

  • Introduction to the practical use of Excel
  • Excel window
  • Ribbon
  • Excel workbook
  • Creation and saving of a workbook
  • Opening an existing workbook
  • Manipulating worksheets
  • Navigation within a worksheet
  • Cell range selection methods
  • Adjusting rows and columns
  • Data entry into cells
  • Numeric values in cells
  • Moving and copying cell values
  • Copying and moving using the Clipboard
  • Font formatting
  • Alignment of data in cells
  • Borders and fill
  • Basic number formats
  • Date, time and percentage number formats
  • Cell styles
  • Copying formatting
  • Excel table
  • Conditional formatting
  • Basic formulas
  • AutoSum
  • Number and date fill series
  • Text series and custom lists
  • Sorting
  • Recommended charts
  • Instant data analysis
  • Pictures in Excel
  • Printing
  • Customisation of the program settings
  • Getting help with Excel.

METHOD OF DELIVERY/DURATION

  • Online and Customised for Organisations

CERTIFICATION

Personalised Certificate of Completion or option to complete QQI accredited course at level 3, 4, 5 and 6, ECDL, MOS

ASSESSMENT

  • Online assessment

COST

€29.95 for one single module. Check out the great deals on completing more than one course.

PROGRESSION

This course is for beginners as an introductory course on Excel 2016.

There is the option to purchase:

Our people now understand where they fit in the whole process. We see this course as the cornerstone of people development and the certification was key to having a recognized qualification that fits into the framework of Training & Education in Ireland.

Maeve Kieran, Training Manager, Arc Royal Int

Our experience with Midas has been excellent – they were excellent in delivery and accommodated us with dates that suited us here for all employees.

Patrick Kevin, Gibney Steel Products Ltd

Mari is an extremely talented Career Coach and I won’t fail to mention MIDAS Coaching when I am asked how I figured out my career path. I have highly recommended MIDAS to many of my friends. I wouldn’t have been able to figure out my calling without their help, support and guidance which was given to me in abundance

Cliona McGowan

The course has benefited me on a personal and professional level – I now believe in myself and my business

Deverla McGee, Discovery Zone

The course has given back more that I could have every expected

Mary Morgan, Personal and Professional Development

The trainer was very approachable, and I felt relaxed. They provided lots of new information which will help me in my role as a trainer

Frances Loughran – Cert in Training & Development

We have availed of the services of MIDAS to deliver training programmes to a range of our employees. The service provided was to a very high standard and I would have not hesitation in recommending them to others

Tanya Clarke, HR Manager, Wellman Int

The Partnership with MIDAS has enabled us as a company to develop our leaders in-house allowing for succession planning and creating a career path from employee to teams lead

Maeve Kieran, Training Manager Arc Royal

MIDAS Learning customised, revised and added to the proposed programme, so that it over-delivered on our expectations. In addition, MIDAS Learning showed flexibility and creativity in their delivery style and methodology often undertaking a range of one to one sessions with individuals as needed. The team of trainers were professional and committed to the learners.

Deirdre Massey, Community Worker, South Dublin City Partnership

The MIDAS Coach also helped me to develop my career plan further and I have since gone on to complete other qualifications in training and education. MIDAS helped me in transitioning to a career that I love, and I highly recommend MIDAS as a Coaching and Training Provider

Jennifer Smith, Coaching

MIDAS Learning delivered the personal and profession development and coaching element of the Discovery Zone Programme. The outstanding results achieved to date by the programme, have been due, in no small measure, to the excellent & professional work of Mari, who has at all times 'gone beyond the call of duty ' in her work with the participants. Indeed, many participants have referred to their experience with MIDAS as life -changing.

Sean McEntee, Manager, Regional DkIT, Discovery Zone Course, Entrepreneurial Course

My experience with MIDAS Learning has been very beneficial to me. As an uncertified but experienced trainer, I found their training courses extremely engaging with plenty of interaction and feedback

Ciaran Reilly – Cert in Training & Development

Through the Certificate in Training and Development, I was able to formalize skills and techniques that I already used and learned how to train more effectively. The course was presented in lots of different ways and were very informative which kept the training interesting. There were lots of handouts and documentation provided, the course was tailored to suit and the assessments were very professional. All learners had great support from the Tutor and MIDAS Learning - I would highly recommend them.

Esme, Lead Trainer, Arc Royal

After one coaching session, I started to believe in myself again. She peeled back the layers and I liked what I saw. One of my Eureka moments! Mari helped me to clear the mist and see the shoreline. I'd still be sailing through the mist without her influence.

Robbie Richardson, Manager, Customer Focus, Customer Service Solutions

I got a better understanding of myself after doing the course. I realized where my strengths lay – I became more assertive and my self-confidence improved. I was able to go for the job that I had dreams about and was successful in getting it

Dave Gilbride, Participant, Cert in Team Leadership

MIDAS helped me collate an incredible CV that I was proud of, taught me how to complete and adapt the application form and helped me prepare for my interview, which I got. When I was going for additional promotions, I went back for a refresher. Best money ever spent

Nicole O’Brien

The Tutor was extremely helpful and explained everything in a clear and easy way

Tim Davis, Book-keeping and PayrolBook-keeping and Payroll

As a person who took the decision to re-enter education as a mature student, I don’t think I could have picked a better course to attend. I was very apprehensive about taking on the QQI Special Purpose Certificate in Training and Development. From the outset the tutor made me, and the rest of our group feel at ease. If I had anticipated the level of support from Mari and her team, I would have enrolled for this course a long time ago.

Gerard SmythCertificate in Training and Development

Clearly delivered in a relaxed and professional environment

Linda BradyReception and Administration Skills 2 in 1 course

I learned a new way to interact and communicate. Good course, well thought out and good delivery system

Ivan McQuaidTeamworking and Personal & Professional development

Before coming to MIDAS and engaging in the course, I hadn’t worked in 8 years, and I had given up on the idea of ever working again. I had a family but felt stuck on Social Welfare as I had a disability. MIDAS gave me the motivation and helped build up my confidence, they also gave me the direction I needed to focus on my career again. I am just finishing a level 8 course in Addiction Studies in Maynooth University. I’ve great hope back in my life and I can’t thank MIDAS Learning enough

James O’NeillCert in Employability Skills

The most important aspect of the programme was the invaluable insight provided by the career coach through exercises, tests and advice. The work that we did on the course is essential to all of us.

Gerard ReillyUnlocking Potential Training Programme

The tutor was excellent in her delivery of the course and the pace she went, as our employees were all at different levels in EXCEL.

Patrick Kevin - Gibney Steel Products, Co Meath

No jargon, very well structured and thought out

Kathleen TuiteEntrepreneurial Skills

I learned a new way to communicate and interact with additional needs of children and adults. Good course. Well thought out and good delivery system.

Ivan McQuaid – Lámh

As a consequence of the training, we do not have to buy in team leads any more- there is a pool of competent people ready for progression both in the production and training department that supports the quality and regulatory side of the business.

Maeve Kieran, Training Manager, Arc Royal Int

I contacted MIDAS when I was applying for a promotion at work to help me with my interview skills. I spoke to a coach, and she got me to undertake a psychometric test focusing on work. The follow-on sessions were fabulous. The report got me to recognize my competencies and gave me the confidence to acknowledge the skills I had innately and as a consequence of my experience.

Nicole O’Brien

I was very nervous when it came to interviews and couldn’t seem to get promoted even though I was qualified for the job. When I went to MIDAS, they brought me back to basics and addressed some of the issues on the CV and updated it as part of the process. They also helped me define why I was the right person for the job by highlighting and shing a torch on my competencies and capabilities

Cliona McGowan

have attended courses in the past where it felt like a tick box exercise, but not with MIDAS. I enrolled for the course with no clear vision of what I wanted and came away with a recognised qualification and launched my own business carrickspringanconsultancyservices.com. Attending the course and receiving a distinction in both modules has been a life changing experience and I would highly recommend doing this course with MIDAS.

Gerard SmythCertificate in Training and Development

Having spent almost two decades working in the hospitality industry, I wanted to further my career path. I came to MIDAS for career coaching and completed my QQI Special Purpose in Training and Development. As part of this, the trainer worked with me to design and develop a course specific to my industry experience which meant that I could train others in my area of expertise.

Jennifer SmithCertificate in Training and Development

The Tutor made the course very enjoyable and comfortable and if they did not understand something, she was extremely willing to explain further. We would be delighted to recommend MIDAS Learning in the future.

Dave GilbrideCert in Training and Development

ENROL FOR THIS COURSE

APPLY NOW