course-premium

Level 3: Microsoft Excel

4.3
6 reviews
  • Working in a little gathering at a pace which suited every one of us and picking up a decent fundamental information in Excel. Heather ingrains certainty by her quiet way and exhaustive approach, which was exceptionally useful and consoling for an Excel-phob like myself. The instructional pamphlet will be significant and accommodating going ahead, as I can hone the activities to strengthen what we learnt amid the preparation. In spite of the fact that I have utilized Excel for various years, I have never felt extremely certain about my capacity. This course has subdued my nervousness when utilizing Excel .
    |
  • This was a course I requested and was especially anticipating it after Heather trained me on my intermediate course. I was certain it would have been a pleasant affair. I felt delighted in having the association with a specialist educator and appreciated having the capacity to ask any Excel based inquiries I had. I grabbed another profundity of learning with some incredible top tips/alternate ways.
    |
  • I delighted in the greater part of the course, it was conveyed in a way that was straightforward and simple to consider approaches to utilize it in my work. I preferred the way unique methodologies were exhibited to land at a similar outcome relying upon the information accessible and how to utilize a blend of capacities and figurings. Having an enthusiasm for what Excel can accomplish for me helped, however Heather conveyed the course in a way that kept me intrigued and made them think about how I can make Excel function for me.
    |

Course

Inhouse

Price on request

Hone your Microsoft Excel skills and boost your career with The Software Training Company!

  • Type

    Course

  • Methodology

    Inhouse

  • Duration

    2 Days

  • Start date

    Different dates available

Would you like to further develop your knowledge of Excel? This Advanced Microsoft Excel will teach you how to use formulas and spreadsheets in order to benefit from it.

The main goal of this course is to develop topics covered in the previous courses and to introduce more advanced Excel commands and functions. The course will provide the delegates with the opportunity to explore the more sophisticated features and facilities of Excel.

Ask for more information through Emagister's website and an assessor will get in touch with you!

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open

About this course

To develop topics covered in the previous courses and to introduce more advanced Excel commands and functions. The course will provide the delegates with the opportunity to explore the more sophisticated features and facilities of Excel. There is an emphasis on combining features together for practical usage and application.

Regular users with an extremely good working knowledge of Excel who want to develop their knowledge further. Should be able to perform calculations with ease to include adding, subtracting, multiplying and dividing, and be able to use the functions introduced in Levels 1 and 2 without any issues.

Attended the Level 2 Excel course or been using Excel for a long period of time.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Can i have this training on my mac laptop?

Phillippa H., More than two years

Reply

Reply from Centre advisor (More than two years)

Hi Phillippa, yes, you can have your training on your Mac laptop. It would mean you would have to have your training on your own, but this wouldn’t affect the price. Please let me know if you have any more questions. Kind regards Heather Ledbrook

Reviews

4.3
fantastic
  • Working in a little gathering at a pace which suited every one of us and picking up a decent fundamental information in Excel. Heather ingrains certainty by her quiet way and exhaustive approach, which was exceptionally useful and consoling for an Excel-phob like myself. The instructional pamphlet will be significant and accommodating going ahead, as I can hone the activities to strengthen what we learnt amid the preparation. In spite of the fact that I have utilized Excel for various years, I have never felt extremely certain about my capacity. This course has subdued my nervousness when utilizing Excel .
    |
  • This was a course I requested and was especially anticipating it after Heather trained me on my intermediate course. I was certain it would have been a pleasant affair. I felt delighted in having the association with a specialist educator and appreciated having the capacity to ask any Excel based inquiries I had. I grabbed another profundity of learning with some incredible top tips/alternate ways.
    |
  • I delighted in the greater part of the course, it was conveyed in a way that was straightforward and simple to consider approaches to utilize it in my work. I preferred the way unique methodologies were exhibited to land at a similar outcome relying upon the information accessible and how to utilize a blend of capacities and figurings. Having an enthusiasm for what Excel can accomplish for me helped, however Heather conveyed the course in a way that kept me intrigued and made them think about how I can make Excel function for me.
    |
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Former student

