CPE & Event Catalog

Dashboard mockup. Chart overview. Creating charts. Chart basics. In-cell charts. Linking charts and cells. Camera tool. Sparklines. Creating mini charts. Dynamic charts.

Overview of new functions. Dynamic arrays. XLOOKUP. Overview of text functions.

Profits. Profit maximization and marginal analysis. Differential calculus. Constrained optimization. Marginal analysis vs incremental analysis. Demand and revenue. Supply function, and more.

Business cycle. Gross domestic product. Leading indicators. Coincident indicators. Lagging indicators. Labor-related indicators. Retail sales indicators. Personal income and outlay indicators. Housing and construction indicators. Manufacturing indicators. Price and inflation indicators. Federal reserve reports.

Common economic terms. Planning concerns and implications. Product concept. Elasticity of demand. Supply. Activity based costing. Economic value added.

Guiding principles. American opportunity credit. Lifetime learning credit. Qualified tuition programs. Coverdell education savings account. IRA distribution. Student loan interest deduction. Recordkeeping requirements.

Effective communication as a business professional. Choosing appropriate words. Planning and constructing professional compositions for all circumstances. Preparing personal resumes and application letters. Reporting. Listening and creating oral presentations. Technology in business communication.

The basic stages of a turnaround. Turnaround actions. Security interests and collection options. Turnaround legal considerations. The bankruptcy option. The bankruptcy process. Bankruptcy rules.

Effective customer service. The cost of a lost customer. Engage employees. Know the product. Collect information about customers. Get rid of the revenue-first mindset. The multi-lingual conundrum. Customer service metrics.

Overview of training. Instructional systems design. Training preparation and interaction.

Innovation theory. Innovation strategy. Innovation development. Excessive innovation effects. Innovation metrics.

Negotiation concepts. Negotiator skills and characteristics. Negotiation preparation. Negotiation tactics. Dealing with failing negotiations. Negotiation outcomes. Employee negotiations. Supplier negotiations. Negotiation measurement.

The importance of sales forecasting. Problems with sales forecasting. Characteristics of the market. Sales forecasting techniques. The forecasting process. Excel forecasting tools. Forecast evaluation.

Positioning of sales within the marketing mix. The sales manager position. The salesperson position. Types of sales strategies. The sales goal breakdown. The sales team. Managing sales opportunities, and more.

Employee onboarding.

The nature of entrepreneurship. The entrepreneurship method. The scaling problem. Select the right type of business. Calculate the sales break-even point. The ideal customer. The customer relationship, and more.

Accounting for receivables. Accounting for investments. Accounting for inventory. Accounting for property, plant, and equipment. Accounting for intangibles.

The legal environment. Liability. Intellectual property. White-collar crime. Introduction to contracts. Sales contracts, and more.

Business math basics. Data analysis. Interest and related topics. Markups and markdowns. Price elasticity. Cost-volume-profit analysis. Sales forecasting. Charts.

Sales contracts. Collection laws. Credit transactions. Legal issues associated with collection activities. The collection lawsuit. Dealing with a debtor bankruptcy.