Courses

This 57-minute tutorial teaches you how to build an Accountant Excel Toolkit with a focus on Trial Balance and General Ledger management. Learn to create and maintain a precise trial balance for verifying account balances before generating financial statements, and organize your general ledger to effectively track all transactions. The comprehensive guide covers General Ledger overview, recording transactions, linking with QuickBooks Online, balancing the Trial Balance, performing accuracy checks, making adjusting entries, and includes a practical exercise. Free downloadable course files are available to follow along with the instruction provided by Simon Sez IT.

Learn how to enhance accounting workflows in this 10-minute tutorial that demonstrates the process of linking QuickBooks Online with Excel for efficient General Ledger management. Master the techniques for seamlessly integrating financial data between platforms, enabling streamlined reporting processes and improved data management for accounting and finance professionals. Discover practical methods for exporting, importing, and synchronizing General Ledger entries while maintaining data accuracy and consistency across both systems.

F1 is the first module among fourteen ACCA( The Association of Chartered Certified Accountants ) international exams. Its aim is to develop the understanding of accounting and the environment of the organization. There are diversified topics in F1,including organization, corporate governance, macroeconomics and microeconomics, the role of accounting and auditing, and human resource management. It is the foundation of all the other ACCA modules.

Become a better accountant with the power of Microsoft Excel. Learn how to use it for general ledger entry, forecasting, business valuation, interacting with QuickBooks, and more.

Learn the basics of accounting for balancing business finances, so you can feel confident in contributing to business decisions.

Learn to calculate and interpret essential financial ratios in Excel with this 19-minute tutorial designed for accountants and finance professionals. Master the techniques for analyzing liquidity ratios, profitability ratios, and leverage ratios to gain valuable insights into a company's financial health, operational efficiency, and overall performance. Develop the skills to conduct comprehensive financial assessments that inform strategic business decisions and enhance financial reporting capabilities.

Improve your Business English for Accounting What you'll learn: English language skills necessary for accountantsDiscuss numbers and moneyStrategies and language for key business communication functions, such as giving advice or asking for an opinionReport past results and forecast future resultsDescribe financial changes in your companyExplain financial concepts to non accountants Are you an accountant or financial professional learning English? Join us to improve your language and communication skills for success at work. This course has helped hundreds of international financial professionals around the world improve their communication skills. Now it’s your turn! This course is for English language learners in the accounting and finance profession. You will develop the communication skills required for success in the industry. Here are some of the things you will do in this course:· Build English language skills required for successful communication.· Learn functional language for common tasks in the accounting profession.· Develop strategies for communicating with co-workers and non-accounting departments.· Strengthen your business writing.· Build speaking skills you can use in the English-speaking workplace. Do these challenges sound familiar to you?· "It's difficult to explain my ideas or I can't think of the right thing to say."· "I feel nervous in meetings, conversations, and presentations."· "It's challenging to explain financial concepts to others."· "My English language and communication skills are preventing me from getting a promotion!" Don't let your English hold you back at work! Your technical skills are strong, but your communication is holding you back from a raise, promotion, or new job. That's where this course can help! Who is this course for?Accountants and financial professionals learning English will benefit from this course. This includes internationally trained professionals working in English speaking countries, like the USA, Canada, or England. It also includes professionals around the world using English to communicate with international clients and co-workers. Apart from international accountants, anyone building English skills and using finance can benefit from this course. That includes business and economics students, business owners, managers, business analysts, and many more people. If you talk about numbers and money at work, this course will help you.When you finish this course, you will have the language skills and confidence you need to use English at work. This improved communication can lead to a raise, promotion, or even a new job! Here are some of the specific language and communication skills you will learn in this course: · Discussing numbers and money· Reporting past results and forecasting future results· Describing financial changes in your company· Explaining financial concepts to non accountants· Using accounting and financial vocabulary and terminology· Giving advice, opinions, and requests in the workplace· Explaining a process and give instructions You will also develop business communication skills valuable for anyone working in an office environment. Register today to begin your journey to better communication and more confidence at work. Like all courses on Udemy, this course is completely risk free. You get complete satisfaction or your money back!

A tutorial on how to do Basic Tax Preparation What you'll learn: Learn how to organize for tax preparations. Includes lists, guidelines for preparer and file structure. A quick overview of the documents needed and how to organize them to be efficient in work.Learn 21 Accounting fundamentals in ExcelHow to format excel for printing to PDF or paperLean how to do basic tax groupingsLearn how to prepare basic Schedule CLearn how to use pivot tables and Sum IF function to create a profit and loss statement Work Paper organization is a first step to preparing quality tax and accounting and this course teaches the process. Also get to improve your excel skills along the way. Work papers summarize, explain, calculate, and reference to tax filings and to the source of the glorious information. Better work papers... Better work quality... Better clients... And better pay. I frequently get asked how to break into a CPA firm or get a better accounting job.This course is a step to make the bridge between academics and making some money in a better position. This not only helps aspiring staff but owners looking to handle more complex work at scale. We will focus on tax, as this is most applicable to smaller firms like mine and tax is a great way to break into the profession. Organizing segments otherwise overwhelming jobs into small tasks and makes the seemingly daunting project manageable. This field to some extent is a methodology of financial organization, so let me show you what goes on behind the scenes of the numbers. I am John Gillingham CPA, founder of Accounting Play where we use apps and courses to teach real world accounting, tax and, bookkeeping skills. This course is inspired from my need to teach my own staff and is a culmination of over a decade of experience. The course also comes with valuable downloads to enhance the traditional lessons. Join me in taking this important step for your education and career. Be sure to checkout the other Accounting Play apps and courses and leave feedback. It is greatly appreciated.

