# Microsoft Excel Job Performance Task Creating Spreadsheets

**5 hours**left at this price!

- 5 hours on-demand video
- 30 downloadable resources
- Full lifetime access
- Access on mobile and TV

- Certificate of Completion

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business- • Immediately apply for jobs specifying the usage of Microsoft office. • Gain first-hand knowledge and confidence on how to create high level excel spreadsheets that projects clear and concise information. • Create dashboards which are one of the highest level of use by excel. • Create tables, charts, and pivot tables. • Perform operations with formulas and functions. • Analyze and assess data using quick analysis. • Design excel spreadsheets to present decision impact data. • Format and organize excel spreadsheets for data clarity. • Use formulas and functions to calculate and solve problems. • Add and format charts to visualize data. • Use quick analysis to analyze and present data.

- You need a PC and Internet Access. You will need access to Microsoft Excel 2007, 2010, 2013, or 2016. If you do not have access and want to take this course, you may obtain access to Microsoft Excel 2016 by subscribing with Office 365.

MICROSOFT EXCEL JOB PERFORMANCE TASK

- In this course, you will discover the confidence to handle Excel.
- You will take the take the high road to learning Excel.
- You will create spreadsheets at the highest level and that is summarizing data that reflects a picture in which the viewer can look at the picture and readily make decisions about the data.
- With this course, you will easily learn how to do that.
- You want the viewer to immediately gain knowledge from the spreadsheet.

BUILD YOUR EXCEL SKILL LEVEL PERFORMING THE TASKS THROUGHOUT THE COURSE. YOU WILL USE THE FOLLOWING EXCEL TABS AND COMMANDS:

- THE HOME TAB INCLUDING

- CLIPBOARD
- FONT
- ALIGNMENT
- NUMBER
- STYLES
- CELLS

2. THE INSERT TAB INCLUDING

- PIVOT TABLES
- RECOMMENDED CHARTS
- SPARK LINES
- CHART STYLES
- PIVOT TABLE STYLES
- DESIGN TAB
- OPTIONS TAB

3. THE DATA TAB INCLUDING

- DATA VALIDATION

4. THE FORMULAS TAB INCLUDING

- LOGICAL
- TEXT
- DATE & TIME
- LOOKUP & REFERENCE
- MATH & TRIG
- STATISTICAL

GET STARTED
TODAY

- Once you complete the course, you can apply for jobs requesting experience with Microsoft Office. This course will create a lot of success for you in the job market, because Microsoft Office and Excel supports thousands of jobs in the job market.

- This increases your chances of getting hired using Microsoft Office. Just google one of the major job sites and enter Microsoft Office, and you will see thousands of job opportunities.

- You are welcome to preview some of the lectures for free, below and then, you will be able to enroll with confidence!

WHAT YOU WILL FIND IN THIS COURSE

Here is what
you are going to discover in side this detailed, step-by-step course ….

The top goal for you in this course is to take the high road to learning Excel. The highest level of Excel is to be able to create spreadsheets that summarize data that reflects a picture in which the viewer can look at the picture readily make decisions about the data. With this course, you will easily learn how to do that.

For each Microsoft Excel Performance Task, you will have a Goal video, a Requirements video, the step by step tasks, and at the end each task, a conclusion video. These three videos will point you in the right direction in accomplishing the task.

You will easily learn how to create a table of data with the supplies and quantities and a chart to display the supplies and quantities. This is the Supplies and Quantities On-Hand Task.

You will easily learn how to create a spreadsheet showing data that require the use of the basic math formulas of addition, subtraction, multiplication, division, along with the charts to reflect the data. This is the Balance Sheet Task with Assets and Liabilities, and two charts.

You will easily learn how to create a spreadsheet showing data with different categories, different formulas, defining data names, range names, and charts to reflect the nature of the data. This is the Breakeven Analysis Task, with various categories of data, and three charts to reflect the data.

You will easily learn how to create a spreadsheet showing monthly budget data, including calculations for detail data, pivot tables, slicers, and pivot charts. This is the Monthly Budget Task.

You will easily learn how to create a spreadsheet dashboard using data validation, conditional formatting, pointers, references, match and index formulas. The is the Financial Report Task.