4.5
10/09/2016
What I would highlight: Working in a little gathering at a pace which suited every one of us and picking up a decent fundamental information in Excel. Heather ingrains certainty by her quiet way and exhaustive approach, which was exceptionally useful and consoling for an Excel-phob like myself. The instructional pamphlet will be significant and accommodating going ahead, as I can hone the activities to strengthen what we learnt amid the preparation. In spite of the fact that I have utilized Excel for various years, I have never felt extremely certain about my capacity. This course has subdued my nervousness when utilizing Excel .
What could be improved: Nothing.
Would you recommend this course?: Yes

Former student

4.5
10/08/2016
What I would highlight: This was a course I requested and was especially anticipating it after Heather trained me on my intermediate course. I was certain it would have been a pleasant affair. I felt delighted in having the association with a specialist educator and appreciated having the capacity to ask any Excel based inquiries I had. I grabbed another profundity of learning with some incredible top tips/alternate ways.
What could be improved: Everything was positive.
Would you recommend this course?: Yes

Former student

4.0
10/06/2016
What I would highlight: I delighted in the greater part of the course, it was conveyed in a way that was straightforward and simple to consider approaches to utilize it in my work. I preferred the way unique methodologies were exhibited to land at a similar outcome relying upon the information accessible and how to utilize a blend of capacities and figurings. Having an enthusiasm for what Excel can accomplish for me helped, however Heather conveyed the course in a way that kept me intrigued and made them think about how I can make Excel function for me.
What could be improved: N/A.
Would you recommend this course?: Yes

Bruce .

5.0
08/06/2016
What I would highlight: The training was amazing. I was very surprised that even in the lessons that went over Excel features that I use every day, that there was features that I didn't know about, but found extremely useful. I must say I really enjoyed the training, and everything I learned will make work a lot easier now when it comes to mastering Excel, which I need in my everyday life. Thanks!
Would you recommend this course?: Yes

B.

3.5
10/04/2016
What I would highlight: Fantastic course and incredible conveyance. Heather truly comprehend every student and their level of Excel learning. I feel that my abilities have been improved through this preparation and this will unquestionably help me in my part for KPI's, details and reporting. I would surely prescribe this course and teacher.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Robert

4.0
10/04/2016
What I would highlight: I have been utilizing Excel for more than 10 years (self trained). Prior to the course I could discover my way around and work out methods for getting things done, however they were not generally the best or snappiest methods for working and I would put in hours instead of minutes creating and incorporating spreadsheets/exercise manuals. Heather's instructional strategies were great and pitched at precisely the correct level. I have taken in a great deal and I am presently significantly more proficient and certain when working with Excel. I am certain that I will have the capacity to work much speedier and all the more productively on account of Heather's intensive and compact preparing.
What could be improved: Nothing bad.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

Subjects

  • Excel
  • Microsoft Excel
  • Database
  • 3D
  • Microsoft excel training
  • MS Excel
  • Chart analysis
  • Spreadsheets
  • Style template design
  • Macros
  • Templates
  • Worksheets
  • AutoFilter
  • Toolbars

Course programme

Working with Worksheets and Workbooks• Revising working with worksheets• Hiding and displaying worksheets• Displaying worksheets in separate windows• Arranging multiple workbooks on the screen• Moving and copying worksheets into other workbooks
Performing Calculations Across Worksheets• Revising performing calculations across worksheets• Inserting extra worksheets and updating calculations• Entering and editing 3D functions• 3D SUM, AVERAGE, MAX, MIN and COUNT functions
Formulae and Functions• Mixed absolute and relative references• Calculating percentages• Summing non-adjacent ranges• Integer and round functions• Lookup functions• IF function with multiple conditions• Using the AND and OR functions with IF• Combing IF and VLOOKUP• INDEX and MATCH versus VLOOKUP• Hiding errors
Templates• Creating, modifying and using templates• Inserting sheet templates• Modifying the default settings of new workbooks
Protecting Worksheets and Workbooks• Locking and unlocking cells• Protecting and unprotecting worksheets• Protecting a workbook• Saving a file with a password
Working with Tables• Guidelines for creating a table• Making and naming a table• Filtering data in a table with a slicer• Converting a table to normal data• Using a named table in calculations
Linking Workbooks• Paste and reference linking workbooks• Opening dependent and source workbooks• Updating data when workbooks are linked• Modifying links• Performing calculations across workbooks
Naming Cells and Ranges• Naming a cell or a range• Jumping to locations using range names• Using range names in a formula or function• Book level and sheet level names

Level 3: Microsoft Excel

Price on request