Excel 2007 Simplified

101 quick tips and tricks to master Excel 2007.
4.8 (2 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
17 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 103
  • Length 7.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster.

If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing!

We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects.

We'll cover:

  • Working with Data - using series, symbols and special characters, hide rows and freeze panels
  • Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums
  • Copying Data - transposing rows into columns and paste specials
  • Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list
  • Data Patterns - Pivot tables, pivot charts, what-if analysis
  • Creating charts - histogram, trendlines, piecharts, error bars
  • Presenting data - formatting columns and numbers
  • Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column
  • Extending excel - hyperlinks, embed a chart, importing a worksheet
  • Customizing Excel - custom workspace, custom view, macros

The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010.

Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along.

The course will take approx 7.5 hours to complete.

Take this course if you want to take your basic understanding of Excel to a higher intermediate-level.

What are the requirements?

  • Students will need to have Excel 2007 installed, as this is the system used in the teaching

What am I going to get from this course?

  • Work with Formulas and Functions
  • Copy data and formats
  • Use excel lists
  • Create charts
  • Present worksheets nicely
  • Save and print worksheets

What is the target audience?

  • This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007
  • You should know the "basics" in Excel and we take it from near-beginner, to higher intermediate

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to the course and your tutor
02:47

Please see lecture 2, to download the template that we'll work with. There are various templates to download. Normally, they're at the start of each section. Thanks.

Section 2: Data
Enter numbers and fractions
05:00
Dates and Times
07:46
03:45

Download the template workbook and have a go at the same examples as the tutor.

Validate Data entry using a pick list
Preview
07:34
04:18

You can extend a time increment series an hour at a time. Type any number in the step value of the series dialog box.

03:56

Excel fonts are based on Unicode. To use a language other than English and set up the appropriate keyboard, click the Windows Start Menu, click Control Panel and click Regional and Language Options.

Compare multiple spreadsheets using freeze panels
06:08
Hide rows
04:24
09:58
  • Alt + Underscored letter of the menu name > Select a menu from an Excel menu
  • Alt + Enter > Display the choices in a drop-down menu
  • Shift + Tab > Move to the previous item
  • Ctrl +PageDown or PageUp > Move to the next or previous worksheet in a woekbook

Excel shortcuts

03:48

Speech recognition is no longer in Excel 2007 ... use F1 to find out more. But there is Speak Cells. So excel can read your cells to you.

Find and replace data
10:35
Section 3: Formulas and Functions
Add values
03:08
06:07

Try rounding 2125.123 to -2 ... the answer is 2100.000. Note - the 2,1000.000 preserves the number of digits of the original number, but rounds two places to the left of the decimal point.

Formulas with comments
Preview
04:32
OneNote
05:43
Define a constant
04:01
Apply names in functions
04:50
Figure out the best loan terms
04:23
Internal Rates of Return
04:16
Nth largest value
03:53
Large, Small, Max, Min
04:38
Conditional formula
02:59
Conditional formula with names
03:58
Count If
02:02
Conditional sum
02:53
Inner calculator
Preview
02:32
Square Roots
03:06
Calculate the duration between two times
04:07
Calculate days between two dates
04:28
Section 4: Copying Data, Formats etc.,
Copy a range
03:01
Transpose a row into a column
Preview
01:40
Copy styles to another workbook
07:29
Chart formatting
07:14
06:26

And copying sheets within the workbook

Track changes while Editing
06:03
Section 5: Lists
Enter list data using a form
04:39
Searching through a data list
04:15
Import a word list into excel
04:36
Sort a list
01:58
Filter a list
02:37
Sort by multiple criteria
02:58
Find averages in a sorted group
05:07
Filter by multiple criteria
Preview
03:07
Remove duplicate records from a list
03:03
Count filtered records
06:51
Filter by multiple criteria in the same column
06:03
Chart a filtered list
02:24
Look up information in a List
05:08
Section 6: Data Patterns
Create a PivotTable
05:29
Modify a PivotTable and layout
02:53
Find the average of a field
04:01
Create a calculated field
03:57
Calculated fields and charts
Preview
01:55
Hide rows and columns in a PivotTable
01:59
AutoFormat a PivotTable
01:14
Create a PivotChart
03:01
Turning on the Data Analysis function so that statistical information can be run
02:27
Describe Data with Statistics
02:59
03:30

Note - with correlations the answer is anywhere between -1 and +1. If its negative, the relationship is negative eg as age increases, batting averages decreases.... A Positive result (closer to +1) is that as the number of years in sales increases, sales increases.

Product Numbers
01:46
What-if analysis
05:11
Goal seek
06:20
Section 7: Creating Charts
Create a Chart
05:42
Modify Chart details
04:02
Change the Chart Type
03:36
Add a Trendline to a Chart
06:19
Remove Chart Data
01:53
Add chart data
02:05
Missing chart data
04:14
Error bars
03:55
Pull a slice from a Pie Chart
03:04
Label slices of a Pie Chart
04:01
Histogram
06:21
Paste a chart into Word
03:26
Amending a chart in Word
02:04
Paste-link a Chart into Word
04:40
Section 8: Worksheets
Format Numbers as Percentages
03:41
Format Currencies in Currency and Accounting Formats
03:24
Format Column Headings
05:07
Format Quickly with Format painter
Preview
02:25
Insert a background image into your worksheet
02:48
Create a Transparent image
03:08
Section 9: Saving and Printing Worksheets
Save a workbook as a Template
06:50
Save a workbook as an XML spreadsheet
05:02
Print multiple cell ranges on One Page
03:04
Page set up, header, footer, margins - 1 page printing
04:24
Print multiple areas of a workbook
07:56
Print multiple worksheets of a workbook
01:19
Repeat Headings of a Row or Column
07:11
Print functions to show calculations & comments
07:19

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Lisa Newton, Entrepreneur & Serial Author

Lisa Newton BA MSc FMAAT has a masters degree in Investment Management and a first class honours degree in Accounting with Marketing. She formed her first company in 2004 with £150 in the same month of graduating from City University, London UK. Lisa has never had a full time 9 to 5 job in her life. She's a serial entrepreneur and author who holds directorships in various industries including telecoms, software, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007 and in 2008 Enterprising Business Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award.

Lisa's books include: How to write a book in two weeks, Constant Cashflow, Make the most of your money, How to start your own bookkeeping business, Cosmic ordering with Vision Boards and Quickbooks Online The Handbook. Some of the books are in audio-format on itunes and audible.

Lisa supports the charity The MS Society. A speaker, coach, consultant and an avid networker, Lisa enjoys meeting people and working on projects with like-minded individuals.

In her spare time, Lisa likes traveling, dancing salsa, writing books, learning languages, meditation and cosmic ordering.

Ready to start learning?
Take This Course