Microsoft Excel Job Performance Task Creating Spreadsheets

Course details

MICROSOFT EXCELJOB PERFORMANCE TASK 

1. In this course,you will discover the confidence to handle Excel.  
2. You will takethe take the high road to learning Excel.  
3. You will createspreadsheets at the highest level and that is summarizing data that reflects apicture in which the viewer can look at the picture and readily make decisionsabout the data.
4. With this course,you will easily learn how to do that. 
5. You want theviewer 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:

1. 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 STARTEDTODAY 

• Once youcomplete the course, you can apply for jobs requesting experience withMicrosoft Office.  This course will create a lot of success for you in thejob market, because Microsoft Office and Excel supports thousands of jobs inthe job market.  

• This increasesyour chances of getting hired using Microsoft Office. Just google one of themajor job sites and enter Microsoft Office, and you will see thousands of jobopportunities.

•  You are welcometo preview some of the lectures for free, below and then, you will be able toenroll with confidence!

WHAT YOU WILLFIND IN THIS COURSE

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

The top goalfor you in this course is to take the high road to learning Excel.  Thehighest level of Excel is to be able to create spreadsheets that summarize datathat reflects a picture in which the viewer can look at the picture readilymake decisions about the data. With this course, you will easily learn how todo that.

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

You will easilylearn how to create a table of data with the supplies and quantities and achart to display the supplies and quantities.  This is the Supplies andQuantities On-Hand Task.

You will easilylearn how to create a spreadsheet showing data that require the use of thebasic math formulas of addition, subtraction, multiplication, division, alongwith the charts to reflect the data. This is the Balance Sheet Task with Assetsand Liabilities, and two charts.

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

You will easilylearn how to create a spreadsheet showing monthly budget data, includingcalculations for detail data, pivot tables, slicers, and pivot charts. This isthe Monthly Budget Task.

You will easilylearn how to create a spreadsheet dashboard using data validation, conditionalformatting, pointers, references, match and index formulas. The is theFinancial Report Task.

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

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