Tomorrow: Beginner's Guide to Microsoft Excel (2-part series)

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Beginner's Guide to Microsoft Excel (2-part series) November   1 1:00 PM - 2:40 PM ET & 3:00 PM - 4:40 PM ET 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   Beginner's Guide to Microsoft Excel: Part 1 November 1st, 2018, 1:00 PM to 2:40 PM, ET If you've never worked with Excel spreadsheets or haven't for several years, this webinar is for you. Excel expert David Ringstrom, CPA, takes you through the basics of Excel spreadsheets, so you'll be equipped to create functional spreadsheets and manipulate large lists of data. You'll learn about the different types of files you can create, Excel's rows and columns grid, and keyboard shortcuts that will help you simplify repetitive tasks. You'll also learn how to eliminate duplicates in a list, implement the Quick Analysis feature, manage column widths in spreadsheets, filter long lists of data, and more. Upon completion of this course, you'll be able to: Identify time-saving mouse tricks and keyboard shortcuts to skip confusing menus Apply the structural basics of Excel worksheets and workbooks List basic data-analysis techniques Control Excel's green error-checking prompts by managing the underlying rules Eliminate duplicates from a list with just a few mouse clicks Utilize free, prebuilt templates in Excel Identify the different types of files you can create in Excel Explain Excel's grid of rows and columns Describe how the Quick Analysis feature can Jump-start data visualization Recognize the nuances of copying formulas within Excel spreadsheets Manage column widths within your spreadsheets Master Excel's order of operations for mathematical formulas Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts Never type $ signs manually in a formula again; use a keyboard shortcut instead Create your own keyboard shortcuts to simplify repetitive tasks Enter dates in an Excel spreadsheet Use a custom number format to hide zero amounts within a specific area of a spreadsheet Wrangle long lists of data by filtering instead of sorting Beginner's Guide to Microsoft Excel: Part 2 November 1st, 2018, 3:00 PM to 4:40 PM, ET In this comprehensive presentation, Excel expert, David Ringstrom, CPA, expands on the information he covered in part 1 of this series. You'll see even more ways you can save time working in Excel with techniques such as with pivot tables, charts, and the Table feature. David will also bring you up to speed on ways to minimize data entry, identify duplicate entries, and much more. Upon course completion, you'll be able to: Swap out data within worksheet cells by way of the Replace feature Add fields to a blank pivot table to create instant reports Recover unsaved workbooks in Excel 2010 and later Create a pivot table to transform lists of data into on-screen reports Spell-check spreadsheets using a keyboard shortcut or menu command Use Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns Build a basic chart within an Excel worksheet Determine the pros and cons of merging cells in spreadsheets Identify whether it's safe to edit or delete a cell by way of the Trace Dependents feature Describe two different ways to insert or delete rows and columns within a worksheet Contrast Paste as Values with normal pasting in Excel Identify the location of the Remove Duplicates command within Excel's ribbon menu interface Identify the location of the PivotTable command within Excel's ribbon menu interface Recognize uses for pivot tables in Excel 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 The 1099 & W-9 Annual Update Course November 5 at 1 pm ET Learn More Detecting and Preventing Credit Card Frauds November 5 at 3 pm ET Learn More How to Keep Good Business Records and Avoid an IRS Audit November 6 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: Using Relevant Ratios as the Basis for Key Business Decisions

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Using Relevant Ratios as the Basis for Key Business Decisions October   31 1 pm - 2:15 pm ET Presenter: Carl Young, owner of Carl Young Consulting 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   All business professionals need a good working knowledge of financial statements to include how they are created and how they can be used to make key business decisions. Business and financial transactions are transformed into financial statements through an accounting process. Three required statements are produced: Income Statement Balance Sheet Cash Flow Statement The statements provide the "results" of business activity and not the "reasons". To sufficiently understand the reasons, you must look at relevant ratios. These ratios are standard indications of business reasons and serve as the basis for key business decisions. They are derived from a combination of calculations of components of the financial statements to indicate a unique and universally accepted metric or measurement. You can glean relevant indications of the company's success from these metrics. They become the "language" through which we can understand business activity and use them to analyze financial statements. You can also compare one company to another or one financial period to another. In this practical webinar, you will learn how to convert the results indicated on financial statements to the reasons needed to improve profits and productivity, providing a lens into the company to drive profitable change. Upon course completion, you will be able to: Determine how business and financial transactions are transformed into financial statements Identify key components of financial statements Describe blocks and key concepts used in creating statements Define the meaning and relevance of accrual basis accounting Define the meaning and relevance of finance and accounting Identify key components of ratios used in financial statement analysis, including: Comparison Trends Cash impact in all analysis Identify the five major categories of relevant rations: Profitability to measure gross and net profit Efficiency to measure productivity and utilization of resources Liquidity to measure ow well financial obligation are being met Solvency to measure debt encumbrances Cash- the key business success measurement Define ratio results and determine how to use them in making business decisions to improve profits and productivity Learn More Register Today About The Presenter   Carl Young is the owner of Carl Young Consulting, and is an author, speaker, trainer, consultant, and coach. He is a former CFO of a $275M, high growth technology-based company, former Senior Financial Associate of a major consulting firm, and former CEO of his own small parts manufacturing company. He has over 25 years of senior level business management, finance, and accounting experience. Mr. Young holds an MBA and has completed graduate studies in Accounting and 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,500 on-demand courses Learn More Upcoming Webinars The 1099 & W-9 Annual Update Course November 5 at 1 pm ET Learn More Detecting and Preventing Credit Card Frauds November 5 at 3 pm ET Learn More How to Keep Good Business Records and Avoid an IRS Audit November 6 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.