Samuel - Microsoft excel tutor - Newcastle
1st lesson free
Samuel - Microsoft excel tutor - Newcastle

Samuel profile and its contact details have been verified by our team.

Samuel

  • Rate $15
  • Response 1h
  • Students

    Number of students Samuel has accompanied since arriving at Superprof

    1

    Number of students Samuel has accompanied since arriving at Superprof

Samuel - Microsoft excel tutor - Newcastle

$15/h

1st lesson free

Contact

1st lesson free

1st lesson free

  • Microsoft Excel

Graduate of Computer Science. IBM Certified Data Analyst with advanced knowledge of Microsoft Excel, Python and SQL.

  • Microsoft Excel

Lesson location

About Samuel

I am an jovial and interesting young tutor with passion for teaching. I love sharing knowledge using the most fun-filled methods, , thereby mixing knowledge with fun.From experience, my students love interacting with me and such a comfortable environment makes learning effective.
I look forward to sharing my best knowledge to you andmaking you an expert in using Microsoft Excel for needed tasks.

See more

About the lesson

  • Elementary School
  • Middle School
  • High School
  • +12
  • levels :

    Elementary School

    Middle School

    High School

    Première

    College

    Adult Education

    Masters/ Graduate School

    Doctorate

    Early childhood education

    Beginner

    Intermediate

    Advanced

    Proficient

    Autres

    Children

  • English

All languages in which the lesson is available :

English

My teaching is project based.
I take each lesson, by leading my students on little projects,demonstrating the tools for that lesson. At the end ofAl the lessons, multiple projectswould have been completed.

Age range is 8 -45 years old.

SYLLABUS:

Section 1:
1. Launching Excel
2. Microsoft Excel Startup Screen
3. Introduction to the Excel Interface
4. Customizing the Excel Quick Access Toolbar
5. More on the Excel Interface
6. Understanding the Structure of an Excel Workbook
7. Saving an Excel Document
8. Opening an Existing Excel Document
9. Common Excel Shortcut Keys
10. Excel Fundamentals

Section 2
1. Entering Text to Create Spreadsheet Titles
2. Working with Numeric Data in Excel
4. Entering Date Values in Excel
5. Working with Cell References
6. Creating Basic Formulas in Excel
7. Relative Versus Absolute Cell References in Formulas
8. Understanding the Order of Operation
9. Entering and Editing Text and Formulas
10. Quiz

Section 3: Functions
1. Working with the SUM() Function
2. Working with the MIN() and MAX() Functions
3. Working with the AVERAGE() Function
4. Working with the COUNT() Function
5. Adjacent Cells Error in Excel Calculations
6. Using the AutoSum Command
7. Excel's AutoSum Shortcut Key
8. Using the AutoFill Command to Copy Formulas
9. Basic Excel Functions Quiz

Section 4:
1. Moving and Copying Data in an Excel Worksheet
2. Inserting and Deleting Rows and Columns
3. Changing the Width and Height of Cells
4. Hiding and Unhiding Excel Rows and Columns
5. Renaming an Excel Worksheet
6. Deleting an Excel Worksheet
7. Moving and Copying an Excel Worksheet
8. Modifying Worksheets Quiz

Section 5:
1. Moving and Copying Data in an Excel Worksheet
2. Inserting and Deleting Rows and Columns
3. Changing the Width and Height of Cells
4. Hiding and Unhiding Excel Rows and Columns
5. Renaming an Excel Worksheet
6. Deleting an Excel Worksheet
7. Moving and Copying an Excel Worksheet
8. Modifying Worksheets Quiz

Section 6
1. Creating an Excel Column Chart
2. Working with the Excel Chart Ribbon
3. Adding and Modifying Data on an Excel Chart
4. Formatting an Excel Chart
5. Moving a Chart to another Worksheet
6. Working with Excel Pie Charts
7. Working with Excel Charts Quiz

Section 7: Data Analytics
1. Formulas
2. XLookup
3. Data Cleaning for Analysis
3. Creating a Dashboard

See more

Rates

Rate

  • $15

Pack rates

  • 5 h: $75
  • 10 h: $150

online

  • $15/h

free lessons

This first lesson offered with Samuel will allow you to get to know each other and clearly specify your needs for your next lessons.

  • 1hrs

Other tutors in Microsoft Excel

  • Adi

    Toronto & online

    5 (21 reviews)
    • $50/h
    • 1st lesson free
  • Ghada Maged Ali

    Toronto & online

    5 (12 reviews)
    • $40/h
  • Claudia

    Montréal & online

    5 (18 reviews)
    • $80/h
  • David

    Toronto & online

    5 (10 reviews)
    • $25/h
  • Dixit

    Kitchener & online

    5 (13 reviews)
    • $40/h
  • Maaz

    Vancouver & online

    5 (13 reviews)
    • $50/h
    • 1st lesson free
  • Mustafa

    Calgary & online

    5 (10 reviews)
    • $45/h
    • 1st lesson free
  • Sara

    Montreal & online

    5 (12 reviews)
    • $40/h
    • 1st lesson free
  • Nilima

    Toronto & online

    5 (10 reviews)
    • $45/h
  • DURGA PRAVEENA

    Toronto & online

    4.9 (7 reviews)
    • $30/h
    • 1st lesson free
  • Romeo

    Calgary & online

    5 (12 reviews)
    • $40/h
    • 1st lesson free
  • Wumi

    Guelph & online

    5 (6 reviews)
    • $25/h
    • 1st lesson free
  • Amrit

    Burlington & online

    5 (5 reviews)
    • $40/h
    • 1st lesson free
  • Ayo

    Toronto & online

    5 (4 reviews)
    • $20/h
    • 1st lesson free
  • Sourabha

    Brampton & online

    5 (8 reviews)
    • $49/h
  • Lopez

    Toronto & online

    5 (23 reviews)
    • $45/h
    • 1st lesson free
  • Mark

    Toronto & online

    5 (18 reviews)
    • $35/h
    • 1st lesson free
  • Rahul

    Mississauga & online

    5 (8 reviews)
    • $60/h
  • Ahmed

    Saskatoon & online

    5 (4 reviews)
    • $29/h
    • 1st lesson free
  • Aaron Darius

    Mississauga & online

    5 (9 reviews)
    • $45/h
  • More Microsoft Excel tutors