Tomorrow: 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) February   1-2 1 pm - 2:40 pm ET each day Presenter: David Ringstrom, CPA, Owner and Founder of Accounting Advisors, Inc. 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   Excel Dashboards: Part 1 February 1st, 2017, 1:00 PM to 2:40 PM, ET Dashboards empower users to quickly assimilate large amounts of data into spreadsheets by way of pivot tables, charts, and other Excel features. In Part 1 of this two-part webinar series, you'll learn about Excel dashboards and several Excel features that will help you summarize and present your data in an efficient manner. Upon completion of this course, you'll 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 Create self-updating links to databases, spreadsheets, text files, and other data sources Use the Recommended PivotTables feature Use the Recommended Charts feature in Excel 2013 and later Use Excel's Custom Views feature to make a single set of data serve multiple purposes Switch between Custom Views by way of a hidden drop-down list—and much more Apply the Custom Views feature in Excel to have a single worksheet present data in multiple summary and/or detail formats Establish persistent links to data files exported from your accounting software using Excel's From Text feature Jump-start data visualization with the Quick Analysis feature Learn which features, such as Custom Views, you can't use when one or more tables exist in a workbook Use the Group and Ungroup feature to expand or collapse rows and/or columns Excel Dashboards: Part 2 February 2nd, 2017, 1:00 PM to 2:40 PM, ET In Part 2 of this two-part webinar series, you'll learn how to use pivot tables, pivot charts, sparklines, slicers, and other Excel features to present data in summary form while maintaining easy access to the underlying details. Upon completion of this course, you'll be able to: Identify ways to use Excel dashboards to quickly assimilate large amounts of data Define how to create dynamic and interactive graphs with Excel's PivotChart feature Apply the Slicer feature in Excel 2010 and later to filter data faster, streamline data analysis within tables and pivot tables, and control multiple pivot tables and charts instantly Create a dashboard that looks less like an Excel spreadsheet by hiding screen elements Create self-updating titles for charts and pivot charts Differentiate pivot tables from worksheet formulas and learn the importance of the Refresh command Filter pivot table data based on date ranges by way of the Timeline feature in Excel 2013 and later Hide and unhide Excel's Ribbon interface using a simple macro technique Recognize why certain features, including slicers, sparklines, and charts, are disabled in some workbooks Create tiny, in-cell charts to show trends of data using the Sparkline feature Use Excel's PivotTable feature to condense large amounts of information into manageable chunks Use the Linked Picture feature to place pivot tables in close proximity to each other without posing conflicts David typically demonstrates techniques from the version of Excel used by the majority of attendees. This means he uses Excel 2010, 2013, or 2016 to demonstrate techniques, but his detailed handouts identify differences in Excel 2007, 2010, 2013, and 2016 when needed. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants' questions, so come ready to pick his brain. David's detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes most of the examples he uses during the webcast. 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,000 on-demand courses Learn More Upcoming Webinars Accounting Manager's Guide to Difficult Conversations: How to Face and Grow from Them February 3 at 1 pm ET Learn More Excel's Custom Views Feature February 7 at 1 pm ET Learn More Internal Controls in Accounts Payable February 8 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.

Tomorrow: Understanding & Analyzing Financial Statements

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Understanding & Analyzing Financial Statements January   31 1 pm - 2:15 pm ET Presenter: Carl Young, Owner of Carl Young Consulting Credits: CPE, HRCI, 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 Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   The financial health of a company is indicated in the three required financial statements: Balance Sheet Income Statement Cash Flow Statement This webinar provides an interactive look at these statements and provides simple tools and techniques for understanding & analyzing these statements as the foundation for making key business decisions.  Upon completion of this course, you will be able to: List the core components of financial statements Differentiate between cash and accrual basis accounting Define key accounting concepts, including: Working Capital Cash Management Free Cash Flow Analyze financial statements Identify simple financial statement terminology Recognize signs of business financial health and red flags Utilize relevant ratios to improve profits and productivity Explain the role of ratios, trends, comparisons and cash in business analysis and decisions Essential categories of ratios, including: Profitability Efficiency Liquidity Solvency Cash Course Reviews from Past Attendees 100% of attendees said they would recommend this course to others. "Very easy to understand. Good use of visuals, examples." "I liked the presenter's clarity, public speaking skills, and his ability to distill complex concepts down to useful and usable knowledge." "Carl used great real life examples to help understand the financial statements better and also explained the differently terminologies which he said all mean the same but it always threw me off prior to this session. Thank you." "The presenter was very thorough on the topics." Learn More Register Today About The Presenter   Carl Young is the owner of Carl Young Consulting, where he works as a Speaker, Trainer, Consultant and Business Coach. Mr. Young is the former CFO of a $275M high growth technology company and the CEO of a machine parts manufacturing company Mr. Young has published numerous books on finance and accounting, Carl Young's Rules of the Business Game, Finance and Accounting Made Simple, Rules and Tools for Thriving in Chaotic Times, and a handbook on Small Business Management Made Simple. Mr. Young earned his MBA and completed graduate studies in Accounting & Taxation. 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,000 on-demand courses Learn More Upcoming Webinars Accounting Manager's Guide to Difficult Conversations: How to Face and Grow from Them February 3 at 1 pm ET Learn More Excel's Custom Views Feature February 7 at 1 pm ET Learn More Internal Controls in Accounts Payable February 8 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.