Fall in Like with Excel - one cell at a time

Welcome! I’m Anne Walsh, also known as The Excel Lady.

In here you’ll find lots of tutorials, hints and tips – for beginners and experts alike.

Everything is designed to help you solve YOUR Excel problems. Much of it comes from questions I get when training people in Excel, so I know it will help!

When you’re unsure how to do something, Excel can feel frustrating – you may have even caught yourself saying you ‘hate’ it!

If you’re ready for me to demystify Excel for you, to help you become proficient in using the functionality you see others using, to (dare I say it) even begin to LIKE using Excel, then let’s get to it!

Start by using the search box to look for something you’d like to know – or feel free to browse the site and soak it all in.

And whenever you have a question, you can get in touch with me directly here.

Books

I’ve written a number of Books about Excel – read more about them here!

Courses

Ready to take whenever you are, find out more about my courses in Excel through here.

Snacks

Not the edible kind – but definitely easy to consume info about using Excel you can watch while sipping your favourite cuppa!

Companies I've Worked With

MicrosoftTeams-image (10)

saolta_logo

eNet_12079_Speed Fibre Group Identity (The home of Enet and Magnet+)-01

Logo_Signature_Container_Square_Centered_ENG_RGB-600x600

bfree_logo

Nuxe

Recent Posts

My 24 for 2024

Reflections on my first ever sabbatical…

How to colour code your pivot table with Conditional Formatting

06 – Pivot Tables – How to show % breakdown with Show Values As

05 – Pivot table – Grouping my data by dates and in bins (grouping in quantities)

#af-form-1994049289 .af-body{font-family:Tahoma, serif;font-size:10px;color:#CCCCCC;background-image:none;background-position:inherit;background-repeat:no-repeat;padding-top:15px;padding-bottom:15px;} #af-form-1994049289 {border-style:solid;border-width:1px;border-color:#CFCFCF;background-color:#FFFFFF;} #af-form-1994049289 .af-standards .af-element{padding-left:55px;padding-right:55px;} #af-form-1994049289 .af-quirksMode{padding-left:55px;padding-right:55px;} #af-form-1994049289 .af-header{font-family:Tahoma, serif;font-size:16px;color:#CCCCCC;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;border-width:1px;border-color:#080008;background-image:none;background-position:top;background-repeat:repeat-x;background-color:#217346;padding-left:10px;padding-right:10px;padding-top:10px;padding-bottom:10px;} #af-form-1994049289 .af-footer{font-family:Tahoma, serif;font-size:12px;color:#CCCCCC;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;border-width:1px;background-image:none;background-position:top left;background-repeat:no-repeat;background-color:#217346;padding-left:15px;padding-right:15px;padding-top:1px;padding-bottom:1px;} #af-form-1994049289 .af-body input.text, #af-form-1994049289 .af-body textarea{border-color:#0D010D;border-width:1px;border-style:solid;font-family:Tahoma, serif;font-size:12px;font-weight:normal;font-style:normal;text-decoration:none;color:#FFFFFF;background-color:#E7F0EA;} #af-form-1994049289 .af-body input.text:focus, #af-form-1994049289 .af-body textarea:focus{border-style:solid;border-width:1px;border-color:#030303;background-color:#EDF2EF;} #af-form-1994049289 .af-body label.previewLabel{font-family:Tahoma, serif;font-size:12px;font-weight:normal;font-style:normal;text-decoration:none;color:#010A04;display:block;float:none;text-align:left;width:auto;} #af-form-1994049289 .af-body .af-textWrap{width:98%;display:block;float:none;} #af-form-1994049289 .buttonContainer input.submit{font-family:Tahoma, serif;font-size:12px;font-weight:normal;font-style:normal;text-decoration:none;color:#FFFFFF;background-color:#46B46C;background-image:url("https://forms.aweber.com/images/forms/grace/green/submit.png");} #af-form-1994049289 .buttonContainer{text-align:center;} #af-form-1994049289 .af-body label.choice{font-family:inherit;font-size:inherit;font-weight:normal;font-style:normal;text-decoration:none;color:#000000;} #af-form-1994049289 .af-body a{font-weight:normal;font-style:normal;text-decoration:underline;color:#46B46C;} #af-form-1994049289, #af-form-1994049289 .quirksMode{width:100%;max-width:250.0px;} #af-form-1994049289.af-quirksMode{overflow-x:hidden;} #af-form-1994049289 .af-quirksMode .bodyText{padding-top:2px;padding-bottom:2px;} #af-form-1994049289{overflow:hidden;} #af-form-1994049289 button,#af-form-1994049289 input,#af-form-1994049289 submit,#af-form-1994049289 textarea,#af-form-1994049289 select,#af-form-1994049289 label,#af-form-1994049289 optgroup,#af-form-1994049289 option {float:none;margin:0;position:static;} #af-form-1994049289 select,#af-form-1994049289 label,#af-form-1994049289 optgroup,#af-form-1994049289 option {padding:0;} #af-form-1994049289 input,#af-form-1994049289 button,#af-form-1994049289 textarea,#af-form-1994049289 select {font-size:100%;} #af-form-1994049289 .buttonContainer input.submit {width:auto;} #af-form-1994049289 form,#af-form-1994049289 textarea,.af-form-wrapper,.af-form-close-button,#af-form-1994049289 img {float:none;color:inherit;margin:0;padding:0;position:static;background-color:none;border:none;} #af-form-1994049289 div {margin:0;} #af-form-1994049289 {display:block;} #af-form-1994049289 body,#af-form-1994049289 dl,#af-form-1994049289 dt,#af-form-1994049289 dd,#af-form-1994049289 h1,#af-form-1994049289 h2,#af-form-1994049289 h3,#af-form-1994049289 h4,#af-form-1994049289 h5,#af-form-1994049289 h6,#af-form-1994049289 pre,#af-form-1994049289 code,#af-form-1994049289 fieldset,#af-form-1994049289 legend,#af-form-1994049289 blockquote,#af-form-1994049289 th,#af-form-1994049289 td { float:none;color:inherit;margin:0;padding:0;position:static;} #af-form-1994049289 p { color:inherit;} #af-form-1994049289 ul,#af-form-1994049289 ol {list-style-image:none;list-style-position:outside;list-style-type:disc;padding-left:40px;} #af-form-1994049289 .bodyText p {margin:1em 0;} #af-form-1994049289 table {border-collapse:collapse;border-spacing:0;} #af-form-1994049289 fieldset {border:0;} .af-clear{clear:both;} .af-form{box-sizing:border-box; margin:auto; text-align:left;} .af-element{padding-bottom:5px; padding-top:5px;} .af-form-wrapper{text-indent: 0;} .af-body input.submit, .af-body input.image, .af-form .af-element input.button{float:none!important;} .af-body input.submit{white-space: inherit;} .af-body input.text{width:100%; padding:2px!important;} .af-body .af-textWrap{text-align:left;} .af-element label{float:left; text-align:left;} .lbl-right .af-element label{text-align:right;} .af-quirksMode .af-element{padding-left: 0!important; padding-right: 0!important;} .af-body.af-standards input.submit{padding:4px 12px;} .af-body input.image{border:none!important;} .af-body input.text{float:none;} .af-element label{display:block; float:left;} .lastNameContainer { margin-top:10px; } .af-header,.af-footer { margin-bottom:0; margin-top:0; padding:10px; } body { }

Get Free Resources When You Subscribe to The Excel Lady newsletter

First Name:

Last Name:

Email:

Subscriber Counter

© 2023 All Rights Reserved

Website made with ♥ by Zebra Business Solutions