Learn to enhance your asset management capabilities in this 10-minute tutorial on Accounting for Assets in Excel, part of the Accountant Excel Toolkit series from Simon Sez IT. Designed specifically for accountants and finance professionals, master effective techniques for tracking and managing company assets using Excel's powerful features. Gain practical skills that can be immediately applied to improve your financial reporting and asset management workflows.

Learn interview tips for accountants from a seasoned financial professional.

Explore a comprehensive lecture on the Saddle-Point Accountant for Differential Privacy presented by Oliver Kosut from Arizona State University. Delve into advanced information-theoretic methods for trustworthy machine learning, focusing on the innovative approach of using saddle-point techniques to enhance privacy protection in data analysis. Gain insights into the latest developments in differential privacy and their applications in creating more secure and reliable machine learning systems.

Learn all the basic to advanced accounting concepts to ace the interview, pass the exam, or be a smarter entrepreneur! What you'll learn: Record Journal EntriesBuild General Ledger, Balance Sheet, Income Statement Comprehend the connection between General Ledger and main financial statements Do you want to work in finance but do not have the time and money to enroll in an MBA? Continue reading… Instructor Bio: "Gennaro Cuofano matured international experience for over Ten years between Europe and US. After graduating from Law School, he worked for a while in the legal field. His passion for finance and international business brought him to become an International MBA, with concentration in Corporate Finance. Course Summary: Did you know that when you read you just retain 10% of the information?What is the best way to retain information then?Numerous researches showed that when you put in practice what you just learned 75% of the information is retained in the long-term. For such reason this course has been structured around the “case study methodology." The same used in Business Schools. If you are a newbie willing to learn the inside out of accounting in the most effective way, join “The Udemy Accounting Case Study". You will learn:How to record Journal Entries How To build a General Ledger, Balance Sheet, Income Statement How all the main financial statements are intertwined Build the foundation that will lead to a successful career in finance A deeper understanding of the above topics will make your life much easier as financial analyst.Content and OverviewSuitable for students who want to become financial analysts or undertake a career in finance, you will get the following benefits:Become extremely knowledgable about accounting, financial statements and ratio analysis. Build a strong theoretical and practical foundation of the discipline. This will give you an invaluable edge over your competition. Many "know-how" of things but few know "why." Become invaluable for your organization. How? Extra Exercises and over Ten Quizzes! The E-Book "The Accounting Guide."Excel Spreadsheets to practice what you learned!The knowledge acquired in over 10 years of experience in the financial world is distilled in few hours. Indeed, Gennaro Cuofano, your instructor, managed a team within the accounting and finance department of an Investment Firm, based in California. There, he learned how accountants communicate. Now he wants to share his knowledge with you!In addition, together with the over ten case studies and quizzes you will learn how to build your financials using excel. Follow the learning process that will give you access to years of practical and theoretical information. Indeed, in addition to the practical material you will have free access to the theoretical course "How to become a financial analyst from scratch". “You have to understand accounting and you have to understand the nuances of accounting. It's the language of business and it's an imperfect language. “Unless you are willing to put in the effort to learn accounting – how to read and interpret financial statements – you really shouldn't select stocks yourself" Warren BuffetGet ready for this exiting journey!

