# iWork Expert
> iWork Expert is a tutorial site dedicated to Pages, Numbers, and Keynote: Apple's iWork apps for Mac. Learn tips, tricks, and how-tos from a dedicated Mac user
Public Ghost content for AI and LLM tooling. Use `/llms-full.txt` for consolidated page and post context.
Append `.md` to any post or page URL to get the content in Markdown (for example, `/example-post.md`).

## Pages
- [About](https://iworkexpert.com/about.md) - Hi, my name is Bill. Below is a picture of me, and yes, that's a homemade piñata costume my wife made. I created iWork Expert, and I'm the one writing everything on it. Why I Built This When I started looking for a dedicated resource for Pages, Numbers, and Keynote, I couldn't find one. Apple's own…
- [Contact](https://iworkexpert.com/contact.md) - Want to get in touch? Here's the best way to reach me, plus what I can (and can't) help with over email.
- [Legal Stuff](https://iworkexpert.com/legal-stuff.md) - iWork Expert (iWorkExpert.com) is an independent website created by Bill Kaiser and is not affiliated with or endorsed by Apple Inc. Apple, the Apple logo, iWork, Keynote, Numbers, and Pages are trademarks of Apple Inc., registered in the U.S. and other countries. Welcome to iWork Expert. By browsi…

## Posts
- [How to Type Special Characters and Symbols in Pages, Numbers, and Keynote](https://iworkexpert.com/type-special-characters-symbols-pages-numbers-keynote.md) - Three simple ways to type any symbol on your Mac, plus how to make your own shortcut.
- [The COUNTIF Function in Numbers Explained](https://iworkexpert.com/countif-function-in-apple-numbers.md) - The COUNTIF function returns a count of cells that match a single condition. Literally, "count if..."
- [Freeze Panes in Spreadsheet Tables in Numbers](https://iworkexpert.com/freeze-panes-in-apple-numbers.md) - Freeze panes in Apple Numbers to leave rows or columns fixed in place. See these areas no matter where you scroll in the spreadsheet.
- [Apple Intelligence Writing Tools in Pages](https://iworkexpert.com/apple-intelligence-writing-tools-in-apple-pages.md) - Apple Intelligence Writing Tools can help improve your writing by proofreading, rewriting text, and summarizing
- [Paste Special Values in Numbers](https://iworkexpert.com/paste-special-values-in-apple-numbers.md) - Perform a Paste Special Values in Apple Numbers just as you do in Excel. The only difference is that it goes by another name in Numbers.
- [Unlock or Lock a Spreadsheet in Numbers](https://iworkexpert.com/unlock-or-lock-a-spreadsheet-in-apple-numbers.md) - Anyone can unlock or lock a spreadsheet in Apple Numbers. It's not meant for security, but there are some benefits for you to consider.
- [The SUMIF Function in Apple Numbers Explained](https://iworkexpert.com/the-sumif-function-in-apple-numbers-explained.md) - The SUMIF function returns the sum of cells that match a single condition. Literally, "sum if..."
- [Translate Text in Pages to Another Language](https://iworkexpert.com/translate-text-in-pages-to-other-languages.md) - There's a simple and accurate way to translate text in Pages. Learn what languages you can translate to and speed up your workflow.
- [Export Keynote Presentations to PowerPoint and Other File Formats](https://iworkexpert.com/export-keynote-to-powerpoint-and-6-other-formats.md) - Export Keynote presentations to formats like PowerPoint, an MP4 movie, animated GIFs, and more. Use Keynote for more than just presentations.
- [Export Numbers Spreadsheets to Excel and Other File Formats](https://iworkexpert.com/export-numbers-to-excel-and-4-other-formats.md) - Export Numbers spreadsheets to formats like Excel, CSV, and more. If compatibility or distribution is a concern, Numbers has the capability.
- [Export Pages Documents to Word and Other File Formats](https://iworkexpert.com/export-pages-to-pdf-and-6-other-handy-formats.md) - Export Pages documents to formats like Word, an EPUB, a PDF, and more. Whatever you're writing, Pages exports to many distribution formats.
- [A Sleek and Free Recipe Template for Pages](https://iworkexpert.com/a-sleek-and-free-recipe-template-for-pages.md) - Here’s a free, sleek recipe template for Apple Pages you can download and start using right away. It’s designed to keep things clean, simple, and easy to print or share.
- [The Difference Between Animations and Transitions in Apple Keynote](https://iworkexpert.com/difference-between-animations-and-transitions-in-apple-keynote.md) - Confused what the difference between animations and transitions in Apple Keynote? This post will clear up what they are and when to use them.
- [Export Apple Contacts into an Apple Numbers Spreadsheet](https://iworkexpert.com/export-apple-contacts-into-an-apple-numbers-spreadsheet.md) - Easily export Apple contacts into an Apple Numbers spreadsheet. It's a great way to visually organize information saved with your contacts.
- [Create a Table of Contents in Apple Pages](https://iworkexpert.com/how-to-make-a-table-of-contents-in-apple-pages.md) - Creating a table of contents in Apple Pages is simple. You can even customize the way it looks and choose what sections to include or exclude.
- [Remove Hyperlinks in Apple Numbers](https://iworkexpert.com/remove-hyperlinks-in-apple-numbers.md) - Whether it's an email address or a website URL, learn how to remove hyperlinks in Numbers spreadsheets.
- [Sum Numbers Using Criteria in Apple Numbers](https://iworkexpert.com/sum-numbers-using-criteria-in-apple-numbers.md) - SUM using criteria in Apple Numbers with the SUMIF and SUMIFS functions. They're great timesavers no matter the conditions you set.
- [Word Processing & Page Layout Modes in Pages: An Overview](https://iworkexpert.com/word-processing-vs-page-layout-mode.md) - When considering word processing vs. page layout in Apple Pages, the end goal is the main consideration. Learn which document type is best.
- [Fix a SUM Formula That Totals to Zero in Apple Numbers](https://iworkexpert.com/how-to-fix-sum-formula-that-totals-to-zero.md) - Are you using a SUM formula that totals to zero? If this is happening to you, learn why and how you can fix it.
- [Create Fun, Animated GIFs Using Apple Keynote](https://iworkexpert.com/create-animated-gifs-using-apple-keynote.md) - Create animated GIFs using Apple Keynote? Yes, it's true. Learn how without the need of third party software.
- [How to Fix a Font Not Showing in Apple Pages](https://iworkexpert.com/fonts-not-showing-in-apple-pages.md) - Fonts not showing in Apple Pages? Easily fix this frustrating quirk with a simple how to guide.
- [The DATEVALUE Function in Apple Numbers Explained](https://iworkexpert.com/the-datevalue-function-in-apple-numbers-explained.md) - Converts a date stored as text into a real date value Numbers can work with, most often needed when importing data from Excel.
- [The DATEDIF Function in Apple Numbers Explained](https://iworkexpert.com/the-datedif-function-in-apple-numbers-explained.md) - The DATEDIF function lets you calculate the difference between any two dates with an output in days, months, or years.
- [The DATE Function in Apple Numbers Explained](https://iworkexpert.com/the-date-function-in-apple-numbers-explained.md) - The DATE function combines the three parts of a date (year, month, and day) that are listed in separate cells into a single cell entry

## Optional
- [RSS Feed](https://iworkexpert.com/rss/)
- [Sitemap](https://iworkexpert.com/sitemap.xml)
- [Full content of pages and posts](https://iworkexpert.com/llms-full.txt)