Level 3: Microsoft Excel
-
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
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
Start date
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.
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 rating
Recommended
Centre rating
Former student
Former student
Former student
Bruce .
B.
Robert
Subjects
- Excel
- Microsoft Excel
- Database
- 3D
- Microsoft excel training
- MS Excel
- Chart analysis
- Spreadsheets
- Style template design
- Macros
- Templates
- Worksheets
- AutoFilter
- Toolbars
Course programme
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