Easy-XL - Excel Data Analytics Made Simple

File: CabArc.Exe - Microsoft Cab File Archive Utility

file.png
Uploaded:
28.12.09
Modified:
28.12.09
File Size:
63 KB
Downloads:
21945
Version
5.2.3790.0

Site Login

Shopping Cart

MrExcel Podcasts

Learn Excel from MrExcel
New Excel Tips & Tricks Every Weekday!
  • Convert Excel Dates to Month Names
    Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format. Try these: =TEXT(A2,”MMMM”) for full month name =TEXT(A2,”MMM”) for 3-letter month abbreviation =TEXT(A2,”DDDD”) for full month name =TEXT(A2,”DDD”) for 3-letter month abbreviation You can use any valid custom(...)
  • Excel Fill Alphabet or Roman Numerals
    Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III? For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down. For the lower case alphabet, use =CHAR(ROW(97:97)) For upper case Roman numerals: =ROMAN(ROW(1:1)) For lower case Roman numerals =LOWER(ROMAN(ROW(1:1))) Tip: After filling any of these,(...)
  • Excel Search Entire Workbook
    You need to find something, but you don’t know what worksheet it is on.   Display Find with Ctrl+F Click the Options > > button. Open the Search dropdown and change from Sheet to Workbook.
  • Copy Excel Worksheet – Easy and Fast
    You’ve created the perfect report for January. Now you need to make 11 copies for the other months. Hold down the Ctrl key. While holding down the Ctrl key, click on the sheet tab and drag to the right. You should see the mouse pointer change to an arrow pointing to a sheet with a(...)
  • Use Wheel Mouse to Scroll Left & Right in Excel
    Sure… you can roll the mouse wheel to scroll up and down… What about left and right? Your mouse wheel can be pushed in, like you are clicking a button on the mouse, but you are “clicking” the mouse wheel. While you hold the mouse wheel down, move the mouse left or right to scroll!(...)