{"id":586,"date":"2021-11-18T09:00:00","date_gmt":"2021-11-18T14:00:00","guid":{"rendered":"https:\/\/figartconsulting.com\/wordpress\/?p=586"},"modified":"2021-11-18T13:00:16","modified_gmt":"2021-11-18T18:00:16","slug":"multivalued-nested-ifs-and-other-advanced-excel-fun","status":"publish","type":"post","link":"https:\/\/figartconsulting.com\/wordpress\/2021\/11\/18\/multivalued-nested-ifs-and-other-advanced-excel-fun\/","title":{"rendered":"Multivalued Nested IFs and Other Advanced Excel Fun"},"content":{"rendered":"\n

“We have 8,000 computers to upgrade the operating system. Some of them aren’t licensed for it and will just need to be replaced. Some of them haven’t touched the network and we need to find them. Others? Well, we need to group them by department to upgrade. Oh, since a lot of them are laptops that won’t be on a network fast enough to push the new OS to them, we’re going to need to chase them down and bring them in to User Support to upgrade.”<\/p>\n\n\n\n

Could I have kept track of this list and evaluated it using Python or something?<\/p>\n\n\n\n

Well, no. I didn’t know Python at the time!<\/p>\n\n\n\n

What about SQL? Well, yeah, but no one in the office was using that tool for such a small list.<\/p>\n\n\n\n

Can Excel handle it?<\/p>\n\n\n\n

At only 8,000 entries? You bet it can!<\/p>\n\n\n\n

I created a table with a single-line 13-value nested formula that would evaluate the many criteria needed to track the OS upgrade process.<\/p>\n\n\n\n

I even made a dashboard from it for a boss who was really into visual trackers.*<\/p>\n\n\n\n

You can learn what I did and how I did it in Session One. This is flat-out my favorite session of Excel to teach. Don’t laugh at me for loving this. I can’t help it.<\/p>\n\n\n\n

But maybe you’ll have fun with this, too. C’mon, you know you wanna\u2026<\/p>\n\n\n\n

\n
Yes, please! Sign Me Up!<\/a><\/div>\n<\/div>\n\n\n\n

Excel Advanced<\/h2>\n\n\n\n

This will be a six-week course starting:<\/p>\n\n\n\n

Thursday, January 6, 2022<\/p>\n\n\n\n

7:00-8:00 pm EST<\/p>\n\n\n\n

* PivotTables and PivotCharts won’t be until Session Four<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

“We have 8,000 computers to upgrade the operating system. Some of them aren’t licensed for it and will just need to be replaced. Some of them haven’t touched the network and we need to find them. Others? Well, we need to group them by department to upgrade. Oh, since a lot of them are laptops … <\/p>\n

Continue reading “Multivalued Nested IFs and Other Advanced Excel Fun”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14],"tags":[],"class_list":["post-586","post","type-post","status-publish","format-standard","hentry","category-computer-instruction"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pLg3p-9s","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":7,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/586\/revisions"}],"predecessor-version":[{"id":621,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/posts\/586\/revisions\/621"}],"wp:attachment":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/media?parent=586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/categories?post=586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/tags?post=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}