Excel 2007 Simplified
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.
19 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2007 Simplified to your Wishlist.

Add to Wishlist

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.
19 students enrolled
Created by Lisa Newton
Last updated 4/2016
English
Price: $25
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Work with Formulas and Functions
Copy data and formats
Use excel lists
Create charts
Present worksheets nicely
Save and print worksheets
View Curriculum
Requirements
  • Students will need to have Excel 2007 installed, as this is the system used in the teaching
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 103 Lectures Collapse All 103 Lectures 07:33:20
+
Introduction to the course and your tutor
1 Lecture 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.

Preview 02:47
+
Data
11 Lectures 01:07:12
Enter numbers and fractions
05:00

Dates and Times
07:46

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

Name Cells and Ranges
03:45


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

Extend a series of dates with autofill
04:18

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.

Add a symbol or special character
03:56

Compare multiple spreadsheets using freeze panels
06:08

Hide rows
04:24

  • 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

Keyboard
09:58

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.

Speak Cells
03:48

Find and replace data
10:35
+
Formulas and Functions
18 Lectures 01:11:36
Add values
03:08

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.

Function wizard
06:07


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


Square Roots
03:06

Calculate the duration between two times
04:07

Calculate days between two dates
04:28
+
Copying Data, Formats etc.,
6 Lectures 31:53
Copy a range
03:01


Copy styles to another workbook
07:29

Chart formatting
07:14

And copying sheets within the workbook

Paste special and copying worksheets
06:26

Track changes while Editing
06:03
+
Lists
13 Lectures 52:46
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


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
+
Data Patterns
14 Lectures 46:42
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


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

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.

Discover associations within your data
03:30

Product Numbers
01:46

What-if analysis
05:11

Goal seek
06:20
+
Creating Charts
14 Lectures 55:22
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
+
Worksheets
6 Lectures 20:33
Format Numbers as Percentages
03:41

Format Currencies in Currency and Accounting Formats
03:24

Format Column Headings
05:07


Insert a background image into your worksheet
02:48

Create a Transparent image
03:08
+
Saving and Printing Worksheets
8 Lectures 43:05
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
+
Extending Excel
6 Lectures 34:51
Hyperlink a worksheet to another office document
02:48

Embed a chart within PowerPoint
05:46

Publish an Interactive Workbook
05:05

Importing data from a Web Site or Access Database
02:26

Import a Worksheet into Access
08:56

Use Excel Data to create labels in Word
09:50
2 More Sections
About the Instructor
Lisa Newton
4.0 Average rating
207 Reviews
3,159 Students
80 Courses
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, property management, publishing, hair & beauty as well as finance. She has won various awards in Business including: Young Entrepreneur of the Year Award 2007, in 2008 Enterprising Business Award, in 2016 BE Mogul Award and has been nominated and shortlisted in numerous others. In 2011 and in 2012 one of her companies won Best Accounting Franchisor Award. In 2015 and 2017 one of her companies won Best Bookkeeping Business London (Accountancy International Awards).

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, How to Franchise Your Business 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, yoga and cosmic ordering.