ID : 32029
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