Do MacBooks offer any advantage over PCs for MS Office work?
I switched from a Compaq and then an HP laptop to a MacBook Pro in 28 and saw an immediate increase in productivity due to improved hardware quality. Reasons include Longer life. Both the Compaq and HP failed after 42 months use. Their motherboards failed and it cost almost as much to replace that part as to buy a newputer. I retired the MacBook Pro this past December (even though it was still usable) solely because I wanted the new MacBook Pro features. Better trackpad. The Compaq and HP trackpads were so prone to falsing (detecting the heel of my hand and moving the insertion point when I least expected it) that I turned them off in favor of a mouse. With the MacBook Pro I retired the mouse and used the trackpad instead. Better keyboard. I started wearing the lettering off the Compaq and HP keyboards after 6 months and had almost worn a hole in a couple of the keys after 3 years. Keyboard feel was much better on the 28 MacBook Pro (not so much on the late 216 MacBook Pro alas). I also enjoy the backlighting on the Apple keyboard. I thought the Touch Bar on my late 216 MacBook Pro would be a gimmickbut am thoroughly enjoying it because I can see my F-keys in dim lighting. I also really enjoy logging in with my fingerprint. The only feature I miss about the keyboard is the inability to use the ALT + xxx shortcuts to special characters if you know their ASCII keycodes. There are Mac-only keybinations that will generate each of those characters but I haven learned them. Better screen. Less eye strain due to crisper appearing . More accurate colors. This is especially with the Retina screen on the late 216 MacBook Pro. More reliable hard drive. With the Compaq and HP I needed to reformat the hard drive every 12 to 18 months because of cumulative error in the FAT. On the MacBook Pro I replaced the HDD with SDD in 213 but have never needed to reformatnot even when I upgraded the operating system every 12 to 18 months. On the software side I am a Microsoft Excel power user. I write VBA code and push Excel to its limits. While I also use Outlook Word and PowerPoint frequently it is at a much less intense level than Excel. Here is the twist I do not use Mac Excel. Instead I run Windows 1 and Office 216 (64-bit) on a virtual machine using Parallels. The virtual machine runs my VBA code at respectable speeds onputationally intensive engineering problems. When Ipare execution times with clients the biggest gap I have seen is about 25% slower VBA code execution on my 28 MacBook Pro with a virtual machine than their more recent Windows box. Originally my preference for Windows Excel was because the VBA IDE in Windows Excel dates from 23 while that in Mac Excel was locked in 1997. Mac Office 28 made matters much worse because it had no VBA whatsoever. Mac Office 211 restored VBA but kept the old IDE. Mac Office 216 is aplete rewrite using the Windows Office code base but the VBA IDE deleted all but the barest essentials. It is suitable only for testing code not for VBA development. I keep my data files in a desktop folder on the Mac side with as many subfolders as a hard drive. This lets me use Time Machine to back up my data. It also minimizes directory corruption on the emulated C drive on the virtual machine because only applications and my Outlook mail get stored there. This practice also means I can wipe my virtual machine (if necessary) and not worry about losing my data. I can also copy my stuff easily from oneputer to another when I upgrade. If you don program in VBA you may find Mac Office 216 to be usable enough. Microsoft issues updates every one to three months (depending on your IT department policy) and has a stated goal of feature parity with Windows Office. The keyboard shortcuts have been harmonized and now work the same in Mac Excel as in Windows Excel.
What is the shortcut to delete sheet rows in Excel?
Hey Anand To delete a row in Excel requires 2 shortcut keybinations. Once youve practiced it a couple of times itll be second nature. Here how it works. . . Let pretend youve got a spreadsheet you want to delete a row from. Here one I prepared earlier ud83dudea In this example I like to delete the row for May or Row 6 . The first step it to select the row you want to delete. To select any row in Excel make sure you have any cell in that row selected and on your keyboard press SHIFT + SPACEBAR . Now that youve got your row selected let wipe it out. On your keyboard pre CTRL + MINUS . You can use the minus (hypen) sign to the right of the zero key or the one on the numeric keypad (if youve got one). Why select the row first and not just press CTRL + MINUS ? If you don select the entire row first Excel doesn known want you want to delete. So Excel will present the Delete dialog for you to confirm your intentions like this You then have to use the mouse (uugh) or Down-Arrow keys to select Entire Row and press ENTER . You can also press r on the keyboard which is the accelerator key for the Entire Row option (thanks to Paul for reminding me ud83dudea). While were at it if you wanted to delete an entire column instead press CTRL + SPACEBAR to select the current column first. Then press CTRL + MINUS to delete it. Here one more bonus-tip . . . If you wanted to insert italic a column or row instead of deleting one press CTRL + PLUS SIGN . On a regular keyboard this requires 3 keys CTRL + SHIFT + PLUS . All the best Marcus My Excel Genius
What are the most useful shortcuts for Microsoft Excel?
Excel provides more than 45 functions but actually knowing how to use a few of them would be sufficient in most cases. Ipiled a few easy but widely used functions s to facilitate data analysis in Excel. LEFT Excel allows you to extract the X number of characters from the beginning of cells. For example I extracted the business information of the auto repair shops in New York from s . In this spreadsheet you can see the names of the stores addresses phone numbers open hours etc. To break down the phone numbers of businesses you can use =LEFT(Select cell 3) italic to extract the area code from phone numbers and =RIGHT(Select cell 4) italic for the last 4 digits. Conditional formatting Conditional formatting is useful when you want to sort out certain data that is valuable to you especially when ites to numbers. Let say I want to find out all the flatshare & houseshare in Australia that is under $2. I can first scrape the housing information from italic s using an automated data extraction tool called Octoparse italic . Then I can select conditional formatting under the styles group. italic There are many formatting options to choose from according to your needs. In this case you can choose greater than and set up criteria for $2 and highlight them in yellow. Remove Duplicates It ismon to have duplicated values in your spreadsheet. Staying with the Gumtree example. To remove the duplicated info you can first highlight the duplicated data italic using the conditional formatting function (Optional this will make sure the duplicates are obvious enough to locate so that we won miss any) Then use the remove duplicates function on the Data tab in the Data Tools section. italic Make sure you only select the column that contains duplicated values rather than the entire sheet. VLOOKUP As one of the most frequently used functions vlookup is popular to search for data associated with a value you enter. Its formula =VLOOKUP(lookup_value table_arraycol_index_num range_lookup) italic Let me take the cryptocurrency market data I got from Yahoo Finance s as an example. Vlookup can search for the first column and find the matching value in the second column. Say you want to find the symbol of cryptocurrency matching price .13. Step 1 Sort the info in ascending order. italic Step 2 Select the two columns. italic Step 3 Enter number 2 since you are trying to fetch data from the second column. italic Step 4 Choose FALSE to ensure an exact match of data. italic As you can see in the gif below the corresponding value ATB-USD is returned.
Microsoft Office: What is a short cut key to delete the selected row in Excel 2007 for Mac?
You can press the Command key and - at the same time. If you have the row selected it'll delete the whole row. If you have a cell selected it asks what you want to do and you can press R for Row. Alternatively you can right click the Number at the left side of the row and then select Delete to remove the row.
What are some tech hacks that can be learned in 10 minutes?
1 3 To quickly change the case (upper vs. lower) of in Microsoft Word highlight the phrase then hit Shift + F3 . Word will automatically lowercase everything first and if you tap the shortcut again it will take into account periods and capitalize the start of a sentence. 2 3 Ever close your browser by mistake? We all have. No worries! To re-open an accidentally closed browser tab use Ctrl + Shift +T . Cmd is for Mac. 3 3 If you need to proofread a long essay be sure to paste your article into Google Translate and listen to it instead of reading it. This makes it easier to pick up mistakes and makes you a more proficient writer in the process. The tool can help you pick up minor typos that often shoot right past our eyes. Below you can see an example of the site. It super easy to use! 4 3 Run your writing or document past to clear typos grammar mistakes and get help with writing styles. As per the below s 495 88 Source Click here s
What are some useful tech hacks for everyday use?
Universal Parcel Tracking is great for tracking any shipment with a parcel number. Use PC Part Picker s to help build aputer. It keeps track ofpatibility issues between parts lists the most up-to-date price for a majority of websites has amentary section for every part and also lists builds different parts have been used in. Love the Chrome (Chromium) browser but hate Google? Try Vivaldi s . Want a browser that is incognito all the time? Try Brave s for PC and DuckDuckGo s for your smartphone. Wikipedia provides sources for most of its articles near the bottom of the article. Every Wiki article on the internet has a History page & Discussion page including Wikipedia itself. The History page allows you to view every single change ever made to its particular Wiki article and the Discussion page is where youll see people discussing issues related to the article. Don want a particular webpage to get any kind of clicks or views? Or want to keep it archived in case the webpage is ever changed or removed? Forget using screenshots which can be easily manipulated or the Wayback Machine which has been not only known for deleting controversial snapshots but still sends viewer data and just try out s instead. (It also has a History feature allowing you to view different saved snapshots.) Use Outline s to get past Wall Street Journal paywalls. Use an app like Hiya s to block private numbers scams telemarketers etc. In File Explorer file extensions are hidden by default. To show them in Windows 1 at the top of the window youll want to click on View then youll see a box with File name extensions next to it. Click on that. (Prior to Windows 1 and even with Windows 1 you could do this by typing in Folder Options in the Start Menu go to View and unclick Hide extensions for known files.)