MacMost: Video Podcast

When building Numbers spreadsheets it is important to remember that a row in a table is the equivalent to a record in a database. To build a billing system, you can put clients in one table and invoice items such as billable hours in another table. Then you can build a sheet with tables that use functions to populate an invoice. The requires some advanced functions like LOOKUP, INDEX, IF, AND, COUNTIF and more. But once you are done, you can easily add more records and create invoices.

Apple has updated the way podcasts appear on the web, allowing you to preview and listen to episodes right in your web browser without needing to jump into iTunes. This could provide a nice way to listen to one episode without much fuss. It could also mean that Apple is getting ready to break up the iTunes app.

You can add a motion effect to a 2D photo without buying expensive software. By using Preview to cut a photo into layers and Keynote to animate them, you can make a photo come to life. This simple parallax animation effect can be used on all sorts of photos to create interesting videos or animated GIFs.

Clearing the browser cache was simple in Safari, but the menu command is gone. However, you can still clear the cache, and do so more efficiently by clearing cache, cookies and other items on a per-website basis. You can also bring back the Empty Cache command. Clearing a website's cache and cookies is one way to fix things when a website starts misbehaving.

The opening and closing slides of a presentation are often on the screen for a while, so why not make them more interesting than just some text? You can easily add a video as a background to a keynote slide. With iMovie you can create a few different backgrounds that you can reuse.

Most Mac users know how to use Command+Tab to use the app switcher. But did you know you can also hide and quit apps with the app switcher? You can also use the cursor to select an app and even drag and drop documents onto apps. By using other keys, you can navigate to a specific window or even a recently-opened document.

A new feature of Keynote 9 is the ability to export as an animated GIF file. These are useful to upload to social media or send via text message. The exported GIF includes all transitions, animations and special effects.

A new feature of Pages 8.0 is the Table Of Contents View. This is an alternative to the thumbnails view that you can use to quickly navigate while writing and editing a large document. The Table Of Contents View is a separate feature from the Table Of Contents element that you can insert in your documents, though they have some similarities.

The Keyboard Panel Accessibility feature on your Mac lets you create sequences of keypresses that you can repeat by pressing a button. This could make some unusual tasks easier to perform. In this example we'll use a panel button to repeat an unusual search and style function in Pages.

You can combine two or more shapes from Apple's huge shape library to create your own unique shapes. You have four methods for combining shapes to add, subtract, exclude or find the union of the shapes. You can then save the shapes for later use.

If you are having trouble accessing a website, it could be because of a problem with your DNS cache. To reset your DNS cache on your Mac, you need to enter a command using the Terminal. In most cases, this will work, especially if you are using macOS Sierra, High Sierra, or Mojave. Earlier versions of OS X may need some additional commands as well.

If you need to print the list of files in a folder, you can do it using TextEdit, the Terminal or by using a special trick involving your printer. Using TextEdit is a simple drag-and-drop, but you must be working with a plain text document. By using the ls command in the Terminal, you can customize which information is included with the listing. You can also simply drag and drop a folder to an alias to your printer, but you must create that alias first.

When you download a file in Safari, the file is saved in the default location, usually the Downloads folder. You can select any location as the default in Safari Preferences. You can also have Safari ask you each time you download a file and then you can select the location and even change the filename. You can also bring up the context menu in most cases and decide whether to use the default location or a specific location each time.

The old Stationery function is gone in macOS Mojave, but you can still create email templates you can easily access. The trick is to build draft email messages and then move them to a custom mailbox. Then you can grab one of those messages and send it, customizing it as you see fit. In addition, you can use Pages instead of Mail to compose your templates as some features like tables are only available this way.

Since the iPhone X-series models have no Home button, new users sometimes struggle with how to exit apps and get back to the Home screen. The Home indicator line at the bottom of the screen is the key to doing this. However, it is important to realize that this line is at the bottom of the screen in any orientation. So it won't appear on the right when you are playing a game in horizontal mode, but at the bottom of the screen under the game or sometimes over the graphics at the bottom of the game.

It is important to check and adjust your recording level before recording audio for a voice memo, audio file, video, presentation narration or anything that uses your microphone. Your Mac has an overall system setting for recording level, but some apps also have their own recording level adjustments.

Need to convert a jpg image to a jpeg? Or an mov video to a mp4? Chances are you don't need to convert anything at all. You just need to change the filename. File extensions on a Mac are somewhat optional and often interchangeable. A jpg is the same as a jpeg file. Video files extensions aren't as important as the contents of the file as video file are really just containers.

One reason to use Final Cut Pro or a similar pro-level video editing app is to have access to a wide variety of interesting and useful filters. I'll show you how to apply a basic filter and how to make adjustments. We'll look at how to make your video look like an animation, apply a style and use effects like old film and rain.

You can quickly and easily create reminders from email messages, web pages and documents to remind you to complete a task at a later time. The notification you receive will link you directly back to the content. You can also use this for Maps locations, Messages and a variety of other items on your Mac.

Split View allows you to use Full Screen mode but with two apps instead of just one. You start Split View by holding the green button on one window and then choosing the left or right side. Then you click on another app to place it on the other side. The Split View screen acts as a Desktop and can be accessed from Mission Control. You can exit Split View by using the green button again on one of the two apps, which leaves the other app behind in Full Screen mode. But there is a way to exit Split View and return both apps to normal mode at the same time.