This site uses cookies to improve your experience. To help us insure we adhere to various privacy regulations, please select your country/region of residence. If you do not select a country, we will assume you are from the United States. Select your Cookie Settings or view our Privacy Policy and Terms of Use.
Cookie Settings
Cookies and similar technologies are used on this website for proper function of the website, for tracking performance analytics and for marketing purposes. We and some of our third-party providers may use cookie data for various purposes. Please review the cookie settings below and choose your preference.
Used for the proper function of the website
Used for monitoring website traffic and interactions
Cookie Settings
Cookies and similar technologies are used on this website for proper function of the website, for tracking performance analytics and for marketing purposes. We and some of our third-party providers may use cookie data for various purposes. Please review the cookie settings below and choose your preference.
Strictly Necessary: Used for the proper function of the website
Performance/Analytics: Used for monitoring website traffic and interactions
Home About Me Advertise Using Subtotals Function in MicrosoftExcel By The Professional Assistant on Wednesday, January 30, 2008 Filed Under: MS-Excel , Productivity D o you have a MicrosoftExcel spreadsheet where you have firm names and figures? Click Data, then Sort, then sort by the firm name.
Home About Me Advertise Increasing MicrosoftExcel 2007s Formula Bar Size By The Professional Assistant on Wednesday, November 18, 2009 Filed Under: MS-Excel , Productivity D o you find that trying to either write or fix formulas in MicrosoftExcel can be a pain?
For example, if I have MicrosoftExcel XP and would like to send a file to a client that only has MicrosoftExcel 97 (which was a horrible disaster for Microsoft, since there were quite a few bugs in this version), you could save the file as a MicrosoftExcel 97 version.
By The Professional Assistant on Wednesday, July 07, 2010 Filed Under: MS-Excel , Productivity Y our boss calls you over to their office and asks that you send her a list of something that you’ve created in MicrosoftExcel. You check your contact list and see that you have about 50 names in your Excel spreadsheet.
Home About Me Advertise Copying Tables, Pictures or Text in PDF Files to Other Sources By The Professional Assistant on Thursday, January 17, 2008 Filed Under: MS-Excel , MS-PowerPoint , MS-Word , Productivity D id your boss just ask you to copy a table, picture or text to another source of software, such as MicrosoftExcel or Word ?
Home About Me Advertise Sorting Tables in Microsoft Word By The Professional Assistant on Wednesday, January 23, 2008 Filed Under: MS-Word , Productivity H ave you ever wondered or tried to sort a table within Microsoft Word ? One of my colleagues came to me and asked about this very question.
On a side note, if you need help creating subtotals, check my post on using subtotal functions in MicrosoftExcel. This made my life a little difficult since I thought that I would have to copy and paste all of the subtotal amounts into this spreadsheet , as the report shows all of the details.
The way I would do it is that I would create a MicrosoftExcel spreadsheet for the month. I used to track calls for one of my past employers, when I used to work at a securities firm as an Investment Advisor Assistant. I say month, since I would create a sheet for each week, having the "from" and "to" dates in the sheet name.
You can use MicrosoftExcel to add all of this information and then add the numbers from the files to your Excel spreadsheet. You can use Microsoft Access to create a database of all of your files criteria and the software assigns a "key" or number that corresponds with your files. as you mentioned in your question.
We organize all of the trending information in your field so you don't have to. Join 208,000+ users and stay up to date on the latest articles your peers are reading.
You know about us, now we want to get to know you!
Let's personalize your content
Let's get even more personalized
We recognize your account from another site in our network, please click 'Send Email' below to continue with verifying your account and setting a password.
Let's personalize your content