Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 5 hours on-demand video
  • 30 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel

Microsoft Excel Job Performance Task Creating Spreadsheets

Creating Excel Spreadsheets Providing You With On The Job Experience Using Excel
Rating: 4.4 out of 54.4 (6 ratings)
35 students
Created by Achilles Carroll
Last updated 2/2017
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • • 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.

Requirements

  • 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.

Description

MICROSOFT EXCEL JOB PERFORMANCE TASK 

  1. In this course, you will discover the confidence to handle Excel.  
  2. You will take the take the high road to learning Excel.  
  3. 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.
  4. With this course, you will easily learn how to do that. 
  5. 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:

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

Who this course is for:

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

Course content

8 sections • 84 lectures • 5h 5m total length

  • Preview04:54

  • THE GOAL OF COMPUTER SUPPLIES ON HAND TASK
    00:43
  • THE REQUIREMENTS FOR THE COMPUTER SUPPLIES ON HAND TASK
    00:48
  • CREATING THE TABLE OF SUPPLIES AND QUANTITIES
    03:32
  • FORMATTING THE TABLE OF SUPPLIES AND QUANTITIES
    03:50
  • Preview03:17
  • VIEWING AND SELECTING CHART OR GRAPH ELEMENTS
    03:22
  • CHANGING THE CHART ELEMENTS TO DESCRIBE THE CHART
    05:50
  • TESTING THE COMPUTER SUPPLIES ON HAND SPREADSHEET FOR UPDATING CAPABIL
    02:07
  • SETTING UP THE SPREADSHEET FOR PRINTING
    01:28
  • SUMMARIZING THE RESULTS OF THE COMPUTER SUPPLIES ON HAND TASK
    01:03
  • COMPUTER SUPPLIES EXERCISE
    00:44

  • THE GOAL OF THE BALANCE SHEET TASK
    01:18
  • THE REQUIREMENTS OF THE BALANCE SHEET TASK
    01:19
  • CREATING THE CURRENT ASSETS FOR THE BALANCE SHEET TASK
    04:33
  • CREATING THE OTHER ASSETS FOR THE BALANCE SHEET TASK
    04:17
  • CREATING THE CURRENT LIABILITIES FOR THE BALANCE SHEET TASK
    04:07
  • CREATING THE OTHER LIABILITIES DATA FOR THE BALANCE SHEET TASK
    03:56
  • MAKING ADJUSTMENTS AND CALCULATING THE TOTALS
    05:55
  • Preview06:00
  • CREATING THE TOTAL ASSET CHART FOR THE BALANCE SHEET
    06:06
  • CREATING THE TOTAL LIABILTIES CHART FOR THE BALANCE SHEET
    03:10
  • MAKING CHANGES TO THE BALANCE SHEET
    05:28
  • Preview02:35
  • SETTING UP THE BALANCE FOR PRINTING
    02:17
  • SUMMARIZING THE RESULTS OF THE BALANCE SHEET TASK
    02:03
  • Balance Sheet Exercise
    00:41

  • THE GOAL OF THE BREAKEVEN ANALYSIS TASK
    02:11
  • THE REQUIREMENTS OF THE EXCEL BREAKEVEN ANALYSIS TASK
    01:05
  • CREATING THE EXCEL BREAKEVEN ANALYSIS SALES DATA
    04:42
  • CREATING THE EXCEL BREAKEVEN ANALYSIS VARIABLE COST DATA
    06:22
  • CREATING THE EXCEL BREAKEVEN FIXED COSTS PER PERIOD DATA
    08:02
  • CREATING THE DATA NAMES USED TO CREATE THE SALES VOLUME ANALYSIS DATA
    05:24
  • LESSON 30 CREATING THE MUTIPLIER FOR THE SALES VOLUME ANALYSIS DATA - PART 2
    02:06
  • CREATING THE EXCEL SALES VOLUME ANALYSIS DATA
    06:13
  • Preview05:31
  • CREATING THE EXCEL BREAKEVEN CHART FOR THE BREAKEVEN DATA
    04:33
  • TESTING THE EXCEL BREAKEVEN SPREADSHEET FOR UPDATING CAPABILITIES
    02:30
  • SUMMARIZING THE RESULTS OF THE EXCEL BREAKEVEN ANALYSIS TASK
    04:58
  • Breakeven Analysis Exercise
    00:48

  • THE GOAL OF THE MONTHLY BUDGET REPORT JOB PERFORMANCE TASK
    01:40
  • THE REQUIREMENTS OF THE MONTHLY BUDGET REPORT
    02:05
  • CREATING THE DETAIL DATA FOR THE MONTHLY BUDGET REPORT
    03:06
  • CREATING THE PIVOT TABLE FOR THE MONTHLY BUDGET REPORT
    09:04
  • CREATING THE BALANCE DATA FOR THE MONTHLY BUDGET REPORT
    05:02
  • Preview02:32
  • CREATING THE PIVOT CHART FOR THE MONTHLY BUDGET REPORT
    04:41
  • TESTING THE SPREADSHEET FOR UPDATING CAPABILITIES
    05:10
  • FORMATTING THE DASHBOARD FOR PRESENTATION
    09:45
  • SUMMARIZING THE RESULTS OF THE MONTHLY BUDGET REPORT
    04:43
  • CREATE THE PIVOT TABLE EXERCISE
    04:41
  • CREATE THE SLICER EXERCISE
    00:48
  • CREATE THE PIVOT CHART EXERCISE
    00:48

  • THE GOAL OF THE ANNUAL FINANCIAL REPORT JOB PERFORMANCE TASK
    02:37
  • THE REQUIREMENTS OF THE ANNUAL FINANCIAL REPORT
    01:56
  • VIEWING AND FORMATTING THE DETAIL DATA
    02:16
  • CREATING THE SELECTION LIST FOR THE METRICS
    04:28
  • Preview03:59
  • CREATING THE SELECTION LIST FOR THE METRIC YEARS
    04:14
  • CREATING THE KEY YEARS TO USE FOR THE DASHBOARD
    03:16
  • CREATING THE METRIC YEARS BASED ON THE YEAR SELECTED
    04:18
  • CREATING THE POINTERS TO THE METRIC YEARS BASED ON THE YEAR SELECTED
    04:31
  • CREATING THE INDEXES FOR THE FIVE KEY METRICS TO DISPLAY THE FINANCIA
    07:11
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 1
    02:34
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 2
    03:30
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 3
    03:59
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 4
    04:01
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 5
    05:24
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 6
    05:14
  • CREATING THE ANNUAL FINANCIAL REPORT DASHBOARD PART 7
    03:27
  • Preview02:35
  • CREATING THE FIVE YEAR TREND LINE FOR THE METRICS
    05:54
  • TESTING THE ANNUAL FINANCIAL REPORT FOR UPDATING CAPABILITIES
    03:19
  • SETTING UP THE REPORT FOR PRINTING
    01:45
  • SUMMARIZING THE ANNUAL FINANCIAL REPORT JOB PERFORMANCE TASK
    05:11
  • Create a Drop Down List of Metrics Exercise
    00:48

  • Conclusion
    04:41

  • Working with Text Formulas
    02:42
  • Preview02:46
  • Working with Logical Formulas
    04:01
  • Working with Quick Analysis
    03:15
  • Create and Manage Tables
    01:48
  • Working with Date Formulas
    03:04
  • Working with Conditional Formulas
    02:47

