4 questions in one post

[N0t Y0urs]

1. I have noticed that your website doesn't always load. I have tried power cycling all devices as I have tried accessing it on phone, table, laptop and iMac with no success. Leave it 18 - 24 hours I can get back in? Any thoughts
2. I am using excel Excel 365 on mac and store the files in my Google drive. If I have created a file on my phone (and it isn't Google sheets it is excel) and I am using standard formulas for example sumif when I open the file on my iMac I am getting errors in my formulas
3. Is there a way to trigger the array function from a device because pressing Control+Shift+Enter is not an option when you technically don't get the keyboard
4. Do you have courses to help take people with knowledge to expert users?

Thanks

 

[Joe4]

Generally, I think it is better to keep separate, unrelated questions in different posts.
If you post them individually, I think you will get more responses.
The danger of posting 4 different questions in one post is that many people will not reply at all if they don't think they can answer all 4 of your questions.

I will address questions 1 and 4.

1. Occassionally (especially on weekends), there may be an update that briefly affects the website loading, but typically, the website loads pretty fast without issues (I have noticed a few brief glitches the past week, but they did not seem to last very long). If it is something that you are constantly experiencing, it may be something on your end (connection, browser, security settings/software, etc).

4. MrExcel doesn't really have "courses" (Bill does do seminars for hire, though), but MrExcel has published a number of books (hardcopy and online) that can help you with that, depending on what it is you are looking for. See: Products

For your other two questions, I would recommend posting them individually to the "Excel Questions" forum (Excel Questions).
Be sure to include detailed information (i.e. post the formulas that are returning errors, etc).

 

[N0t Y0urs]

Thanks, I gave up on the errors and went the long way round so sorted it myself. I have most of the books and just thought maybe there was a course option. I think I just need to challenge myself and sit back and plan the spreadsheet first before jumping in.

Thanks anyway

 

[Joe4]

Thanks, I gave up on the errors and went the long way round so sorted it myself. I have most of the books and just thought maybe there was a course option. I think I just need to challenge myself and sit back and plan the spreadsheet first before jumping in.

Thanks anyway

If in interests you, there are various of online tutorials/courses that may interest you that you can find with a Google Search.