mos

Hello All, thanks in advance for your help! This may be an easier task than I'm making it out to be , but here's my predicament.... I have sheet1 where I am interested in making calculations over several months for instance: <tbody> Account Name # of 3 over 3 mos # 3 over 5 mos Happy...

Hi, I am curious whether the MS MOS certification is worth exploring. I am an accountant that does a lot of work with Excel and is in particular branching into PowerBI etc. I have not had any formal training per se and was wondering if it would be worth pursuing training in either the MOS and...

Hi, I am trying to integrate this, I have 1 client with their latest appointment on 1 row. How would I do this? <tbody> A B C D DOE, JOHN 02/14/2018 3 mos. 01/01/2018 DOE, JOHN 02/14/2018 3 mos. 05/01/2018 DOE, JOHN 02/14/2018 3 mos. 03/21/2018 A B C D DOE, JOHN...

I have a workbook that I use each month, each year and I have to do a number of different things to it in order to ready it for the next month's use. I'm trying to get the workbook to take care of itself, so to speak. This is one of the steps I'm trying to automate. I have 6 tabs within the...

Hi guys. Im here looking for a solution of a problem im triying to solve: in the Mos Excel 2013 im reaching 40% in function and formulas section and i dont know why :( And i am wondering: Which one is the best/proper way of using the functions?

Hi All, I have a general question regarding which certification should I take. Currently I'm unemployed and looking for a job as a Business Systems Analyst or similar title. I was thinking that I should show some certification on my resume and Excel (also Word) came to mind. First of...

Hello, I have this question MOS 2013 exam (I have Excel 2013): fill all cells in the column that contain values of more than $100 with bright yellow. My problem is the following: if i set conditional formatting like: Cell Value > 100, then it works but the first cell will be also yellow (the...

Hi everyone, Today i gave my MOS Exam 77-420 : Excel 2013. i scored 980/1000. overall the exam was easy. i got 100% in all objectives except 90% in 'Applying Formulas & Functions'. I know where i did wrong. But i still can't figure out how to solve that problem because of which i couldn't score...

Hello, I am going to be taking the MOS certification test for excel. Just curious if there is any one here who has taken the test (2010 test 77-882 (U.S.)) has any pointers for preparing for said test? Also, any suggestions on the best (and most affordable) way to purchace the test...

Hi, I am after some advice from all you lovely guru's. I am thinking of studying for the Microsoft Office Specialist (MOS) certification (formally known as MOUS). I have been using Office for the last 10 years and have developed some excellent skills, particularly in Excel. Does anyone know...