Microsoft Excel Fundamentals

The course is designed for participants who want to learn basic skills for working with Microsoft Excel. During the course, theoretical knowledge is acquired and practical work is carried out to get acquainted with the basic functionality of Microsoft Excel. The course helps to set up and customize the worksheet to your needs, design the entered data and cells, and perform calculations using formulas and functions
Course duration, academic hours: 16
Price (excl. VAT) 300,00 
Price (with VAT): 363,00 
Lecturer: Aleksandrs Vosekalns Daiga Zentele Iveta Milta
Iveta Milta
Teacher of computing, programming and mathematics, Erasmus+ project coordinator and eTwinning project ambassador in Latvia.

Oskars Zeps Kristiāns Freidenfelds
Kristiāns Freidenfelds
Kristiāns Freidenfelds has experience in international companies in the business control department (finance). The teacher's responsibility is budgeting, market research, project analysis and optimization of internal financial processes

Raitis Uščins
Raitis Uščins
Resource planning expert at "Tet" company, skilled telecommunication and computer network specialist with continuous growth, focused on innovative company solutions. A teacher with high motivation, self-confidence and the ability to adapt to different situations. Lecturer at the Baltic Computer Academy since 2022.

Plans

09. April, 2024 - 12. April, 2024
Place:
Online
Language:
lv
Lecturer:
Oskars Zeps
Price (excl. VAT)
300,00 
Price (with VAT):
363,00 
Contact us

Apply or ask a question!

 

If you want to apply for the course or ask a question about it, feel free to use this form.

Please enter your first and last names
Please enter company name
Please enter your phone number
Please enter your email

Thank you! We will contact you.

Training schedule:
09.04.2024 09:00-12:15
10.04.2024 09:00-12:15
11.04.2024 09:00-12:15
12.04.2024 09:00-12:15
Course target
To teach students how to work independently with Microsoft Excel – to set up and customize a worksheet to their needs, to design the entered data and cells. Perform calculations using formulas and functions.
Audience
Participants with basic computer skills.
At Course Completion you will be able
  • To open the app and navigate its environment
  • To work with a workbook, its worksheets, and data.
  • To save the workbook and open the workbook you created earlier.
  • To work with data areas of a worksheet.
  • To design worksheet data and cells.
  • To perform actions on columns and rows on a worksheet.
  • To perform actions on worksheets.
  • To perform calculations using functions and formulas.
  • To display data using charts and sparklines
  • To change worksheet settings.
  • To prepare the worksheet for printing and print it.
Prerequisites
Basics of using computers.
If necessary, to determine the level of knowledge of participants, the BDA conducts pre-course testing.
Training materials
The course uses training materials developed by the BDA and examples of practical work.
Certification Exam
No certification exam is included.
Course outline
  1. Excel environment:
  • Excel user interface
  • Using the backstage view
  • Using ribbon and tabs
  • Using the formula bar
  • Worksheet elements
  • Move in a worksheet
  • Using the status bar
  • Using the quick access toolbar
  • Program suggestions and help (tell me what you want to do)

2. Work with a workbook:

  • Open and create workbook
  • Save workbook
  • Work with view windows of one and more workbooks
  • Move between workbooks (switch windows)
  • End of work in Excel

3. Actions on workbook worksheets:

  • Add a new worksheet
  • Move from one worksheet to another
  • Change the worksheet name
  • Move, copy, and delete a worksheet
  • Hide and unhide sheet a worksheet
  • Highlight multiple worksheets
  • Color the tab color of worksheet tabs
  • Using the right-click mouse menu

4. Work with worksheet data and data areas:

  • Entering information into cells
  • Editing and deleting information
  • Auto cell fill
  • Select Cell Area
  • Enter data in a highlighted data area
  • Using the Quick Analysis tool
  • Copying, cutting and pasting of the cell area and objects
  • Move data area
  • Work with sort lists
  • Creating data series

5. Design worksheet data:

  • Cell data design – style, size, color, size.
  • Copy and assign cell formatting to another cell
  • Align cell data
  • Merge cells
  • Resizing columns, rows, and cells on a worksheet
  • Change the visual design of the cell
  • Format as a table in a cell area
  • Design data by using number format

6. Working with cells, rows and columns:

  • Insert and delete cells, rows, columns
  • Move rows, columns
  • Freeze and unfreeze rows and columns
  • Hide rows and columns and unhide

7. Making calculations:

  • Performing calculations using formulas
  • Copy formulas to other cells
  • Using cell addressing to create functions
  • Inserting and creating functions, specifying function arguments
  • Using the Function Round function to round numbers
  • Using the Count function to determine the number of cells
  • Create a logical function IF and specify arguments

8. Graphical data display:

  • Charting and formatting
  • Sparklines

9. Change worksheet settings and print a worksheet:

  • Change the margins, orientation, size, and scaling of a worksheet
  • Set print area
  • Insert page break
  • Header and footer (header and footer)
  • Print a worksheet.

10. Additional options:

  • Using a quick analysis tool
  • Find and replace
  • Use the Excel Help window (help)
  • Change the basic program options and default save location
  • Compatibility mode.

If you want to get more information about this course, contact us by phone +371 67505091 or send us an e-mail at mrn@bda.lv.