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

Samuel's profile and their contact details have been verified by our experts

Samuel

  • Price $15
  • Answer 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

  • Primary School
  • High School
  • Year 10
  • +14
  • levels :

    Primary School

    High School

    Year 10

    Year 11-12

    TAFE

    Adult

    Undergraduate

    Diploma/Certificate

    Postgraduate

    PhD

    Early childhood education

    Beginner

    Intermediate

    Advanced

    Professional

    Adult

    Kids

  • 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

Price

  • $15

Pack prices

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

online

  • $15/h

free lessons

The first lesson with Samuel will allow you to get to know each other and discuss your needs for future lessons.

  • 1hr

Similar Microsoft Excel tutors in Newcastle

  • Kate

    Newcastle & online

    New
    • $50/h
    • 1st lesson free
  • Bryce

    Newcastle & online

    New
    • $56/h
    • 1st lesson free
  • Noa

    Newcastle & online

    New
    • $51/h
    • 1st lesson free
  • Ivy

    Newcastle & online

    New
    • $53/h
    • 1st lesson free
  • Ria

    Newcastle & online

    New
    • $35/h
    • 1st lesson free
  • Amaira

    Newcastle & online

    New
    • $48/h
    • 1st lesson free
  • Arnav

    Newcastle & online

    New
    • $48/h
    • 1st lesson free
  • Anika

    Newcastle & online

    New
    • $42/h
    • 1st lesson free
  • Finley

    Newcastle & online

    New
    • $58/h
    • 1st lesson free
  • Suri

    Newcastle & online

    New
    • $50/h
    • 1st lesson free
  • Elias

    Newcastle & online

    New
    • $52/h
    • 1st lesson free
  • Leona

    Newcastle & online

    New
    • $57/h
    • 1st lesson free
  • Bennett

    Newcastle & online

    New
    • $49/h
    • 1st lesson free
  • Mara

    Newcastle & online

    New
    • $54/h
    • 1st lesson free
  • Saisha

    Newcastle & online

    New
    • $49/h
    • 1st lesson free
  • Sanya

    Newcastle & online

    New
    • $45/h
    • 1st lesson free
  • Sulav

    Newcastle & online

    New
    • $35/h
    • 1st lesson free
  • Stella

    Newcastle & online

    New
    • $58/h
    • 1st lesson free
  • Bryce

    Newcastle & online

    New
    • $53/h
    • 1st lesson free
  • Keerthi

    Newcastle & online

    New
    • $43/h
    • 1st lesson free
  • More Microsoft Excel teachers