For each spreadsheet, you will learn easily learn how to test each spreadsheet to ensure that it updates with new data.

For each spreadsheet, you will learn how to setup the spreadsheet for printing.

- This course is for beginners and those who want to get into the Information Technology Job Market or enhance their job skills with Excel.

Format the Excel Spreadsheet

- Select the Home Tab to Use the Fill Bucket, Font, And Border Icons
- Create Excel Borders Using the Border Icon
- Create Colors for The Data Using the Fill Bucket Icon
- Increase or Decrease the Font Size Using the Font Icon
- Use the Shortcut Menus to Select Fonts, Borders, And Colors.

Create A Basic Excel Chart

- Use the Insert Tab, And Recommended Chart Tab to Insert a Chart
- Navigate Through the Different Excel Chart Styles to Select a Chart
- Move and Align the Chart
- Resize the Chart

Summary of Task Performed to Create the Excel Supplies on Hand Spreadsheet

- Created A Table of Data.
- Created A Basic Chart.
- Added the Chart Elements.
- Selected a Chart Style.
- Formatted the Data Using the Font, Fill Bucket and Border Icons.
- Formatted the Cell Data with Colors.
- Formatted the Chart with Colors.

When You Complete This Exercise, In General You will be able to:

- Create a table of data display computer supplies.
- Create a chart displaying the computer supplies.
- Format the data.
- Format graphic elements.
- Resize charts, add and modify chart elements, apply chart layouts and styles, move charts to a chart sheet.
- Use the Insert Tab to select a recommended chart.
- View and select a range of chart styles.

Describes the Overall Objective of The Excel Balance Sheet Task Including:

- A Picture of The Excel Spreadsheet to Be Created.
- The Data to Be Entered the Spreadsheet
- The Total and Ratio Formulas to Create the Summary Data.
- Describes the Asset Chart to Be Created.
- Describes the Liabilities Chart to Be Created.

Create the Four Key Metrics for The Excel Spreadsheet

- Perform Calculations to Create the Quick Ratio Metric.
- Perform Calculations to Create the Working Capital Metric.
- Perform Excel Calculations to Create the Current Ratio
- Perform Calculations to Create the Current Ratio
- Format the Ratios Using the Format Cells Dialog Box.

Create the Excel Total Asset Chart

- Use the Insert and Recommended Chart Tab to Select a Chart.
- Select a Chart Style in The Chart Styles Group.
- Add Excel Chart Colors and Patterns
- Format the Axis Using the Format Axis Dialog Box.
- Format the Data Series Using the Format Data Series Box.
- Resize and Move the Chart.

Create the Excel Total Liabilities Chart for the Balance Sheet

- Use the Insert and Recommended Chart Tab to Select a Chart.
- Select a Chart Style in The Excel Chart Styles Group.
- Add Excel Chart Colors and Patterns.
- Format the Axis Using the Format Axis Dialog Box.
- Format the Data Series Using the Format Data Series Box.
- Resize and Move the Chart.

Test the Excel Spreadsheet for Updating Capabilities

- Change the Cell Data to Ensure the Spreadsheet Updates.
- Update the Total Assets.
- Update the Total Liabilities.
- Observe that the Excel Asset Chart expanded or contracted.
- Observe that the Liabilities Chart expanded or contracted.
- Observe that the Totals Changed for the Liabilities and the Assets.

Summary of Tasks Performed to Create the Excel Balance Spreadsheet

- Enter Cell Data for The Total Assets.
- Enter Cell Data for The Excel Total Liabilities.
- Perform Calculations to Calculate the Totals.
- Perform Calculations to Calculate the Ratios.
- Create an Excel Assets Chart.
- Create A Liabilities Chart.
- Format the Charts for Presentation.
- Resized the Charts
- Relocated the Ratios.
- Relocated the Charts.

In this exercise, you will

- Perform operations with formulas.
- Create ratios.
- Create the totals and sub-totals for the assets and liabilities.
- Format the asset chart using the chart elements.
- Format the liabilities chart using the chart elements.
- Resize charts, add and modify chart elements, apply chart layouts and styles, move charts to a chart sheet.
- Create a new chart, add additional data series, switch between rows and columns in source data.

Describes the Goal of The Creating the Excel Break Even Analysis Spreadsheet

- Calculate the Totals for The Various Break Even Categories.
- Create Data Names for The Data Used in The Calculations.
- Create Special Excel Data Categories to Use in The Calculations.
- Calculate the Sales Volume Data.
- Create Two Pie Charts.
- Create A Line Chart.

Describe the Requirements of The Excel Break-Even Analysis Task

- Perform Calculations for The Following:
- The Total Sales Amount.
- The Variable Costs.
- The Fixed Costs Per Period Calculation.
- An Excel Chart Displaying the Unit Contribution Margin.
- A Chart Displaying the Variable Costs.
- A Chart Displaying the Sales Volume Data.

Create the Variable Cost Data for The Excel Breakeven Analysis Spreadsheet

- Enter the Titles.
- Enter the Variable Cost Data.
- Create Excel Formulas to Calculate the Variable Cost Total.
- Format the Data Using the Currency Selection.
- Calculate the Unit Contribution Margin.
- Calculate the Gross Margin.

Create the Fixed Costs Per Period Data for The Excel Breakeven Spreadsheet

- Enter the Titles.
- Change the Font Size.
- Enter the Cost Data.
- Calculate the Total Fixed Costs.
- Format the Costs to Show Dollars and Cents.
- Calculate the Net Profit (Loss).
- Calculate the Break-even Point (Units).

Create the Excel Data Names to Use in Calculating the Sales Volume Data

- Assign Data Names to The Key Metrics.
- Use the Excel Data Name Command to Create the Data Names For 9 Key Metrics.
- Create A Multiplier Used to Calculate the Sales Volume Per Period Data.

Create Two Excel Breakeven Analysis Charts for The Spreadsheet

- Create Variable Costs Per Unit Chart.
- Create Total Variable Costs Excel Chart.
- Use the Design Tab to Select a Chart Style for Both Charts.
- Format the Chart to Include Cost and Percentages for Both Charts.
- Re-size the Chart.
- Move the Charts to A New Location.

Summarizing the Results of The Excel Breakeven Analysis Job Performance Task

In This Lesson, You Learned How To:

- Create Data Names Using the Data Name Command.
- Insert Charts Using the Insert Tab and Recommended Chart Command.
- Format the Charts for Presentation.
- Re-Size the Charts for Relative to The Data Presented.
- Change the Chart Elements.
- Use Data Names to Calculate Totals.

- Perform various calculations using formulas.
- Create data names used to perform accurate calculations.
- Create two pie charts.
- Create one line chart with four lines of data.
- Change the chart elements
- Resize and adjust the charts for presentation.
- Format the chart data to add percentages.

Describes What Is Required to Develop the Excel Monthly Budget Report

- The Projected Balance.
- The Actual Balance.
- Calculate the Difference Between Projected Spending Versus Actual Spending.
- Create and Format the Excel Pivot Table.
- Create and Format the Pivot Chart.

Create A Slicer for The Excel Monthly Budget Report

- Insert A Slicer.
- Modify the Slicer Column Size.
- Adjust the Slicer Size.
- Test the Slicer.

Create an Excel a Pivot Chart to Show the Data Series, Categories, And Chart Axes.

- Use the Insert Tab and Recommended Charts Tab to Select a Pivot Chart Style.
- Add or Change Chart Elements Such as Titles or Data Labels.
- Use the Analyze, Design, And Format Tabs to Format the Pivot Chart.

Create Excel References and Pointers to The Financial Data and Metric Years

- Create Data Names.
- Create Excel Row Pointers to The Metrics Using the Match Formula.
- Create Pointers to The Financial Data Using the Index Formula.

Create the Excel Detail Financial Data for the Metrics

- Insert the References to the Financial Data.
- Insert the Related Percentages.
- Use Auto Fill to Complete the Data.

Understand How the Excel VLOOKUP And Hlookup Formulas Work

- Use the VLOOKUP Formula to Lookup Data Vertically.
- Use the Hlookup Formula to Lookup Data Horizontally.