Microsoft 365 Excel ( Beginner)

by OptionTrain College of Management and Technology Claim Listing

If you are new to Excel, this course will teach you the essential skills needed to start using Excel spreadsheets. You will learn to navigate with ease, enter data into spreadsheets, manipulate data, format data, and start creating formulas and using functions.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

OptionTrain College of Management and Technology Logo

img Duration

Please Enquire

Course Details

If you are new to Excel, this course will teach you the essential skills needed to start using Excel spreadsheets. You will learn to navigate with ease, enter data into spreadsheets, manipulate data, format data, and start creating formulas and using functions.

At the end of the course, students will be confident enough to work with the pre-created spreadsheets or create their own.

 

Course Outline:

  • Navigating Easily In Excel
    • Using the Ribbon: Tabs, Groups and Commands
    • Cells, columns and rows
    • Shortcut key combinations
    • Freezing, splitting and zooming the screen
    • Hiding columns and rows
  • Entering Data
    • Formatting Dates and Times
    • Check spelling
    • Undo or redo
    • Create and modify tables
    • Sorting and Filtering tables
  • Start Creating Formulas
    • Add,
    • Subtract,
    • divide and
    • multiply
    • What is cell reference?
  • Start Using Built-In Excel Functions
    • Manually type functions
    • Use functions button
    • AutoSum, Average, Count, Min and Max
  • Moving And Copying Data
    • Cut, Copy and Paste
    • Fill Handle
    • Autofill
    • Flash Fill
    • Smart Tags
  • Organizing And Working With Multiple Worksheets
    • Renaming and coloring tabs
    • Moving, copying and inserting worksheets
    • Margins
    • Headers and Footers
    • Printing Options
  • Formatting With Excel
    • Adjusting width or height of columns or rows
    • Cell alignments
    • Wrapping and merging
    • Formatting numbers
  • Toronto Branch

    20 Eglinton Avenue E, Suite# 390, Toronto

Check out more MS Excel courses in Canada

Working Skills Centre (WSC) Logo

Microsoft Access 2013

Access is Microsoft’s powerful database tool. Using Access you will learn to store, retrieve, and report on information. You will be able to sort, make queries, create reports, and understand all the functions of a relational database.

by Working Skills Centre (WSC) [Claim Listing ]
AFI Expertise Logo

Access Basics

Discover Access with this program. Learn how to manipulate records, format a table structure and create a database. Please note that the version most represented in the group will be installed on all computer stations, but the differences between the versions will be addressed during the training.

by AFI Expertise [Claim Listing ]
Q Academy Logo

Data Analysis With MS Excel

The online course on Data Analytics with MS Excel is designed to provide participants with a comprehensive understanding of how to leverage Microsoft Excel for analyzing and interpreting data.

by Q Academy [Claim Listing ]
The Great Canadian Training & Consulting Co. Logo

Microsoft OneNote Training

New users who would like to learn how to keep their information more organized across multiple devices and with multiple team members.

by The Great Canadian Training & Consulting Co. [Claim Listing ]
(BTT) Business And Technical Training College Logo

Microsoft Word

We can provide an organization to customize training for Microsoft Word. Tell us what your needs are.

by (BTT) Business And Technical Training College

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy