• Home
  • All Courses
    • Onsite Courses
    • Online Courses
    • FAQ
    • Request A Class
  • Course Packages
    • Onsite After-School Program
    • Online Packages: K-University
  • Camps
    • Onsite Summer Camp 2022 – JK-GR 8
    • Online Summer Camp 2022- JK-GR 8
  • Competitions
  • Teach
  • Book A Room
  • Who We Are
    • About Us
    • Contact Us/ Location
  • 0 items
    Have any question?
    (+1) - 905-604-7740
    info@studentscholarscentre.com
    • Login
    • Register
    StudentScholars Academic, Art & Music CentreStudentScholars Academic, Art & Music Centre
    • Home
    • All Courses
      • Onsite Courses
      • Online Courses
      • FAQ
      • Request A Class
    • Course Packages
      • Onsite After-School Program
      • Online Packages: K-University
    • Camps
      • Onsite Summer Camp 2022 – JK-GR 8
      • Online Summer Camp 2022- JK-GR 8
    • Competitions
    • Teach
    • Book A Room
    • Who We Are
      • About Us
      • Contact Us/ Location
    • 0 items

      Introduction To Excel

      • Home
      • All courses
      • Introduction To Excel
      • Introduction To Microsoft Excel-Individual-Online

      Introduction To Microsoft Excel-Individual-Online

      User Avatar
      Empowered Professionals
      Introduction To Excel, Online Courses
      (0 review)
      $750.00
      EXCEL
      • Overview
      • Curriculum
      • Reviews
      • Instructor

      StudentScholars ‘Introduction to Microsoft Excel’ –  Online

      Learn Excel | Online- University Help| Experienced Subject Qualified Teachers. Customized programs & much more!

      Program Overview:
      The Excel spreadsheet lets you organize information into nice, neat rows and columns, then format, sort, analyze and do math on it. Useful for financial records, address books, to do lists, too many things to mention. We look at:

      Course Objectives:

      Participants will:
       Create basic worksheets using Microsoft Excel 2016.
       Perform calculations in an Excel worksheet.
       Modify an Excel worksheet.
       Modify the appearance of data within a worksheet.
       Manage Excel workbooks.
       Print the content of an Excel worksheet.
       Learn how to use handy feature

      1. MODULE 0: Essentials Skills
      1. Intro to Windows (0.5 hour)
       Touchscreen and mouse
       Scrolling
       Keyboard shortcuts
       Windows desktop
       Run an App from start Menu
       Create an Excel blank document
       Maximize/minimize window

      2. Excel user interface (1 hour)
       Title bar
       Menu bar
       Ribbon bar
       Formula bar
       Data area – Columns & Rows
       Worksheet bar
       Status bar
       Columns, Rows and Cells
       Quick Access Toolbar
       Mini toolbar
       Document properties

      3. Printing (0.5 hour)
       To access the Print pane
       Print a workbook
       Print active sheets

      4. Organizing files (0.5 hour)
       Create a folder
       Create a folder within a folder
       Hierarchy & travelling through folders/files
       Switch from one App to another

      5. Saving your documents (1 hour)
       Save
       Save as
       Save in a different file type
       Save a file on One Drive
       Sign out from Microsoft account

      6. Screen resolution (0.5 hour)
       Minimize/Restore a window
       Change screen resolution
       Exit Excel with a document open

      7. Backstage view (0.5 hour)
       Run an App from the search box
       Open an existing document
       Creating a new document
       Close a file
       Open a recent file

      8. Organizing files (0.5 hour)
       Rename,
       move
       delete a file

      9. Windows Help (0.5 hour)
       Open Office help
       Move and resize a window

      2. MODULE 1: Creating a worksheet and a chart

      1. Entering Text and Sum (1 hour)
       Selecting a cell
       Entering text
       Entering numbers
       Calculating a sum
       Using the Fill Handle to copy text
       Using the Fill handle to copy formulas
       Entering a formula using keyboard

      2. Formatting a Cell & worksheet (1.5 hour)
       Formatting a cell
       Use the Bold, Italic, and Underline commands
       Change the font
       Change the font size
       Change the font color
       Text alignment
       Format rows
       Cell styles
       Apply a cell style
       To merge cells using the Merge & Center command
       Applying number formats
       Modifying column width
       Use the name box to select cell
       Other ways to select cells

      3. Add a chart (1 hour)
       Add a chart
       Apply a style to a chart
       To move a chart to a new sheet
       To change the sheet tab name
       Printing in Landscape

      4. Auto calculate area (1 hour)
       Use the auto calculate area to determine a maximum
       Use the auto calculate area to determine a minimum
       Use the auto calculate area to determine sum
       Use the auto calculate area to determine average
       Use the auto calculate area to count numbers

      5. Correcting errors (0.5 hour)

       Correcting errors while entering data
       Undoing last entry
       Clearing a cell or a range
       Clearing the entire worksheet

      3. MODULE 2: Formulas, Functions and Formatting

      1. Titles & fill (0.5 hour)
       Entering worksheet, columns, and rows titles
       Flash Fill
       Autofill options

      2. Entering formulas (1 hour)
       Arithmetic/Basic operations
       Order of Operations
       Entering formulas using Point & Click
       Copy formulas using the fill handle
       Using the AUTOSUM button
       Range Finder

      3. Formatting the Worksheet (0.5 hour)
       To change workbook theme
       Merge and Center
       Background color
       Apply border
       Apply accounting, dates, currency and percent formats
       Conditional formatting
       Changing row height

      4. checking spelling (0.5 hour)
       Check spelling on worksheet
       Additional spelling checker

      5. Printing the worksheet (1 hour)
       Change printing margins, header & orientation, fit page
       Print the worksheet
       Print a selection of it
       Displaying & printing the formulas

      6. Most used formulas (1 hour)

       IF, IFS
       SUM, SUMIF, SUMIFS
       COUN,COUNTIF, COUNTIFS
       LEFT
       RIGHT
       LEN
       CONCATENATE

      Program Day & Time:  

      Individual programs will be scheduled as per instructor’s and student’s availability. Please contact us to schedule the class.

      Class Registration Information:

      New Students: Please ‘Register’ to sign up for our courses.

      Returning Students: Please click here to register for the course.

      Class Duration & Fee:

      Pricing is in Canadian Dollars

      Listed fee is for 15 hours to complete the course.

      Meet The Program Instructor:

      Meet The Program Instructor:

      EmpoweredProfessionals are a Team of Professionals who are Specialists and Leaders in their disciplines of work.

      At EmpoweredProfessionals our Professional Team assist fellow professionals and organizations, by transferring their in-depth knowledge and creating innovative functions and platforms to empower and build skills and confidence to accomplish a fast-track route to career and professional advancement.

      Click  To Connect to EmpoweredProfessionals Website For Instructor Details

      • Financial Analysis

      Information on Class Details, Program Fee & Discount Packages: 

      Please refer to the Course FAQ page listed on ‘ All Courses’ 

      Questions:

      Please contact our Admin team at:  info@studentscholarscentre.com or 905-604-7740

       

      Course Features

      • Lectures 0
      • Quizzes 0
      • Duration School Year
      • Skill level All levels
      • Language English
      • Students 0
      • Assessments Yes
      CoursesProfessional CoursesIntroduction To ExcelIntroduction To Microsoft Excel-Individual-Online
      • Click Zoom Link Below to Access Zoom Online Class 0

        No items in this section
      • Lesson 1 0

        No items in this section
      • Lesson 2 0

        No items in this section
      • Lesson 3 0

        No items in this section

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5
      0%
      4
      0%
      3
      0%
      2
      0%
      1
      0%
      author avatar
      Empowered Professionals
      • Overview
      • Curriculum
      • Reviews
      • Instructor
      $750.00
      • Share:

      You May Like

      Physics – Individual – High School Read More
      Amir Nejah

      Physics - Individual - High School

      0
      0
      $25.00
      Guitar Lessons- Individual -All Ages – Online Read More
      Ara Arakelyan

      Guitar Lessons- Individual -All Ages - Online

      0
      0
      $25.00
      French- Individual – Ages 2-4 -Online Read More
      StudentScholars

      French- Individual - Ages 2-4 -Online

      0
      0
      $20.00
      English – Individual – Ages 2-4 -Online Read More
      StudentScholars

      English - Individual - Ages 2-4 -Online

      0
      0
      $20.00
      Mastering Math – Individual – Ages 2-4 -Online Read More
      StudentScholars

      Mastering Math - Individual - Ages 2-4 -Online

      0
      0
      $20.00

      (+1) - 905-604-7740

      info@studentscholarscentre.com

      7725 Birchmount Road, Unit 38 Markham ON, L3R 9X3, Canada

      Company

      • Who We Are
      • Contact Us/ Location
      • FAQ
      • Blog
      • Sales & Marketing

      Links

      • Courses
      • Request A Class
      • Returning Students
      • International Students
      • Teach
      • Collaborate With Us
      • Schools & Organizations

      Social media

      Copyright StudentScholars Academic, Art & Music Centre © 2020

      • Privacy Policy
      Modal title

      Message modal