Turn rows into columns or columns into rows with the Microsoft Excel Transpose feature. This brief tutorial shows you how.
When you use Microsoft Excel on your Mac for creating spreadsheets, you have plenty of layout options. But, sometimes it’s not until after you start entering your data that you wish you had structured the spreadsheet differently.
You may have entered column headers that would work better as row headers or vice versa. Luckily, you have a quick and easy way to make this type of switch with the Excel Transpose feature and here’s how to use it.... Read the rest of this post here
Whether you’re ready to make a move from Evernote or want to use another note-taking app along with it, here’s how to easily export notes from Evernote.
Evernote is a robust note-taking application with availability across multiple platforms, but it does have its limitations. For instance, the Evernote Basic plan only allows you to use the app on two devices for free. So, maybe you’ve decided to use another app in addition to Evernote. Or, maybe the time comes when you want to switch to a different note-taking app completely.
You can easily export notes from Evernote to a file that can then be imported to another note-taking application and here’s how.... Read the rest of this post here
Writing is an enjoyable activity, but you can really hamper yourself if you don’t have the proper tools. Whether you can’t find the motivation to write, have trouble collecting your ideas, or struggle with grammar, the right apps can really help. We’ll show you some of the best apps and tricks you can use to help you write more on your Mac. 1. Choose a Writing App Most writers will choose a standard word processor without a second thought. But there are many issues with this. When you type in a word processor, the text is continuously typeset as you…
Writing is an enjoyable activity, but you can really hamper yourself if you don’t have the proper tools. Whether you can’t find the motivation to write, have trouble collecting your ideas, or struggle with grammar, the right apps can really help.
We’ll show you some of the best apps and tricks you can use to help you write more on your Mac.
1. Choose a Writing App
Most writers will choose a standard word processor without a second thought. But there are many issues with this.
When you type in a word processor, the text is continuously typeset as you key it in. It’s easy to lose sight of the logical structure in favor of the typographical elements, which results in a loss of momentum while writing and subsequent distractions.
It also forces you to decide on a specific appearance of the heading with strict formatting options. A writer can’t focus on creating words, and may instead fiddle with fonts and menus as a way of procrastinating. A writing app should help writers to write; not get in the way to add unneeded friction.
And when you need a particular feature, it should be easy to discover. Word processors often obfuscate features in complex menus. You can work around this by writing in Markdown. Its syntax is simple to learn, lets you focus on the writing, and even let you create complex documents with all formatting options.
When you take time to draft an outline, you can work out if the ideas connect to each other, what order works best, identify gaps in your thinking, and confirm your thoughts with proven facts. Scapple is an intuitive app for jotting your ideas down by developing connections between them. It’s the software equivalent of pen and paper.
Unlike typical mind-mapping software, Scapple doesn’t force you to make connections, nor do you have to begin with a central idea. It’s a freeform writing app with an expandable canvas to fit all your notes. You can move notes around to make room for new connections, create stacks from notes, edit and resize them, or even link to files on your Mac.
Every writer should keep a notebook to store all their ideas and notes. OneNote is a personal digital notebook to write and manage all sorts of notes.
Try creating a Writing Projects notebook, and start adding few sections. You might have Ideas for new article ideas, Articles and Finished Articles for articles in progress and completed articles, and Track as a place to check your writing progress and improvements.
In the Ideas section, you can create a page for all ideas, another page as a simple Kanban board, and a page to keep web links. In the Articles section, create a new page for each article you want to write. Install the OneNote web clipper extension and start bookmarking or clipping articles from the web.
You can even embed a video, record audio, and take notes from the media. If necessary, create a subpage to keep your notes, bookmarks, and outline separately in a parent/child format. Develop your workflow and start using OneNote to manage resources and improve your productivity.
Many writers spend a lot of time pasting links from the web. When you do it manually, you not only waste time, but also lose momentum while writing—or worse, get lost following all those links.
SearchLink is a system service for macOS that handles searching multiple sources and automatically generate links for text. Start with an exclamation point (!). Then type the argument you want to use. For example:
Now let’s say you want to link an app from the Mac App Store. Type in !mas Pixelmator. Right-click and choose Services > SearchLink. Within seconds, it’ll run a search in the background and replace it with a full Markdown link.
You can use specific modifiers to customize the way you want to link with text. Put !! at the end of the text to only return the URL without any link formatting. Similarly, put ^ at the end to output the result to the clipboard, leaving the text in place.
For example, !s Pixelmator!! will run a software search for Pixelmator and output only a link. Then, if you bind this service with a hotkey, you can link the text just with the keyboard.
The built-in Dictionary app is a powerful tool to search for definitions, plus thesaurus and Wikipedia entries. You can search for the words manually, or point to a word and press Ctrl + Cmd + D to open the dictionary panel with the definition right in front of you.
To make the Dictionary app more useful, install Terminology. It is based on the WordNet project, a large lexical database of English. It joins not just word forms, but specific senses of the word. Also, it labels the semantic relations among words, making it more powerful than a thesaurus.
Open Dictionary > Preferences and check the Terminology box. It’ll now appear as one of your search options in the Dictionary app.
You can even use third-party apps to automate the window management operations. Hocus Focus is a menu bar utility that keeps your desktop clean by hiding the inactive windows automatically. If you have a problem with focus, use the HazeOver app to highlight the foremost app window and mask the windows in the background that distract you.
It’s not necessary to store every piece of text, images, and link in a notebook. Some items are temporary, so you’ll discard them later on. That’s where a clipboard utility app might be of help.
Alfred‘s clipboard history feature (part of the Powerpack) is unique. Go to Alfred’s Preferences, and under Features > Clipboard, enable Clipboard History. Check the box next to the relevant types, and choose how long you want to remember your clips.
Now, press the Alt + Cmd + C hotkey to bring up the Clipboard History panel. Alfred will show you the clips you’ve copied. Type any word or phrase in the search bar to filter your results.
You can even merge multiple clips onto your clipboard. Go to Features > Clipboard > Merging and enable the box next to merging. To append a clip onto the previously copied text, hold Cmd and double-tap C quickly. Then paste the clip you copied onto any app.
Even if you’ve learned to type quickly, certain forms of writing can require you to type repetitive text. You can avoid RSI and other injuries by cutting down on your keystrokes. Using a text expansion tool can save your hands and hours of your time.
aText accelerates your typing by offering shortcuts for the characters you write. When you open the app for the first time, you’ll see boilerplate snippets for typing in the date and time, symbol substitution macros, and more. To create a new snippet, type the keyword in the Abbreviation field, and content you want to expand in the Content field.
When you write a first draft, you’re just putting your ideas together. Spelling errors and poorly written sentences are common in first drafts, so it’s important to revise and improve it. You can use some tools to help you improve your final product.
At times, you’ll want writing suggestions. These can tell whether you’ve written a correct sentence, compare confusing words, which adjective or preposition is appropriate for a particular phrase, or get synonyms in context. Writefull is an app that gives feedback on your writing by checking your text against databases, like Google Scholar, Books, and more.
You might also want to use Grammarly for proofreading your articles. It checks your spelling, grammar, suggests synonyms in context, and more. And if you subscribe to Grammarly Pro, it’ll detect if you use words in a wrong way, subject-verb agreement, pronoun use, and punctuation usage.
To become a better writer, you need the best tools to help you realize your dreams. macOS is a creative environment to work with, and there are many third-party tools at its disposal—even more than ones discussed here.
Writing is a complicated skill, and these tools cover only half the job. You need to read more to become a better writer. If this inspires you, you might want to know how to read more books this year.
Apple has just wrapped up its fall 2018 event, with three new iPhones and a new Apple Watch available for pre-order now. The rumors were mostly true, but that shouldn’t surprise anyone by now. The company also announced the release date for the upcoming iOS 12 update, macOS Mojave, and the new version of tvOS which powers the Apple TV. We’ve crunched through the news to bring you the most important and interesting bits. We’ll also have a look at what was missing from the event. iPhone Xs With the introduction of the iPhone X in 2017 (our review), it…
Apple has just wrapped up its fall 2018 event, with three new iPhones and a new Apple Watch available for pre-order now. The rumors were mostly true, but that shouldn’t surprise anyone by now.
The company also announced the release date for the upcoming iOS 12 update, macOS Mojave, and the new version of tvOS which powers the Apple TV. We’ve crunched through the news to bring you the most important and interesting bits. We’ll also have a look at what was missing from the event.
With the introduction of the iPhone X in 2017 (our review), it made sense that 2018 was going to be an “s” year. In these, Apple traditionally refreshes the internal hardware rather than focusing on design refreshes. With the arrival of the iPhone Xs and its new larger sibling, the iPhone Xs Max, that’s exactly what we got.
Both versions come with Apple’s first 7-nanometer processor, the A12 bionic. This promises more advanced machine learning in the form of the eight-core Neural Engine. That means the new iPhones will be better at tasks like analyzing photos for recognized objects, faces, and more.
Apple also announced that the new chips use 50 percent less power than the previous version. They also come with a 15 percent boost in overall speed, and 50 percent faster GPU architecture. Overall, these improvements will result in faster Face ID, better augmented reality, improved pattern recognition (meaning improved Snapchat filters), and better gaming performance. It’s what we expect from an “s” upgrade.
Both models are also IP68 water resistant, which means you can submerge them to a depth of around 32 yards for 30 minutes. Oddly enough, Apple only markets the depth around two yards. But in order to reach the IP68 rating, the devices must comply with the 32 yard requirement.
Camera, SIMs, and More
Apple has buffed the camera technology in the new Xs and Xs Max. They pack a better image signal processor on the A12 chip, improved quad-LED true tone flash, and smarter camera technology for better bokeh when taking portraits. Both models still feature the dual-lens system, with f/1.8 and f/2.2 apertures on the wide and telephoto lenses respectively.
A new Depth Control feature lets you adjust the depth of field after you’ve taken your shot. Meanwhile, Smart HDR apparently features zero lag for better exposures with less inconsistencies. The iPhone Xs uses the same impressive OLED display as the last version. Plus, both models ship with Gorilla Glass 5 for displays that are twice as tough as last year’s model.
Thanks to Apple’s eSIM virtual SIM technology, the new iPhones have support for two phone numbers. Another communications update means support for Gigabit-class LTE, plus improved band support for better worldwide roaming.
The iPhone Xs offers a 30 minute improvement in battery life over its predecessor, with pricing starting a $999 for the 64GB option. You can also get 256GB and 512GB versions for $1,149 and $1,349 respectively. Both phones are available in a new gold finish.
iPhone Xs Max
While the Xs retains the same 5.8-inch form factor as its predecessor, the Xs Max is a larger 6.5-inch iPhone. It houses a 2688×1242 display at the same 458 pixels-per-inch rating as its smaller sibling. Not only is it a bigger screen, but the iPhone Xs Max can run two apps side-by-side in landscape mode thanks to all that real estate.
Apple chose the “Max” name since there’s more screen space than a traditional “Plus” model iPhone. A bigger screen means more space for a bigger battery, so the iPhone Xs Max features a 90 minute boost in usage over the standard iPhone X introduced in 2017.
As expected, the Xs Max really is just a larger version of the new Xs, with a bigger price tag to match. You can pick up a 64GB model for $1,099, with 256GB and 512GB capacities available for $1,249 and $1,449 respectively.
Also rumored but still somewhat surprising for a company like Apple is the new cut-price iPhone Xr. It’s a 6.1-inch budget version of the Xs, available in a rainbow of colors: red, yellow, white, coral, black, and blue. It provides considerably more screen real estate than the iPhone 8 (our review), while only being a little bit larger.
In order to get the price down, the Xr forgoes the OLED display of the Xs model in favor of a new “Liquid Retina” LCD. Apple boasts that the display has the industry’s best color accuracy, a wide color gamut, the same “tap to wake” seen on its OLED panels, and the usual True Tone temperature adjustment.
While the Liquid Retina display is edge-to-edge, there seems to be slightly more bezel when compared with OLED models. Since it’s an LCD display and not an OLED, the blacks won’t be quite as deep. Just like the previous iPhone X, the Xr leaves the Home button behind. This marks the first time Apple has gone all-in on the design in its flagship lineup.
As you’d expect, the Xr features the same A12 Bionic chip, True Depth camera for Face ID, and a single lens rear-facing camera like that found on the iPhone 8. You get the same Smart HDR and Depth Control features, and the improved image signal processor means cleaner photos and better low light performance.
It’s a budget iPhone Xs, but it’s really a replacement for the iPhone 8. The new iPhone Xr starts at $749 for the 64GB version, with 128GB and 256GB models available for $799 and $899 respectively. Unlike the Xs models, the Xr isn’t available for pre-order until October 9.
Apple Watch Series 4
Also new for 2018 is the thinner Apple Watch Series 4. It features a new design with a larger watch face, and much thinner bezels than previous models. It looks more like a traditional watch and less like a piece of wearable tech. This is fitting since Apple also announced that the Apple Watch is the world’s “number one” watch (not just among smartwatches, but all watches).
The Watch now features two sensors on the back. One is an Optical Heart Sensor for measuring heart rate; the other is an Electrical Heart Sensor. This generates an ECG (electrocardiogram) which you can share with your doctor. An advanced accelerometer can now detect falls, prompting the wearer to call an ambulance (which happens automatically if it senses no movement for a minute).
Performance has been improved by double thanks to the new 64-bit processor. Apple has also brought its haptic feedback technology to the Digital Crown, which now “clicks” as you scroll. There are software improvements too, like new watch faces and a redesigned version of Apple’swatch face which makes better use of the larger display.
One thing that hasn’t improved is battery life, which still sits at 18 hours of wear. Just like the Series 3, the Series 4 is available in GPS and Cellular versions for $399 and $499 respectively. If you go for the cellular version, make sure you know what your carrier will charge to include it on your plan.
The Watch Series 4 will run watchOS 5, which was announced at WWDC. It packs features like an improved Activity Tracker, Apple’s Podcasts app, new Walkie-Talkie functionality, better Siri integration, and more. You can pre-order the Apple Watch Series 4 now.
iOS 12, macOS Mojave, and tvOS 12
In other news, the updated versions of Apple’s iOS, macOS, and tvOS operating systems now have official release dates:
iOS 12: Available on September 17.
macOS Mojave: Available on September 24.
watchOS 5: Available on September 17.
tvOS 12: Available on September 17.
What We Didn’t See
Two glaring omissions from this year’s event include Apple’s AirPower wireless charging station (announced a year ago) and a revised version of AirPods. No AirPods 2 also meant no new Beats wireless headphones, though the rumor mill points to late 2018 as a release date for all these products.
Also absent was any news about iPads, particularly the iPad Pro. Apple is expected to refresh (or discount) the MacBook Air, possibly introduce a new Mac mini, and refresh a few of its other Mac models before the year is out. Thus, it’s possible we’ll see another event before the fall ends.
Take care of the garbage that clutters your inbox by customizing the Junk Mail filter in the Mail app for Mac. It’s easy to do and here’s how.
Junk mail comes in many forms and while some messages are obvious junk, others might not be. If you want to have more control over what the Mail app considers as junk mail on your Mac, here’s how to customize the filter settings.... Read the rest of this post here
24 hours of users’ browsing data was unknowingly sent to Trend Micro’s servers.
Apple removed several anti-malware apps from its Mac App Store after the apps were found to export users' browser histories. All of the apps in question are made by the cyber-security company Trend Micro, which initially denied the allegations but has since issued an apology to its users.
"Reports that Trend Micro is 'stealing user data' and sending them to an unidentified server in China are absolutely false," the initial statement says.
The statement also details what Trend Micro found in its investigation: the company claims its some of its apps, including Dr. Cleaner, Dr. Antivirus, and Dr. Unarchiver, uploaded a "small snapshot" of users' browser histories that covered the 24 hours before installation. The company claims this was done for "security purposes," particularly to see if users had recently come into contact with adware or other threats. The collected user data was uploaded to a US-based server hosted by Amazon Web Services and managed by Trend Micro.