Extensive prior tax preparation experience/knowledge is required. This course will give you the confidence to take on more complex and specialized tax situations. Students normally enroll in this course after completing the 60-hour Comprehensive Income Tax Course (Basic and Intermediate Course), the Advanced Individual Income Tax Course and working at least two seasons as a tax preparer. This course is also suitable for a veteran preparer who needs to refresh his/her skills. If you are an enrolled agent, accountant, lawyer, financial planner, business owner, experienced tax preparer, or just interested in increasing your tax knowledge, the Advanced Level !! Course will enable you to become a specialist in helping certain segments of taxpayers with more complex tax situations. This course provides the critical education and knowledge which make the graduates more competent and successful than their competitors. This course is designed to enhance the knowledge and experience of tax practitioners. Interactive self study classes are eligible for 30 hours of CPE
This Advanced Access 2016 training class is for students who intend to design databases at an advanced level and/or want to improve existing Access databases.
Target Audience: Students who have basic skills with Microsoft Access 2016 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2016 interface.
Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll do just that.
You'll see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. As you become proficient, you'll be able to accomplish just about anything Microsoft Excel has to offer!
Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed Microsoft Excel training, you'll see how to truly maximize this program's functions and capabilities. After all, most organizations rely heavily on Excel to consolidate, analyze, and report data and want their employees to be proficient in this important program. This Excel training class gives you the skills you need to impress your current or future employer—and its online format means you can take this class from anywhere, at any time.
With exercises, quizzes, expert instructors, and all the latest information, the best online Excel training is right here at ed2go. We’ll simplify some of those tricky Excel concepts that might seem hard to grasp, so you can discover how Excel 2016 table tools actually take the complexity out of spreadsheet creation and management. When you’ve completed this course, you'll be able to accomplish just about everything Microsoft Excel has to offer in displaying, analyzing, reporting, and tracking data—and you’ll understand it so well, you’ll even be able to share your newfound skills with your friends and colleagues.
This Advanced Microsoft Excel 2016 training class is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Target Audience: Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.
Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data. Your company is probably no exception. If you work with data of any kind, learning Excel's advanced functions to taking on greater responsibilities in your organization.
This course will help you master many features in Microsoft Excel 2019/Office 365 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019/Office 365 and will be able to better serve your company's data management needs.