MO-201 Excel Expert Exam Review 1-2 Practice Tasks (2/2)
HTML-код
- Опубликовано: 28 авг 2024
- Pass the new 2019 Excel Expert Exam with this review of the practice tasks & Excel tips covering the Microsoft Exam # MO-201 Microsoft Excel Expert (v2019) Study Guide.
Objective 1-2 ‘Prepare Workbooks for Collaboration’.
This video walks through the following practice tasks:
- Confirm Automatic Calculations (@ 0:21);
- Circular Reference Notification (@ 0:59);
- Set Calculations to Manual (@ 2:48);
- Enable Iterative Calculations (@ 3:17);
- Manually Calculate Workbook (@ 3:58);
- Threaded Comment Introduction (@ 5:53);
- Add a Comment (@ 7:05);
- Show existing Comments (@ 8:18);
- Next or Previous Comment (@ 8:40);
- Edit existing Comment (@ 9:16);
- Reply to a Comment (@ 9:40);
- Resolve a Comment (@ 11:10);
- Delete Comment Thread (@ 11:40); and,
- Add a Legacy Comment (now a ‘Note’) (@ 11:58).
Order the textbook and/or download the practice files here:
www.microsoftp...
www.carshaltonadvisory.com
getstarted@carshaltonadvisory.com
MO-201 77-728 mos microsoft office excel 2016 2019 expert M0-201
Thanks a lot. You are really a MASTER.
Thank you @CarshaltonAdvisory for posting this video series and content for Excel exam prep.
Do you have a 1-3 video? Only a few topics regarding language configure options, but I'm unfamiliar with them.
I"m taking the 200 and 201 exams in a few months and have found your videos very helpful.
Thanks!
Great content! Many things are still valid for MO-211.
Good to hear. Taking mine this Friday.
Hi, thank you for the videos thus far. Are you going to post the other module videos (objective 2,3,4)?
I should be able to add 2 or 3 videos per week... so it'll take a bit of time, but I'll get them all done ;-)
If the comments are now called notes, then why does it still say comments(new comment,show comments) in the ribbon?
The old 'comments' are now called 'notes'. Now 'comments' are the threaded ones that can be displayed in the sidebar and is what is shown in the ribbon. The precedent-style comments haven't been removed, just re-named.
You are overusing shortcuts and it’s kind of being subjective. Could have been avoided a bit in the video.
Way too many shortcuts, but otherwise helpful.