This past year has shown us the need for numerous projects and the need to manage those projects in a unique way. Project management is a way of thinking highly recognized and...
This course guides you through creating and opening PowerPoint presentations; inserting, reorganizing, and deleting slides; applying a design theme and switching between different...
Be the go-to person for financial statement preparation engagements. Specifically designed for preparation practitioners and their staff, this course will provide you with a hands...
This course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples, users are guided through the process...
Even for experienced Excel users, there is a learning curve to using formulas in Power Query (Excel version). This course presents the fundamentals of this concept. In addition...
This final course in the series covers advanced features in Power Query (Excel version), including functions and parameters and basics of data modeling in Power BI and Power Pivot...
This course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query, using the Excel...
This course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an "ETL" tool that extracts, transforms, and...
This course introduces users to the Power Query Editor, using the Excel version of Power Query, and includes a hands-on transformation exercise using the editor. Power Query is an...
This course teaches the user how to perform data transformations in Power Query, using a hands-on approach. Power Query is an "ETL" tool that extracts, transforms, and loads data...
Using a variety of hands-on exercises, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an "ETL" tool that extracts...
Power Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process, focusing on data cleaning...
The Florida Institute of Certified Public Accountants (FICPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.