Excel Dashboards (2-part series)

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Excel Dashboards (2-part series) March   14-15 1 pm - 2:40 pm ET each day Presenter: David Ringstrom, an author and nationally recognized instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   In this 2-part webinar, you will learn how to summarize and present Excel dashboards from Excel expert, David Ringstrom, CPA. Excel Dashboards: Part 1 March 14th, 2019, 1:00 PM to 2:40 PM, ET In Part 1 of this comprehensive 2-part webinar, Excel expert, David H. Ringstrom, CPA, introduces you to Excel dashboards. Dashboards empower you to quickly assimilate large amounts of data into spreadsheets by way of pivot tables, charts, and other Excel features, including the PivotTable feature, PivotChart feature, Quick Analysis feature, and others. After this practical webinar, you'll be equipped to summarize and present your data in an efficient manner. You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. You will identify differences in Excel 2016, 2013, or 2010 and will receive detailed handouts. You will also receive an Excel workbook that includes the examples presented during the webinar. You will learn how to: Filter two or more pivot tables simultaneously by way of the Slicer feature in Excel 2010 and later Add new data sources to Microsoft Excel so you can extract data from text files, accounting software, and other data sources Prevent pivot tables from automatically resizing columns when you refresh or filter the data Link data from text files to Excel spreadsheets by way of Microsoft Query Determine which refresh commands in Excel update a single pivot table versus all pivot tables in a workbook Create self-updating links to databases, spreadsheets, text files, and other data sources using Microsoft Query Minimize visual clutter by hiding worksheet gridlines Assemble a dashboard from multiple pivot tables Add interactivity to pivot tables by using the Slicer feature for filtering in Excel 2010 and later Duplicate Excel worksheets in two different ways Upon course completion, you will be able to: Identify ways to use Excel dashboards to quickly assimilate large amounts of data Use Microsoft Query to create persistent connections to data you wish to present in a dashboard Apply a variety of features that will help you summarize and present your data with ease Excel Dashboards: Part 2 March 15th, 2019, 1:00 PM to 2:40 PM, ET In Part 2 of Excel Dashboards, you will learn how to reap the benefits of using dashboards from Excel expert, David Ringstrom, CPA. In this practical webinar, you will learn how to use pivot tables, pivot charts, sparklines, slicers, and other features that allow you to present data in summary form, while still giving you easy access to the underlying details. You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. You will identify differences in Excel 2016, 2013, or 2010 and will receive detailed handouts. You will also receive an Excel workbook that includes the examples presented during the webinar. You will learn how to: Use linked pictures as a navigation tool to return to the source pivot table Amend queries exported from Microsoft Query Recognize the conflict that a linked picture overlaying a slicer can pose Create self-updating chart titles that change automatically as you filter or slice data related to the chart Navigate past the "PivotTable field name already exists" prompt once and for all Jump-start data visualization with the Quick Analysis feature Hide or reveal Excel's Ribbon interface using a simple macro technique Streamline filtering of lists in Excel 2013 and later by using the Slicer feature with tables Utilize the Timeline feature in Excel 2013 and later to filter pivot tables based on date ranges Use the Group command to interactively hide/unhide columns (and/or rows) within Excel worksheets Upon course completion, you will be able to: Identify which versions of Excel permit using slicers with both tables and pivot tables Identify the key you hold down to select two or more nonadjacent columns or rows State the Excel feature that the Table feature disables within a given workbook Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars Recruiting Top Talent from College Campuses March 25 at 1 pm ET Learn More Avoiding FLSA Overtime Claims for After-Hours Use of Smartphones and Other Electronic Devices March 25 at 3 pm ET Learn More TIN Solicitation Best Practices March 26 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.

How to Become a Leader in Your Management Position

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser How to Become a Leader in Your Management Position March   11 3 pm - 4:40 pm ET Presenter: Candace Leuck, President of Athena Finance Group Credits: CPE, HRCI, and SHRM (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   There is a simple, but powerful, model for how leaders succeed. In this practical webinar, you will learn how to be a leader who demonstrates courage, sacrifice, and care for the group. You will learn how to develop the skills to inspire action and help build an organizational culture in which we all go home feeling fulfilled by our work. You will determine how to bring empathy and perspective into your organizations - two attributes that every leader should take the opportunity to develop and maintain. Upon course completion, you will be able to: Display the attributes of good leadership to your group Provide a safe workplace environment Develop responsibility and accountability with your team Distinguish between leadership and authority Set the tone for success in your domain Determine the cost of leadership and the benefit of good leadership to the team Assess the team you want to join and lead Learn More Register Today About The Presenter   Candace Leuck, CPA, is the President of Athena Finance Group and a member of the AICPA. Ms. Leuck is also a lecturer at Clemson University's School of Accountancy and Legal Studies. Ms. Leuck earned her Master of Professional Accountancy (Audit Emphasis) from Clemson University. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars Creating an Effective and Efficient Travel and Entertainment Expense Reimbursement Policy March 12 at 1 pm ET Learn More Trial Director 101 March 13 at 1 pm ET Learn More Taxing Policies and Rules for Sales and Use Tax March 18 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.