ID : 32029

Tuition, Computer Lessons, Microsoft Excel

Description

Type : Jobs
Condition : Part time
Warranty : No
Location : Shepherds Bush, London, UK

I am an experienced IT Teacher offering tuition in Microsoft Office Excel.

All handouts are provided and each lesson has exercises for you to practise in class or at home if you wish. Lessons are on a one to one basis.

Lessons are in my place in Shepherds Bush. I am opposite to Shepherds Bush Central Line Tube Station and Shepherds Bush Overground Station.

I am offering tuition for people interested in learning Excel covering the common skills required to work in an office environment.

Please note: I only offer tuition in Excel for somebody who wishes to learn the software. I do not offer to solve the problems you might have at your work place.

Tuition price:

£25.00 for 1 hour

£33.00 for 1½ hour

£40.00 for 2 hours 

Overview of what you will learn:

Excel

Lesson 1: Building an Excel Worksheet

Creating a spreadsheet from scratch

Entering formulas to calculate %

Copying formulas

Sum Function

Creating and copying a line

Formatting data: bold, currency format, align labels, font and font size

Printing

Lesson 2: Creating Charts

Create common charts: Line, Column, XY Scatter and Pie

Adding Y and X axis

Gridlines display

Changing the chart type

Moving charts to a new sheet

Formatting axis

Placing and formatting data labels (in pies)

Inserting a text box in a chart

Lesson 3: Building an Investment Worksheet

Entering data for buying and selling

Entering formulas to calculate commission, total cost and profit/loss

IF function

Inserting and deleting rows

Copying formulas

Merging and centring section headings

Formatting cells with: a shortcut and Format Painter

Lesson 4: Managing Data in Lists

Displaying column labels in two lines

Copying data from another file

Entering formulas to calculate tax and total amount

Maintaining a list with a data form

Adding the form button to the Quick Access Toolbar

Entering data using the data form

Finding records specifying criteria

Editing records using the data form

Lesson 5: Working with Filters

Filtering data with various criteria

Copying filtered data from one sheet to another

Sorting filtered data

Displaying gridlines on the screen and on printouts

Freezing the top row / other rows or columns

Creating, viewing and deleting comments

Format data as a table

Lesson 6: Working with Projection and Functions: Sum, Counta, Average

Calculating with Sum function

Amending data

Inserting and deleting rows

Projection

Working with Paste Special

Calculating with the Counta function

Calculating with the Average function

Scaling the page for printing

Changing margins and orientation

Saving the file with a password

Lesson 7: Calculating Income, Expenditure and Profit/Loss

Linking cells from another file

Naming a cell

Calculating using the named cell

Calculating: income, expenditure and profit/loss

Formatting loss figures

Protecting/unprotecting a worksheet

Encrypting a workbook

Converting a file to a PDF

Lesson 8: Working with Several Sheets and Linking Data Between them

Formatting a sheet to update new entries

Renaming a sheet

Copying the data to another sheet

Adjusting column width

Colouring the cells

Linking cells from one sheet to another

Entering new data in linked sheets

Editing data in linked sheets

Lesson 9: Calculating with Absolute Cell Reference

Centring the title across all columns with data

Calculating with absolute cell reference

Displaying formulas

Calculating with Min and Max functions

Displaying a footer

Displaying gridlines and column headings for printing

Printing selected data showing formulas

Lesson 10: Working with Columns, Rows and Functions: If, Count, Countif

Wrapping column headings

Framing section headings by a border

Inserting columns

Sorting the data

Calculating using absolute cell reference and named cell

Calculating using If, Count and Countif functions

Hiding and unhiding columns and rows 

 

 

Location

Shepherds Bush, London, UK
Write a Review
ad type Jobs ad type

Send Messages

Send Message
Safety tips
  • If an ad or reply sounds too good to be true, it probably is
  • Meet face to face, never send payment for items you've not seen
  • Don't ship items - always trade face to face
  • Don't use Western Union, MoneyGram or other payment methods to Send Money Online for QuickMarket trades
  • Always communicate on the website with the traders  for your safety and privacy
  • Don't reply to email addresses hidden in text
  • Beware of fake QuickMarket sites and invoices
  • If You receive email from unknown sender, Do not click on links and pictures in the email
  • Don't carry large sums of money with you when meeting up
  • Tell others when/where you're going to trade, and bring a friend

Featured Ads

Recent Ads

Top