by ·0 Comments

Microsoft Excel’s CONVERT Function.


CONVERT Excel Function

          Microsoft Excel is one of those great software applications that empowers us to do a lot of different things. You can create art masterpieces , convert digital photos into pixel worksheets , create a cool animation , build a flight simulator , or play a game of Tetris . If you don’t feel ambitious enough to write pages upon pages of VBA code, but still want to do something practical with the program, perhaps you want to learn how to perform different conversion calculations in Excel? In fact, CONVERSION function enables you to convert weight, distance, time, pressure, force, energy, power magnetism, temperature, volume, liquid measure, area, information, and speed measures from one unit to another. The later version of Microsoft Excel you are running the more conversions you can perform. If you are working in Excel 2003 or earlier, this function is not available on earlier versions of Microsoft Excel.

Continue reading

by ·0 Comments

17 Excel Functions to use in 2017.


17 Excel Functions for 2017

          Versatility of Excel’s built-in functions is undeniably one of the main reasons behind this program’s popularity. As users, we have the flexibility to compose complex formulas incorporating multiple functions in our solution to achieve substantial gains in productivity. Most people have their own go-to Excel functions, be it: financial, date & time, math & trigonometry, statistics, look up & reference, database, text (manipulation), or logical. We’ve covered some of these functions already, but below is a compilation of 17 relatively under-used Excel functions you might want to add to your professional repertoire in the new year. Fair warning, you might need to have Office 365 version of Excel for all of the functions to work.

          1. PMT
          2. DATEDIF
          3. LARGE
          4. REPT
          5. LEN
          6. TRIM
          7. SUBSTITUTE
          8. TEXT
          9. IFS
          10. CONVERT
          11. NETWORKDAYS
          12. HLOOKUP
          13. INDIRECT
          14. OFFSET
          15. TRANSPOSE
          16. DSUM
          17. RAND
          BONUS: SUMPRODUCT

Continue reading

by ·0 Comments

Using Excel IFS and SWITCH functions.


Using Excel IFS and SWITCH Functions

          Making Rent vs. Buy decisions always seemed like a no-brainer to me. If you hold on to your purchase long enough, you will be saving money: be it a car or a computer software. Case in point: it costs only $ 109.99 to purchase a license for Excel 2016 vs $69.99/year to lease Office 365 Personal, which includes Excel, as well as other Office products. Assuming you only need to use one product that truly matters, and you will use it for more than 19 months, buying is cheaper than renting. The longer you use the product without upgrading, the more money you save. This held true until February of this year, when Microsoft introduced 6 new functions available exclusively to Office 365 subscribers: TEXTJOIN, CONCAT, IFS, SWITCH, MAXIFS and MINIFS. This addition alone, coupled with introduction of Funnel charts might steer more users towards the subscription model. In this post we will review the IFS and SWITCH functions. Let’s say goodbye to nested if functions , we have already discussed on this blog.
Continue reading

by ·0 Comments

Review of leading (mostly) free Web Marketing Certifications.


Web Marketing Certifications

          I spent the last few areas of my working life practicing the fine art of Web Analytics while supporting Digital Marketing efforts of my employers. As a typical analyst I try to think critically, and the most common feedback I get is that I need to think like a marketer , not an analyst (e.g. impressions are great for building a brand, even though they don’t directly result in any meaningful eCommerce activity). Sure, I’ve taken my share of Marketing courses in school and am familiar with all 4 P’s of Marketing , yet I felt that I still needed some concrete proof of my digital marketing acumen to establish a level of trust needed to implement my ideas. Hence I found myself researching top Digital Marketing certifications that hopefully wouldn’t break the bank. After careful consideration I set my eye on the following: Google Analytics (I suspect there is no need to introduce GAIQ ), Google AdWords (Between Paid Search, Display, Video, and Mobile, Google has the bases of most paid channels covered, while also introducing some SEO concepts in the process), HubSpot (HubSpot should be familiar to any Marketing professional, since they pioneered the idea of Inbound Marketing; among other certifications they offer Inbound, and Email Marketing certifications). Finally, the most crowded digital marketing channel is arguably Social Media; as a top player in the Social field, I was hoping that HootSuite certification is one of the most reputable of the bunch. With the only channel missing from this mix being Affiliates Marketing, I embarked on the journey of earning these certifications earlier this month. Okay, I must admit I should have probably sat for these certifications sooner, but better late than never, right?!

Continue reading