Course description

Excel is Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data.

This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features including creating a new spreadsheet, working with basic formulas and functions, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet.

This course is based on a combination of theory and practical hands-on training.

Theory + Practical Application Scenarios + Hands-On Training = Outstanding Results

What will i learn?

  • Getting Started. In this lesson, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.
  • Working with Data. This lesson covers using formulas and functions in a worksheet, working with data, rows and columns and, how to sort and filter data.
  • Modifying a Worksheet. Next, students will learn how to format text and cells and, how to align cell contents. Using Find & Select tools and, how to spell check a worksheet are also discussed.
  • Printing Workbook Contents. In this lesson, students will learn how to define the basic page layout for a workbook, refine the page layout and apply print options.
  • Managing Large Workbooks. This lesson will teach students how to format worksheet tabs, manage worksheets and, manage the view of worksheets and workbooks.
  • Customizing the Excel Environment. In this final lesson, students will learn how to customize general, language, formula, proofing, and saving options. It also covers how to use Excel’s version control features, customize the ribbon and the Quick Access toolbar, enable add-ins and, customize advanced and Trust Center options.

Requirements

  • This course assumes the user understands the basics of using a Windows-based computer.
  • Students should be comfortable using the keyboard, mouse, and Start menu.
  • Understanding and experience with printing and using a web browser is an asset, but not required.
  • No previous experience with other versions of Excel is necessary.

William Wingson - Total Corporate Learning

Director of Training

William’s passion for learning and making the learning experience exciting is remarkable. With a degree in Statistics, a Certificate in Business, a Certificate as Sage 300 and Sage 50 trainer, William offers practical information necessary to operate successful businesses. As the Director of Training for Total Corporate Learning Inc., William uses his wealth of training experience to educate and positively impact business owners in the use of software in the day-to-day operation of their businesses.
Course Thumbnail

KSh30,000

Lectures

8

Skill level

Beginner

Expiry period

Lifetime

Certificate

Yes

Related courses