“Microsoft Excel” for Beginners

“Microsoft Excel” for Beginners
  • Event Category: Microsoft Office

The course schedule has not been scheduled yet. Please visit again soon.

ABOUT THE SEMINAR

The course is intended for beginner users of “Microsoft Excel” 2010/2013 or for those who have no experience working with spreadsheet software and wish to learn how to use this program. During the course, you will become familiar with the working modes of “Microsoft Excel” 2010/2013, toolbars and their functions, and learn how to enter and edit data.

You will learn how to create tables, perform calculations using formulas and functions, create charts, sort and filter data, and prepare data for printing.

SEMINAR PROGRAM
  • Basic knowledge of “Microsoft Excel”: program environment, user interface.
    • Workbook structure, basic actions with worksheets.
    • The concept of a cell and a cell address.
    • Working modes, window management.
  • Entering, editing, and formatting data.
    • Font formats, borders, background, data alignment within a cell.
    • Data types, number and date formats.
  • Styles and themes.
  • Actions with workbook sheets, rows, and columns.
  • Automatic cell filling, data series.
  • Formulas and functions.
    • Formula structure and creation. Absolute and relative references.
    • The concept and syntax of functions.
    • Examples of using basic functions.
  • Copying and moving data and formulas, special paste.
  • Creating charts. Chart types, editing. Examples of basic types.
  • Sorting and filtering data.
  • Conditional formatting.
  • Preparing and printing documents.
    • Page numbering, creating headers and footers.
    • Setting page margins, fitting data into a specified number of pages.