Create a status bar in Excel with formulas!
HTML-код
- Опубликовано: 2 июн 2024
- You can do a lot with conditional formatting, but did you know you can create a growing status bar with it as well. In this video, we'll go over two ways that you can you conditional formatting formulas to enhance the look of your worksheets!
Do you know where to purchase practice tests for the Excel Expert (mo-211) Exam?
Hi, I have a question about the test. When we take the test, does it let us open Insert Function Dialogue box? Or do we have to type out all the functions? I used GMX, I really don't like it because it isn't real Excel . I feel like it's similar to a game :). Is the real test similar to the GMX stimulation test or more real Excel?
Hi sir mike , can u plz provide a final mock test prep of mos certification
Hi Mike! Could you please provide additional Word Expert 2016 tutorial videos?
Yeah for sure! In the meantime. If you check out the 2019 ones, they are pretty similar to the 2016 exam
@@MikesOffice Thank you. I will watch the expert 2019 videos and wait for more expert 2016 videos from the channel
can you do a access certification test?
To be honest, I won’t be doing that one. With Excel building more into their power query, not many places use Access any more.
Hello There! i want one excel Formula > how to calculate OT1, OT2, Regular hour in excel. if hours fall between 00:00 to 05:00 it is OT2 , if hours fall between 05:00 to 8:30 it is OT1, if hours fall between 8:30 to 18:00 it is regular hour, if hours fall between18:00 to 21:00 it is OT1, if hours fall between 21:00 to 24:00 is OT2. For example if employee starts work at 02:00 and ends at 22:00 then total working hour will be 20:00, Regular Hour will be 09:30, OT1 will 06:30 , OT2 will be 04:00. (OT=OVERTIME)
Why doesn't your RUclips channel have any new videos?
I’m not a full time RUclipsr. But you’re right I should try and upload new stuff.
Thanks! ❤
First comment