Accounting and Finance Business Productivity Bundle
Boost your efficiency with expert-led courses in accounting and business tools with this great-value 7-course bundle.
4.65 (31 reviews)
345
students
25 hours
content
Sep 2024
last update
$44.99
regular price
What you will learn
Navigate and format data in Excel efficiently and grasp Excel formulas and functions.
Import and deduplicate files using advanced functions like XLOOKUP.
Record journal entries for assets, expenses, income, and liabilities.
Link accounts in QuickBooks Online, ensuring consistently updated records.
Prepare a trial balance and pass adjusting entries at the end of an accounting period.
The basics of financial modeling and forecasting using Excel.
The purpose of financial forecasting and how to build a sound financial model.
How to go through the three financial statements (balance sheet, income statement, and cash flow statement).
How to define your forecasting objectives and identifying key variables and drivers.
Analyzing financial forecasts using ratio analysis and future trends in forecasting.
Distinguish between risk management and risk measurement.
Describe risk budgeting and understand its role in risk governance.
Define, classify, and distinguish between financial risks.
Distinguish between risk prevention and avoidance.
Define and apply the concepts of self-insurance, risk shifting, and risk transfer.
Understand and apply Excel formulas and functions.
Sort data and apply filters, including advanced filtering techniques.
Work with Excel charts, including clustered columns, line graphs, and waterfalls.
Utilize database functions created specifically to work with large datasets.
Understand and use the What-If Analysis toolkit which includes the Scenario Manager, Goal Seek, and Data Table functions.
Use the Analysis ToolPak to calculate basic statistical concepts such as correlation and covariance.
Explain the evolution and impact of AI in finance.
Design financial statements using Syft Analytics and create polished proposals and presentations using Tome.
Simplify accounting processes with SaasAnt Transactions.
Utilize AI for advanced spreadsheet functions and problem-solving.
Set up and customize chart of accounts using ChatGPT.
Optimize inventory management with ChatGPT tools and utilize ChatGPT for efficient tax compliance and planning.
Automate accounts receivable and payable processes with ChatGPT.
Conduct AI-powered audit planning and risk assessments.
Integrate ChatGPT to create and project financial statements efficiently.
Build and analyze common size income statements using AI for better insights.
Automate financial ratio calculations and improve analysis with ChatGPT.
Use ChatGPT to perform scenario analysis and sensitivity testing for forecasts.
Apply AI to advanced financial modelling techniques like Altman’s Z-score and DuPont analysis.
6191847
udemy ID
9/19/2024
course created date
10/5/2024
course indexed date
Bot
course submited by