What is Advanced Excel, Unhide rows not working, Excel not recognizing duplicates
In this issue:
- Next Advanced Excel course dates 9-13 Nov
- Beginner Excel Course Dates- Next 16 Nov 2015 (NEW)
- Cleaning up Data using Excel
- In houses Courses
- What does an Advanced Excel user need to know?
- How to use our new online courses
- Unhide rows not working in Excel?
- Excel Skills Transfer
- Excel not recognizing the duplicates
- What type of Excel training is best?
Cleaning up Data in Excel
We have recently launched our new online course covering cleaning up data in Excel. Taking material out of the live 3 day course we have specifically targeted this course at people who regularly receive spreadsheets from different systems and need to rework it.
Areas covered in the course include
- Remove unnecessary rows
- Fill in gaps
- Convert text to numbers
- Correct dates
- Identify and remove duplicates
- Split columns in Excel
Next Excel Courses
- Advanced Excel course (9-13 Nov 2015)
- Excel Financial Modeling, Budgets and Forecasts (12-13 Nov 2015)
- In House course- whenever it is convenient for you
- Excel Fundamentals for beginners
- 16 Nov 2015 (NEW)
- 12 Feb 2016
Email us if you need more details or visit the calendar page
Unhide rows not working in Excel
Have you tried to unhide rows in Excel and it refuses? This could be as a result of a number of reasons. Read more
What is an Advanced Excel user?
In Excel it is very difficult to identify the abilities of an Advanced User. Do you need to know VBA and array formulas? Read more on our understanding of an Advanced Excel user Read more
Excel not recognizing duplicates
Excel is seldom wrong. So if it says there are no duplicates, then there are no duplicates. But the reasons for this may be difficult for a human to see. Read more
Pro and Cons of Public, ON Site and Online Excel Training
The pros and cons of learning Excel in a public course, onsite course or online course Read More
How to use the new online courses
Instructions on how to use the new online Excel training course. We will be launching modules of the live courses over the next few months. Read More
Excel Skills Assessment
Did you know that our Excel Skills Assessment is now being used by overseas companies to assess their entire workforce? Read More