Thanks for completing the MS Excel Skills Assessment (if you’ve come here straight from a search engine you need to go to the free MS Excel Skills Assessment page to get started). In a few minutes you will receive an email with your detailed results and a link to your report (check you junk mail as well). If you don’t receive anything in 5 minutes please email info@AuditExcel.co.za and we will send it to you.
You can click on the link to get the detailed report and our recommendations. If the link is not clickable, copy the URL into your internet navigation software.
While you wait for your Excel Skills Assessment
Some quick trick in Excel while you wait
View 2 sheets from the SAME spreadsheet side by side
Not 2 different spreadsheets, but sheets from within the SAME spreadsheet. You can change either one and there will be no merge issues!
Open a spreadsheet with 2 sheets you want to look at at the same time
- Click on the VIEW ribbon
- Click NEW WINDOW (it looks like a new spreadsheet opens but it is the same spreadsheet)
- Click the VIEW ribbon again and choose ARRANGE ALL and then Vertical (to put them side by side)
- Click on the sheets you want to compare and feel free to make changes to either sheet
See the full video clip with more detailed explanations in the Free Excel tips and tricks course.
See sheet names portrait style
Tired of searching for the correct sheet left to right? Look for the correct sheet top to bottom
Email still not arrived?
Still waiting (have you checked your junk mail)? Request more information on the live courses we offer with the button below. Alternatively have a look at the online courses we offer.