2018 | The Excel Factor

Watch great videos on what’s new in the Excel world from Microsoft’s Ignite 2018 Seminar

Want to sit in on a world class Excel seminar? Microsoft has a fantastic seminar Microsoft Ignite for tech professionals including Excel Pros, the most recent was held just over a month ago in Orlando U.S. Sept 24-28 2018. You can view some really top class Excel sessions from this seminar here at this blog …

Watch great videos on what’s new in the Excel world from Microsoft’s Ignite 2018 Seminar Read More »

Kanban Tool for Excel project management

Productivity, Project Management

This blog is about a really great tool I discovered to use for client Excel work, called Kanban Tool. For significant projects, like anyone else, I need to plan how I should develop a spreadsheet and keep track of all the major bits of information like tasks, sub tasks, emails, links, snippets of code, what …

Kanban Tool for Excel project management Read More »

Finding Potential Pivot Table Collisions

Home Page Post, Uncategorized

Pivot Tables collisions or can be a real problem. A meeting is coming up in a few minutes and suddenly your beautifully crafted Pivot Table dashboard report that’s been working so well for months just doesn’t update and won’t tell you why or where the problem is.

Are guys really using Excel for this? Some weird Excel usage.

Excel uses

Talk about some weird Excel usage. I was enjoying my coffee this cold winter’s morning, reading my nerdy ipad edition of The Australian newspaper and there was this article! Read the first paragraph! No way! If there are men out there using my beloved Excel for that they bring all us Excel nerds down. Over …

Are guys really using Excel for this? Some weird Excel usage. Read More »

Macro to fix Duplicated Conditional Formatting rules in Tables

Conditional Formatting, Home Page Post, Macros, VBA

Following on from my recent post of Fix duplicated Conditional Formatting Rules , I mentioned Debra Dalgaleish’s website page had some great VBA to fix duplicated Conditional Formatting rules. I tweeked this code just a bit so that all you have to do is select anywhere in any Table in the active worksheet and it …

Macro to fix Duplicated Conditional Formatting rules in Tables Read More »

Alternatives to Conditional Formatting

Conditional Formatting, Formulas, Spreadsheet Design, Workbook performance

In my recent post of Fix duplicated Conditional Formatting Rules , I mentioned you should be careful using Conditional Formatting in situations where you have thousands of rows of data or calculations as this can be a drain on performance. I also mentioned you can use alternatives in these situations and just thought I would …

Alternatives to Conditional Formatting Read More »

Fix duplicated Conditional Formatting Rules

Conditional Formatting, Spreadsheet Design

Have you ever been confronted by the duplicated, fragmented and almighty mess your conditional formatting (CF) rules can get into? This is what I mean by the term duplicated Conditional Formatting Rules. I hope the following post helps you. Basically this situation arises as you go about day to day coping and pasting into a …

Fix duplicated Conditional Formatting Rules Read More »

Use the macro recorder for VBA code for a relative formula

Formulas, VBA

I did this very thing today, so thought I would share this tip with you as it saved me a lot of time. Say you wanted to have this formula go into column 8 of the range you created in VBA for the number of dynamic rows you extracted using Advanced Filter. =CHOOSE( OR(C6={“EL”,”IL”})*1+(C6=”MT”)*2+OR(C6={“IP”,”EP”})*3+(C6=”SC”)*4+(C6=”AD”)*5, “Labour”,”Materials”,”Plant”,”SubContract”,”Overheads”) …

Use the macro recorder for VBA code for a relative formula Read More »

Using a Table Name prefix for productivity

Excel Habits, Formulas, Tables

A few years ago I picked up on a gem of a tip from Dick Kusleika from his then blog Daily Dose of Excel, on using the Table Name prefix of “tbl”. This site seems to have stopped sadly for Excel nerds, I am not sure if that is temporary or for good, but it …

Using a Table Name prefix for productivity Read More »

My First PowerApp

Data accessibility, PowerApps

I talk a lot about Excel automation. Automating with Excel helps us be more productive and efficient in our jobs. Automating tedious tasks using advanced Excel features like Tables, Pivot Tables, Power Query, VBA or macros. The benefits are many – less stress, more time and better mindset for your private live and the more …

My First PowerApp Read More »

Year: 2018