
Open a blank Excel workbook with multiple sheets and rename them. Learn that columns are labeled by letters, rows by numbers, and enter formulas by prefixing with =, like 7+8.
Please download the attached Excel file to follow along with the Excel Examples throughout this course.
Explore the if function in excel by testing student averages to determine pass or fail using a 70 threshold. See examples like Oliver and Matt.
Master absolute referencing to build an Excel multiplication table by locking E6 and F5 with dollar signs or F4, then copying the formula across and down to complete the matrix.
Construct a pivot table by placing product in rows and amounts in values, filter by country, and use value field settings and sorts to reveal top exports.
Build a two-dimensional pivot table by placing product on rows, country on columns, and amount in values, with category filters, then switch value settings to count for per-country product counts.
Insert a pivot chart from the inserts menu to visualize pivot data and answer questions quickly; bananas show the highest counts in the United States, with Germany's yellow bar tallest.
Learn to build an income statement in Excel from total revenue through depreciation, tax rate, and expenses, using data like average price per pizza and monthly pizza sales.
build a monthly income statement in excel by calculating total revenue from units times price, subtracting cost of goods sold, and deriving margins, ebitda, and net income.
Use the countif function to tally monthly chocolate ice cream sales by criteria such as below average, above average, and popularity across January to December, and replicate sideways.
Set up a breakeven analysis with the given parameters, compute revenue, total cost, and profit, then derive the break-even point as fixed costs divided by (price minus variable cost).
Create a clustered bar chart in Excel to compare lemonade and tea sales over time. Rename the chart, add elements, and adjust axes, legend, and data ranges to clarify trends.
Welcome!
Microsoft Excel spreadsheets are widely used to store, organize, and analyze data. In light of this, Excel has grown to become arguably the most important computer program in workplaces around the world. Any role in any industry can benefit from someone like you with strong Excel knowledge.
Excel is a powerful tool that has become ingrained in business processes worldwide, from analyzing stocks, budgeting, and organizing client sales lists, to analyzing staff performances, managing employee schedules, and comparing periodic product sales performances, to name a few.
Through the manipulation of stored data, Excel enables you to identify trends and organize and sort data into meaningful categories. With the use of pivot tables in Excel (one of my personal favorites) you can skillfully summarize data from a worksheet into an illustrative chart. Finance and accounting professionals choose Excel for its complex analytical and computing features, while Excel also performs Human Resources functions, such as sorting worked hours and organizing employee profiles and expenses, which help businesses better understand the structure and activities of their workforce.
This Business Data Analysis with Excel course will provide you with an in-depth understanding of:
Excel functions and pivot tables, pivot charting, and pivot reporting, to group, slice, calculate and summarize large syndicated datasets in order to answer specific questions
Sorting, filtering and grouping tools in Excel
Creating financial statements (with particular focus on the income statement)
Analyzing employee performance using the LOOKUP and COUNTIF functions
Performing break-even analysis and introductory cluster analysis
Charting, graphing, and illustrating data trends in Excel, amongst others!
Using Excel for business has almost no limits for applications. Here are some examples:
- Excel creates revenue growth models for new products based on new customer forecasts.
- When planning a team outing to a baseball game, you can use Excel to track the RSVP list and costs.
- When planning an editorial calendar for a website, you can list out dates and topics in a spreadsheet.
- When creating a budget for a small product, you can list expense categories in a spreadsheet, update it monthly and create a chart to show how close the product is to budget across each category.
- You can calculate customer discounts based on monthly purchase volume by product.
- You can conduct a thorough analysis of patient and medical research data
- You can summarize customer revenue by product to find areas where to build stronger customer relationships etc.
A working knowledge of Excel is vital for most professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities.
Enroll now and start your journey to data management and storytelling through Excel data analysis and visualization!