Automate reporting tasks with a mapping table What you'll learn: Store data in tables so that new rows are automatically included in related formulasPerform conditional summing with the SUMIFS functionCreate an intermediate mapping table so that Excel has the information needed to translate labels and aggregate data rows In this course, author and award-winning instructor Jeff Lenning CPA demonstrates the technique featured in his Journal of Accountancy article The Power of Mapping Tables. If you use Microsoft Excel to generate reports, this course is for you. We discuss the benefits of storing source data in tables, how to use the SUMIFS function to conditionally sum transactions, and how to translate labels with a mapping table. Microsoft introduced tables in Excel 2007, and this feature is a game-changer. If you do not store your data in tables, you are missing out on a simple way to improve the reliability of your workbooks. Converting an ordinary range into a table provides many special benefits, and we'll discuss these special properties in the course. Also with the roll-out of Excel 2007, Microsoft introduced a new worksheet function: SUMIFS. This too is a game-changer. Performing multiple-condition summing in earlier versions of Excel was challenging, and required clever functions such as SUMPRODUCT or array formulas. For many workbooks, these can be replaced with the SUMIFS function. We'll discuss the function's arguments and demonstrate several practical applications. Excel reports often aggregate data. Frequently, the data labels are different than the report labels. For example, the accounting system may export account names, such as Cash or Savings, but the corresponding report labels are financial statement items, such as Cash and Cash Equivalents. When the labels are different, we are prevented from using lookup functions such as VLOOKUP to retrieve values. In this course, we'll demonstrate the mapping table technique which enables our reports to retrieve values from data tables, even when the labels are different. The course includes practice Excel files, corresponding answers files, and a solutions video. The course is structured by topic, and within each topic, there is a PowerPoint discussion, a lecture video that works through the item in Microsoft Excel 2013 for Windows, and sample exercises for you to work hands-on. If you use Excel to create reports, this course will help you prepare them more quickly.

Accountants perform a wide variety of activities which include, but are not limited to, accounting, auditing, tax, management consulting, and financial management. However, a professional accountant’s responsibility is not exclusively to satisfy the needs of an employer or professional services client. One of the distinguishing characteristics of the accounting profession is its acceptance of the responsibility to act in the public interest. This course will introduce you to professional guidance that enables accountants to uphold the obligation to act in the public interest while meeting their professional responsibilities to employers and clients. You will also learn foundational knowledge of the moral dimensions of business that are helpful for recognizing and interpreting the ethical issues embedded in situations you will encounter in your career. Topics in the course include professional standards, values and norms, ethical theories, theories of a firm and business purpose, and corporate governance.

The objective of this course is to provide you with the knowledge and skills necessary to analyze, interpret, understand and use financial information to make informed decisions. We will discuss financial reporting from a user’s perspective, use a variety of tools to break apart financial reports into meaningful units for analysis, forecast financial statements, and value a firm. This course is intended to give you exposure to the issues facing users of financial statements. You will better understand your role in the financial reporting process if you know how the financial statements will ultimately be used. Beyond the Financials: Insights, Analysis and Valuations will require you to think critically about issues for which there can be more than one “correct” answer. Hence, your analysis and conclusions must be based on sound assumptions and well-constructed analysis and arguments.

Prepare to pass the Certified Public Accountant (CPA) Exam with this comprehensive, rigorous, and easy-to-understand study guide course. With help available 24/7, work on the course at your own pace and time.

This convenient online course helps you prepare for the Certified Management Accountant (CMA) exam. It contains informative lessons that address all the accounting topics on the exam, as well as self-assessments that you can use to check your understanding of important CMA exam concepts.

Learn Accounting to Boost your career, pass an exam, be a screwed entrepreneur! What you'll learn: Learn About GAAP Learn About Double-Entry Make your First Journal EntryLearn About the Main Financial Statements Learn About Internal Accounting Procedures&ProcessesAssess your level of understanding with final Quiz and Exercises Since 1494 when Luca Pacioli, for the first time, described the Double Entry System, the world has never been the same. Ever since Accounting became the language of business. Therefore, like when you go to a foreign country the first thing you do is to learn their spoken language. Before you can deeply understand business you must understand how accounting works. From this course you can expect to deeply understand basic accounting concepts such us: GAAP Double-Entry (how to make journal entries)General Ledger Accounting Procedures and Processes Main financial Statements (Balance Sheet and Income StatementHow? Intuitive E-Learning through white board methodFree Exercises Final QuizExtra SlideseBook "Awaken The Accountant in You!"About the Instructor: Gennaro Cuofano matured international experience for over Ten years between Europe and US. After graduating from Law School, he worked for a while in the legal field. His passion for finance and international business brought him to become an International MBA, with concentration in Corporate Finance. After completing his MBA in Italy, at Luiss Business School; he flew to California, where he completed the International MBA at University of San Diego, California. There, he had the chance to attend Corporate Finance courses held by Thomas Copeland, former head of the Corporate Finance Practice at McKinsey.

Are you an accountant seeking to add a professional, respected designation to your name? If so, then you can use this study guide to help you review principles and strategies you would need to know when take the Chartered Global Management Accountant (CGMA) exam.

The objective of Financial Statement and Ratio Analysis for MBAs is to provide you with the knowledge and skills necessary to analyze, interpret, understand, and use financial information to make informed decisions. We will discuss financial reporting from a user’s perspective, use a variety of tools to break apart financial reports into meaningful units for analysis, forecast financial statements, and value a firm. This course is intended to give you exposure to the issues facing users of financial statements. You will better understand your role in the financial reporting process if you know how the financial statements will ultimately be used. Financial Statement and Ratio Analysis for MBAs will require you to think critically about issues for which there can be more than one “correct” answer. Hence, your analysis and conclusions must be based on sound assumptions and well-constructed analysis and arguments.