Podcasts

18 10 2020

In this new section of my blog, I will be presenting you with a series of articles about Excel under the general heading of Hide and seek

Here are my opening words

How to stop playing hide and seek with Excel

Let’s face it, almost everything is hidden from you when you first open Excel. Yes, the ribbon system is great and yes, you can find lots of things really easily and quickly. And then you can’t!

Now What? And who wants to play hide and seek when there’s a deadline looming or when you know what you want to do but there’s just one piece of the Excel jigsaw missing?

Click File and scoot down to Options … you’ve now arrived at the backstage area of Excel and this is where they hide things. On the menu of the left hand side of this backstage area are these categories

  • General
  • Formulas
  • Data
  • Proofing
  • Save
  • Language
  • Ease of Access
  • Advanced
  • Customize Ribbon
  • Quick Access Toolbar
  • Add-Ins
  • Trust Center

In the first few episodes of these podcasts, I will explore these categories and then Excel will have nowhere to hide from you!

In the first episode I will share with you how to the QAT, the Quick Access Toolbar and that alone will blow your mind!

Stay safe in this uncertain world

Duncan Williamson

18th October 2020

Show Zero in Excel

28 06 2020

https://www.quora.com/q/duncansanswers/How-do-I-show-extra-zeros-in-Excel?ch=99&share=51187c6c&srid=2m1N

https://www.quora.com/q/duncansanswers/In-Excel-what-is-the-formula-that-is-most-popular-to-calculate-wealth-based-on-salary-increases-in-your-job?ch=99&share=b7913f2d&srid=2m1N

https://www.quora.com/q/duncansanswers/What-is-cross-tabulation-in-Excel?ch=99&share=91fc4476&srid=2m1N

https://www.quora.com/q/duncansanswers/How-do-I-make-every-other-line-shaded-in-Excel?ch=99&share=abc11be8&srid=2m1N

https://www.quora.com/q/duncansanswers/How-do-you-put-a-formula-in-the-middle-of-a-sentence-in-Excel?ch=99&share=1864d947&srid=2m1N

https://www.quora.com/q/duncansanswers/How-do-I-use-the-LARGE-or-rank-functions-with-a-group-of-numbers-that-includes-a-few-N-A-cells?ch=99&share=44d73c75&srid=2m1N

Random Search

28 06 2020

https://www.quora.com/q/duncansanswers/Is-it-possible-to-do-a-random-search-for-100-names-and-have-a-result-that-lists-the-organizations-ID-number-and-name-I?ch=99&share=377cfd6a&srid=2m1N

https://www.quora.com/q/duncansanswers/How-do-I-properly-format-my-data-in-an-Excel-x-y-scatter-chart-Please-see-comments-for-more-details?ch=99&share=84b0060c&srid=2m1N

https://www.quora.com/q/duncansanswers/How-do-I-show-how-much-increase-decrease-from-previous-data-on-a-12-week-rolling-spreadsheet-preferably-automated?ch=99&share=b36807e8&srid=2m1N

%d bloggers like this: