Excel Essentials and Formulas

Language

English

 

Duration

1 Day

Delivery Method

Instructor Led - Online

Are you looking to build your foundational understanding of Excel? If so, our course is designed to equip you with the necessary skills to create and work with electronic spreadsheets. With Excel, you can effortlessly organize, calculate, analyze, revise, update, and present data.

Our course is offered by Training Estonia, a leading training center in Estonia, Latvia, and Lithuania. As industry professionals, we understand the importance of having a solid understanding of Excel and have designed a comprehensive curriculum to help you achieve your goals.

Our course covers all the essential features of Excel, including data entry, formatting, and manipulation. We also teach advanced Excel functions such as VLOOKUP, PivotTables, and macros that streamline your workflow and increase your productivity.

Our course content is tailored to cater to the needs of beginners and intermediate-level users, so no prior experience is required. We provide you with step-by-step guidance, practical exercises, and assessments to verify your progress and provide feedback.

At Training Estonia, we are dedicated to ensuring that your learning experience is productive and engaging. We strive to provide high-quality training that meets your individual needs, so you can become proficient Excel users.

Start your journey to Excel proficiency today with our comprehensive course at Training Estonia.

€275.00

Course Time is “CET” – Central Europe Time!

Your Local time is – Time Zone Calculator.

Objectives

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation.

Prerequisites

Course Prerequisites:

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.

Audience

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows environment and be able to manage information on their computers.

Outline

Getting Started with Excel

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter and Edit Cell Data
  • Fill Cells with Series of Data (AutoFill and Flash Fill)
  • Use Excel Help

Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions and use Autocomplete
  • Reuse Formulas and Functions
  • Create an Absolute Reference

Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Move and Copy Data between Cells
  • Search for and Replace Data
  • Use Spellcheck and Proofing

Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply and Copy Cell Styles
  • Apply Basic Conditional Formatting

Printing Workbooks

  • Preview and Print a Workbook
  • Controlling Page Layout
  • Adding Headers and Footers
  • Set Print Titles and Print Ranges

Managing Workbooks

  • Manage Worksheets
  • Insert and Delete Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

Additional Info

Organizer: Nexus Human

Academic Hours: 8 academic hours (1 day)

Experience Level: Foundational

Labs: No

Continuing Education Curriculum Group: Computer Use

Contact Us

"*" indicates required fields

Name*
Please let us know what's on your mind. Have a question for us? Ask away.
Hidden
Shopping Cart
Scroll to Top