20CF-MBAC: CANCELLED: MNCPA Management & Business Advisers Conference (MBAC20)
H4. Power Query and Power Pivot
Speaker:
Jeff Lenning
Wed, 9:10 am - 10:25 am
Excel users have prepared reports the same way for decades: Export data from an accounting system, copy and paste it into an Excel workbook, clean and prepare it for use and then use PivotTables and functions such as VLOOKUP and SUMIFS. But that workflow is manual and slow. Learn about the power tools Excel now offers to streamline your reporting process. Explore the use of Power Query and Power Pivot to improve your reporting tasks.
NASBA field of study: Computer Software & Applications - Non-Technical (1.5)
Advanced search
View all CPE programs
Conference sponsorships
Reach CPAs by becoming a sponsor
Strengthen your brand recognition with a targeted buyer group – CPAs and accounting professionals. You'll interact one-on-one with informed, affluent customers.