Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
excel 2013 Level 1
Rating: 4.4 out of 5(57 ratings)
2,446 students

excel 2013 Level 1

EXCEL 2013 for Beginner
Created byTHAKUR VICKY
Last updated 5/2018
English

What you'll learn

  • how to operate excel at Level 1

Course content

1 section14 lectures30m total length
  • Launching Excel1:37

    Launch Excel from the start menu or search, then choose a blank workbook; or press the Windows key to search for Excel and access it from the taskbar.

  • Introduction to Excel3:07

    explore the excel 2013 interface, including the menu bar with home and insert, the formula bar, clipboard, and the worksheet with cells, rows, and columns.

  • Saving a File2:57

    Learn how to save an Excel 2013 workbook using save and save as, including default names, choosing a location, and managing changes.

  • Opening Existing File1:14

    Learn how to open an existing Excel 2013 workbook using multiple methods, including the File > Open approach, browsing recent workbooks, and opening from OneDrive or your computer.

  • Working With Excel Spreadsheet2:13

    Learn to enter data in Excel cells, type names, and use the fill handle to auto-fill sequences like days of the week and months, then drag to copy.

  • AUTOSUM Function3:31

    Learn how to use the autosum and sum functions in Excel 2013 to total monthly budgets, select ranges, and enter formulas for accurate totals.

  • SUM2:03

    Discover how to compute sums in Excel 2013 using simple addition across cells, practice building sum formulas with cell references like B5 and C6, and learn efficient total calculations.

  • SUM Function1:26

    Learn how to use the sum function in Excel 2013 to total a selected range by entering =sum, choosing the range, and closing the bracket.

  • MIN & MAX Function3:16

    Learn to find minimum and maximum values in Excel 2013 using min and max, selecting the data range and excluding headers and totals.

  • AVERAGE Funcction1:17
  • PERCENT Function1:16

    Learn how to use the percent function in Excel 2013 level 1 to calculate percentages by dividing a part by the overall total, such as determining the rent percentage.

  • COUNT Function1:50

    Learn how to use the count function in Excel 2013 to tally items in a long list by selecting a range and applying the formula.

  • AUTOFILL1:54

    Learn how to use excel 2013 autofill to copy and extend formulas like sum, minimum, maximum, and average by dragging the fill handle.

  • Overview3:00

Requirements

  • any one willing to learn

Description

Using excel to the beginner level, This program is for those who have no knowledge of excel

Introduction to Excel 2013

Launching Excel

Saving File

Opening file

Working with Excel Spreadsheet

AUTOSUM Function

Sum

SUM Function

MIN Function

MAX Function

Average Function

COUNT Function

Percentage Function

AUTO FILL Function

Using excel to the beginner level, This program is for those who have no knowledge of excel...........................................................................................................................................................................................................................................................................................................................................................................................
.


Who this course is for:

  • anyone want to learn excel