Posts

Showing posts from April, 2018

Excel Finesse: Going Beyond VLOOKUP to Master Functions

Image
IjonaSkills   -  IT Webinars Overview After participating in this informative webcast presented by Excel expert David Ringstrom, CPA, you'll have the skills needed to go beyond Excel's VLOOKUP function to master complicated formulas. VLOOKUP is the function many Excel users rely on to return data from other locations in a worksheet; however, utilizing VLOOKUP isn't always the most efficient approach. David shares helpful tweaks you can implement with the revered VLOOKUP function and explains several alternatives, including the INDEX and MATCH, SUMIF, SUMIFS, IFNA, and IFERROR functions. Why should you attend? Practitioners who may benefit from working more efficiently in Excel by utilizing lookup functions. David will demonstrate every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He'll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his det

HR Executive as a Business Partner

Image
Overview Participants will learn how to become a proactive member of the management team. They will learn how align themselves with operations, marketing, finance, and sales and contribute to the organization's success at the same level as these other disciplines.The webinar will discuss the use of data base metrics for human resources and people ........ Why should you attend? To be viewed as a leader, HR professionals must thoroughly understand their company's business objectives, financial metrics, goals and objectives and align their people practices. For years HR has discussed getting a seat at the table. The reason that many don't have that seat is that they do not add value to the organization. True, they may prevent problems but they are not proactive business partners and success builders. This is perhaps why CEOs have come from finance and marketing but rarely from HR. In order to be a valued business partner you must understand the language of business