It's been a while since I've posted, but it's because I've decided to migrate my website from WordPress to @ghost.org It's 95% there (still a few minor things to do), but it's essentially complete. Nothing overly snazzy, but an exciting move nonetheless. If you have a chance, check it out and let me know what you think. Overall, the look is cleaner and the content is easier to read. #iWork #Pages #Numbers #Keynote #WordPress

@richaesthetic I here you. It's not as "intuitive" as Excel, but once you figure it out you'll realize Apple tries to make it overly simple. Best tip I figured out is to not include labels within the selected data. Whatever graph you pick will automatically include the labels. What kind of chart are you looking to make?

Freeze your header rows in Apple Numbers to leave column headers fixed. This'll help you avoid forgetting what each column represents. #iWork #AppleNumbers #Numbers #Spreadsheets

https://iworkexpert.com/freeze-header-rows-in-apple-numbers/

@richaesthetic Thanks! It’s mostly a hobby website, so I’m working on adding content here and there. Building templates and offering them for free is something I want to do. It’s just finding the time to do it all.

@richaesthetic I’ve also wondered why Apple hasn’t done something like this. It seems like a no brainer.

Curious, what kind of templates are you looking for? I’ve made a couple of free ones on my own, but all people ever seem to want are “Budget” or “Stock Market” templates.

Enhance your writing skills with Apple Intelligence Writing Tools. Proofread, rewrite, and summarize to your heart’s content. #Apple #Pages #AppleIntelligence #Writing

https://iworkexpert.com/apple-intelligence-writing-tools-in-apple-pages/

@Galley It's true. Although, I'll admit it threw me off coming from Excel 🙃.

My only grip is that there's no right click option to select this action. It seems you can only do this using a keyboard shortcut or finding the option through the menu bar.

Paste Special Values in Apple Numbers

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.

https://iworkexpert.com/paste-special-values-in-apple-numbers/

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. #Numbers #Spreadsheet #Apple #iWork

https://iworkexpert.com/unlock-or-lock-a-spreadsheet-in-apple-numbers/

@Oiselarius Hear, Hear!

To SUM numbers that satisfy a single condition, use the SUMIF function in Apple Numbers. It's a great timesaver and better than filtering. #Apple #Numbers #SUMIF #iWork

https://iworkexpert.com/the-sumif-function-in-apple-numbers-explained/

@Tarrenvane Are you looking for a count of the occurrence? You may get the result by nesting SEARCH, in ISNUMBER, in a COUNT function. I’d have to see what your spreadsheet looks like to be sure, but it could be a start.

There's a simple and accurate way to translate text in Pages. Learn what languages you can translate to and speed up your workflow.
#Pages #Translate #Language

https://iworkexpert.com/translate-text-in-pages-to-other-languages/

@Galley Interesting. I like it.

Copyright (©), Registered (®) and Trademark (™). Using keyboard shortcuts is typically the way to go when you want to these symbols. Learn how and why you'll want to do so. #Pages #Numbers #Keynote

https://iworkexpert.com/type-the-copyright-symbol-registered-trademark/

If you're trying to figure out how to add proper accent marks to your text (aka diacritcal marks), then this post is for you. Learn how easily this can be done.
#pages #numbers #keynote

https://iworkexpert.com/add-accent-marks-to-text-in-pages-numbers-and-keynote/

I’ve been spending some time updating the https://iworkexpert.com/ website. You probably won’t notice much changed aesthetically, but overall it’s a little more snappier and optimize. Still some work to be done, but I like where it’s heading. Check it out! It’s live. Feedback is welcome too! #website #blog #wordpress

@frlan Hey there. I might be able to help you with your question, but what is ODS? I’m not sure what that stands for.

Need to export #Keynote to #PowerPoint? Did you know you can also export your presentation as a #movie, #GIF? There's a total of 7 different formats you can export to. Learn how to do this and what formats may be best for your presentation. #iWork

https://iworkexpert.com/export-keynote-to-powerpoint-and-6-other-formats/

Need to export #Numbers to #Excel? What about to #CSV or another format? There's a total of 5 different formats you can export to in Numbers. Learn how to do this and what formats may be best for your #spreadsheet. #iWork

https://iworkexpert.com/export-numbers-to-excel-and-4-other-formats/