mos

  1. J

    Returning Calculations based on a search function?

    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...
  2. N

    MOS - worth it?

    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...
  3. M

    How to Integrate Client Data

    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...
  4. J

    VBA to autofill range of cell, part of formula is concatenated string from referenced range

    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...
  5. R

    MOS Excel (specialist) 40% in Function and formulas. WHY?!

    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?
  6. B

    MOS Certification Specialist vs Expert

    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...
  7. H

    MOS 2013 quesiton

    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...
  8. K

    [MOS] Microsoft Office Specialts Exam 77-420: Excel 2013 Help!!

    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...
  9. R

    MOS certification test

    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...
  10. P

    Microsoft Office Certification

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top