Instructor

Achilles Carroll
Software Trainer
Achilles Carroll
  • 4.4 Instructor Rating
  • 6 Reviews
  • 35 Students
  • 1 Course

Achilles Carroll, Innovation – Creativity – Imagination

If you want to be successful with Microsoft Excel, then this course is for you. 

This course will provide you with the knowledge and confidence in creating Excel spreadsheets.

My mission is simple: To enhance your skill level so that you can begin or transition into an Information Technology job, complete with benefits, such as, paid time off, paid holidays, life insurance, etc. 

The information technology job market is the largest job market in the world and after you get started in the field, you can transition from different career aspects of technology.

You can transition from Excel to several information technology fields, such as, transitioning from Excel to Database Administration, Configuration Management, ITIL, or Software Testing, etc. 

Here’s a little background on my experiences, so that you can get a sense of who will be teaching and mentoring you:

Twenty-five years of experience in working with the various Information Technology mainstream products, such as, Database Administration, Microsoft SQL, Oracle SQL, SharePoint, Microsoft Access, Excel, and PowerPoint Integration, ITIL Data Management.

You can see my certifications here:

 1.  ITIL               IT Service Management                                     March        2016

 2.  MCPD          SharePoint Application Developer                      April           2013

 3.  MCTS           SharePoint Application Designer                        April           2013

 .4  MCT              Microsoft Certified Trainer                                  April            2013

  5. MS-SQL        Microsoft Database Administrator                     May             2011

  6. Oracle SQL   Oracle Certified SQL Expert                              March         2011

  7. Security +      CompTia                                                             February    2012

  8. MCSD.NET   Microsoft Certified Solution Developer.NET       March        2005

  9. MCAD.NET    Microsoft Certified Application Developer.NET September 2004

10. MCP                Microsoft  Certified Professional                       February    2003

You can earn certifications through preparation that we will keep you employed in the

job market for years to come and  with  a higher than average income. 

With certifications, you will never have to worry about being unemployed. 



  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.