• Home
  • Remote Education Assistance
  • Class Video Links
  • Computers and your family
  • About

Steve Simpson, Glendale College Computer Instructor

~ Designed For My Students, Friends and Family!

Steve Simpson, Glendale College Computer Instructor

Category Archives: Excel

10 incredibly useful Excel keyboard shortcuts

10 Tuesday Jul 2018

Posted by simpsongcc in Excel, GCC, Microsoft Office

≈ Leave a comment


10 incredibly useful Excel keyboard shortcuts

Beginners Guide to MS Excel

31 Thursday May 2018

Posted by simpsongcc in Excel, GCC, Microsoft Office

≈ Leave a comment


The-Beginner_s-Guide-to-Microsoft-Excel

Never Forget to Check These Excel Document Settings

29 Tuesday Aug 2017

Posted by simpsongcc in Excel, GCC, Microsoft Office, Security Issues

≈ Leave a comment


Never Forget to Check These Excel Document Settings

Excel 2016 cheat sheet

11 Thursday May 2017

Posted by simpsongcc in Excel, GCC, Office 365

≈ Leave a comment


Excel 2016 cheat sheet

Classes Start Next Week!

25 Thursday Aug 2016

Posted by simpsongcc in Excel, GCC, Windows 10, Word

≈ Leave a comment


Hello all. I hope you have had a great summer! will be starting my classes next week. First up will be Excel Tuesday and Thursday evenings at 5:30. Saturday morning at 8 will be Word. This will be the first time I will have taught Word on a Saturday. So for those beginners out there that would like to take Word on a weekend, this is a rare opportunity.

Tons of new stuff awaits you! We have new computers on the desktop and they are nice! We are now officially teaching Windows 10 and it is the default OS on the computers now. Also, we have upgraded to the newest version of Office…2016.

The biggest change will be how we teach. NO MORE BOOKS REQUIRED….for any class. Why you may ask, because everything will be web based. You are going to get access to all kinds of online training and an eBook for free! You will be able to access these resources from any computer with an internet connection.

So lots of exciting changes! Hopefully I’ll see you all next week!

Microsoft releases task tracking Planner app for Office 365

06 Monday Jun 2016

Posted by simpsongcc in Excel, GCC, Integrated Technology, New Technology, Office 365, Outlook

≈ Leave a comment


Note: You should see this new tool in the free education accounts from GCC!

Microsoft releases task tracking Planner app for Office 365

Welcome Excel Level 2 Students!

05 Thursday May 2016

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Thank you for your attendance. I am looking forward to the next 6 weeks together. I promise to make the class as enjoyable as possible, while teaching you all about Excel! The book ISBN for this class is Benchmark Excel 2013 L1&L2, 9780763853891. The Excel 2013 Level 2 only is 9780763853914. I would suggest looking for a used book at Amazon.com or half.com. It should save you some money.

 

Apple’s iPhone is most influential gadget ever, says TIME

05 Thursday May 2016

Posted by simpsongcc in Excel, Integrated Technology, Intro to Computers, New Technology

≈ Leave a comment


Interesting list and I mostly agree with it.

Apple’s iPhone is most influential gadget ever, says TIME

11 Excel tips for power users

02 Monday May 2016

Posted by simpsongcc in Excel, GCC, Office 365

≈ Leave a comment


This is a good list of tips for using Excel

11 Excel tips for power users

 

How Excel logical functions can do the number-crunching work for you

30 Wednesday Mar 2016

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Video on Excel logical functions

How Excel logical functions can do the number-crunching work for you

Bonus!

How to add a checkbox in Excel, a small but powerful data tool for spreadsheets

Excel functions: How to work with dates

Welcome Excel 1 Students!

15 Tuesday Mar 2016

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Thank you for your attendance. I am looking forward to the next 6 weeks together. I promise to make the class as enjoyable as possible, while teaching you all about Excel! The book ISBN for this class is Benchmark Excel 2013 L1&L2, 9780763853891. The Excel 2013 Level 1 only is 9780763853907. I would suggest looking for a used book at Amazon.com or half.com. It should save you some money. Make SURE and have it shipped expedited!

I suggest that you take a look at some of these books at Amazon as well. They will help you with the business math part of Excel.

  1. Business Math Excel Applications for Business Mathematics (2nd Edition) Paperback – August 29, 2008 by Edward D. Laughbaum (Author), Ken Seidel (Author), ISBN: 9780136071846
  2. Excel For Business Math (Quick Study: Computer) Hardcover – December 31, 2013
    by Inc. BarCharts (Author)
  3. Microsoft Excel 2010 Formulas and Functions Inside Out Paperback – January 1, 2012 by Egbert Jeschke (Author), Helmut Reinke (Author), Sara Unverhau (Author), Eckehard Pfeifer (Author), ISBN: 978-0735658028
  4.  Excel Formulas and Functions For Dummies, by Ken Bluttman
  5. Business Math Using Excel, by Sharon Burton and Nelda Shelton
  6. Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations, by Alastair Day
  7. Working with Excel: Refreshing Math Skills for Management (Quantitative Approaches to Decision Making), by Priscilla Chaffe-Stengel

Here is an article with some Excel tips!

http://www.computerworld.com/article/2907515/your-excel-formulas-cheat-sheet-15-tips-for-calculations-and-common-tasks.html?phint=newt%3Dcomputerworld_thisweek&phint=idg_eid%3De6a70c0a773b5dd93399e3283c15a855#tk.CTWNLE_nlt_thisweek_2015-04-13

Welcome Excel Level 1 Students

12 Tuesday Jan 2016

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Happy 2016! Thank you for your attendance. I am looking forward to the next 6 weeks together. I promise to make the class as enjoyable as possible, while teaching you all about Excel! The book ISBN for this class is Benchmark Excel 2013 L1&L2, 9780763853891. The Excel 2013 Level 1 only is 9780763853907. I would suggest looking for a used book at Amazon.com or half.com. It should save you some money. Make SURE and have it shipped expedited!

I suggest that you take a look at some of these books at Amazon as well. They will help you with the business math part of Excel.

  1. Business Math Excel Applications for Business Mathematics (2nd Edition) Paperback – August 29, 2008 by Edward D. Laughbaum (Author), Ken Seidel (Author), ISBN: 9780136071846
  2. Excel For Business Math (Quick Study: Computer) Hardcover – December 31, 2013
    by Inc. BarCharts (Author)
  3. Microsoft Excel 2010 Formulas and Functions Inside Out Paperback – January 1, 2012 by Egbert Jeschke (Author), Helmut Reinke (Author), Sara Unverhau (Author), Eckehard Pfeifer (Author), ISBN: 978-0735658028
  4.  Excel Formulas and Functions For Dummies, by Ken Bluttman
  5. Business Math Using Excel, by Sharon Burton and Nelda Shelton
  6. Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations, by Alastair Day
  7. Working with Excel: Refreshing Math Skills for Management (Quantitative Approaches to Decision Making), by Priscilla Chaffe-Stengel

Here is an article with some Excel tips!

http://www.computerworld.com/article/2907515/your-excel-formulas-cheat-sheet-15-tips-for-calculations-and-common-tasks.html?phint=newt%3Dcomputerworld_thisweek&phint=idg_eid%3De6a70c0a773b5dd93399e3283c15a855#tk.CTWNLE_nlt_thisweek_2015-04-13

Excel formulas cheat sheet

13 Monday Apr 2015

Posted by simpsongcc in Excel

≈ 1 Comment

Tags

Excel


Here is an article with some Excel tips!

http://www.computerworld.com/article/2907515/your-excel-formulas-cheat-sheet-15-tips-for-calculations-and-common-tasks.html?phint=newt%3Dcomputerworld_thisweek&phint=idg_eid%3De6a70c0a773b5dd93399e3283c15a855#tk.CTWNLE_nlt_thisweek_2015-04-13

Welcome Excel Level 1 Students!

07 Wednesday Jan 2015

Posted by simpsongcc in Excel, GCC

≈ Leave a comment

Tags

Excel, Office 2013


Happy 2015! Thank you for your attendance. I am looking forward to the next 6 weeks together. I promise to make the class as enjoyable as possible, while teaching you all about Excel! The book ISBN for this class is Benchmark Excel 2013 L1&L2, 9780763853891. The Excel 2013 Level 1 only is 9780763853907. I would suggest looking for a used book at Amazon.com or half.com. It should save you some money. Make SURE and have it shipped expedited!

I suggest that you take a look at some of these books at Amazon as well. They will help you with the business math part of Excel.

  1. Business Math Excel Applications for Business Mathematics (2nd Edition) Paperback – August 29, 2008 by Edward D. Laughbaum (Author), Ken Seidel (Author), ISBN: 9780136071846
  2. Excel For Business Math (Quick Study: Computer) Hardcover – December 31, 2013
    by Inc. BarCharts (Author)
  3. Microsoft Excel 2010 Formulas and Functions Inside Out Paperback – January 1, 2012 by Egbert Jeschke (Author), Helmut Reinke (Author), Sara Unverhau (Author), Eckehard Pfeifer (Author), ISBN: 978-0735658028
  4.  Excel Formulas and Functions For Dummies, by Ken Bluttman
  5. Business Math Using Excel, by Sharon Burton and Nelda Shelton
  6. Mastering Financial Mathematics in Microsoft Excel: A Practical Guide for Business Calculations, by Alastair Day
  7. Working with Excel: Refreshing Math Skills for Management (Quantitative Approaches to Decision Making), by Priscilla Chaffe-Stengel

Welcome Excel Level 2 Students!

06 Monday Oct 2014

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Thank you for your attendance. I am looking forward to the next 6 weeks together. I promise to make the class as enjoyable as possible, while teaching you all about Excel! The book ISBN for this class is Benchmark Excel 2013 L1&L2, 9780763853891. The Excel 2013 Level 2 only is 9780763853914. I would suggest looking for a used book at Amazon.com or half.com. It should save you some money.

Welcome Excel Summer Students

26 Thursday Jun 2014

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Welcome to everyone taking my summer Excel Level 1 class. We do still have a few seats left for the Tuesday and Thursday 5:30-9:30 class available if you want to join us. It is a 6 week class and you will need a book. The ISBN numbers for the book are either 9780763843113 or 9780763843144. Amazon had a few used ones at a very low price. I look forward to spending my evenings with you!

Differences between the Office Suites

11 Friday Oct 2013

Posted by simpsongcc in Excel, GCC, Outlook, PowerPoint, Word

≈ 1 Comment


I often get asked what the differences are between different versions of Microsoft Office. Here is a couple of websites that gives you some of that information….

http://www.microsoft.com/business/en-ie/Whats-new/Pages/Article.aspx?cbcid=75

http://technet.microsoft.com/en-us/library/cc178954.aspx

http://blogs.gartner.com/guy-creese/2012/07/17/office-2013-vs-2010/

 

 

 

Welcome Excel Level 2 Students!

11 Friday Oct 2013

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Welcome to Excel 2010 level 2! I am so happy you are attending this class. I know you will find it interesting, educational, and hopefully very enjoyable. Check back often at this website for any information or links that I may refer to in class. If I have any handouts, you will find them mentioned here or may be in the list in the Excel folder on the right. The book for this class has the ISBN number of 978-0-76384-315-1 and I encourage you to check for used ones on http://www.Amazon.com . There is a Level 1 and Level 2 book, ISBN 9780763843106. It might be cheaper. I look forward to our time together. Thank you for coming!

Contract Information: (626) 256-0302 https://simpsongcc.wordpress.com simpsongcc@live.com

 

Excel Students

23 Saturday Feb 2013

Posted by simpsongcc in Excel, New Technology

≈ Leave a comment


Welcome to Beg. Excel 2010! I am so happy you are attending this class. I know you will find it interesting, educational, and hopefully very enjoyable. Check back often at this website for any information or links that I may refer to in class. If I have any handouts, you will find them mentioned here or may be in the list in the Excel folder on the right. The book for this class has the ISBN number of 978-0-76384-314-4 and I encourage you to check for used ones on http://www.Amazon.com . I look forward to our time together. Thank you for coming!

Contract Information: (626) 256-0302 https://simpsongcc.wordpress.com simpsongcc@live.com

  • How Computers Work
  • History of Computers
  • How software works
  • History of Windows
  • History of Apple OS
  • Comparison of OSs
  • Future of Technology
  • Honda Robotics
  • A Day with glass – Corning – Part 1
  • A Day with Glass – Corning – Part 2
  • Ray Kurzweil
  • TED

Microsoft Office announcement!

22 Monday Oct 2012

Posted by simpsongcc in Excel, GCC, Outlook, PowerPoint, Word

≈ Leave a comment


Here is a really good deal for students.

http://blogs.office.com/b/office-news/archive/2012/10/19/office-365-university-for-higher-education-students.aspx

Welcome Excel Level 1 students!

08 Saturday Sep 2012

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


Welcome Level 1 Excel students! I am so happy to have you in my class. I look forward to the 6 weeks we will spend together. I promise to make it as enjoyable and as informative as possible. The book we will be using in class is new. The ISBN for the Level 1 book is 978-0-76384-311-3 (with CD), 978-0-76384-314-4 (without CD). Used books are very hard to find since this is a very new book but Amazon does have some.

As discussed in class, this website is where you will find additional information for class. Below are some helpful links for getting strated in the new 2010 software and specifically, Excel.

Contract Information: (626) 256-0302 https://simpsongcc.wordpress.com simpsongcc@live.com

Getting started with Office 2010

Getting started with Excel 2010

Cheat Sheets

Advanced Excel Students

26 Wednesday Oct 2011

Posted by simpsongcc in Excel, General Info

≈ Leave a comment


Here are some tutorials and tips and howtos on specific topics that are always difficult to master.

I recommend that you take advantage of them!

VLOOKUP: http://office.microsoft.com/en-us/excel-help/results.aspx?filter=1&ck=1&av=zxl140&qu=VLOOKUP

PIVOT Tables: http://office.microsoft.com/en-us/excel-help/results.aspx?filter=1&ck=1&av=zxl140&qu=PivotTable

Welcome Excel Level 2 Students!

12 Wednesday Oct 2011

Posted by simpsongcc in Excel, General Info

≈ Leave a comment


Welcome Level  2 Excel students! I am so happy to have you in my class. I look forward to the 6 weeks we will spend together. I promise to make it as enjoyable and as informative as possible. The book we will be using in class is new. The ISBN number for the Level 2 book is 9780763843151.Used books are very hard to find since this is a very new book. As discussed in class, this is where you will find additional information for class. Below are some helpful links for getting strated in the new 2010 software and specifically, Excel.

Contract Information:
(626) 256-0302
https://simpsongcc.wordpress.com
simpsongcc@live.com

Getting started with Office 2010

Getting started with Excel 2010

Cheat Sheets

Excel Level 2

30 Friday Sep 2011

Posted by simpsongcc in Excel

≈ Leave a comment


The ISBN number for the Level 2 book is 9780763843151. I have seen a few used books that have a few dollars off the list price. Good luck hunting!!!

Excel 2010 Power Point presentations

28 Wednesday Sep 2011

Posted by simpsongcc in Excel, GCC

≈ Leave a comment


I just added a link to the Power Point presentations for the Excel 2010 book. These are very helpful for reviewing the material.

← Older posts

This slideshow requires JavaScript.

Follow Steve Simpson, Glendale College Computer Instructor on WordPress.com

Hours & Info

818-813-1720
simpsongcc818@gmail.com
M,W 7:00- 11:00pm
T,TH 10:00-11:30pm
SAT, SUN 12:00-11:00pm
March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Feb    

Commercial

  • Amazon – Great place to buy used textbooks. Just get the ISBN number for the textbook you need and do a search at this site. Great deals on used textbooks.
  • Dell Refurbished Computers Short on Cash? Here is the Dell site for refurbished computers. It changes frequently and you can often find good deals on computers!
  • Dragon Naturally Speaking – Control your computer with your voice. Control your computer with your voice and dictate into Word!
  • Music – Pandora Create your own radio station.
  • Music – Spotify Listen to anything you want as long as you want!
  • Slack Please join our team and get your questions answered and share info. Our team is GCCteach.slack.com.
  • SnagShout This is a discount shopping site that connects to Amazon. Some really good deals can be found here!
  • Speccy – Detailed computer information Tells you everything you would ever what to know about your computer.
  • Twitter Don’t have twitter yet? Now might be a good time! You can follow me at @slsimpson.
  • VoIP Ooma This is one of the major Voice over IP providers.
  • VoIP Vonage This is one of the major voice over IP providers

Educational

  • Engadget's Tomorrow This is Engadget’s page that publishes articles based on tomorrow’s technology.
  • Khan Academy – Video tutorials Video tutorials on all kinds of stuff!
  • Kurzweil's Timeline to the Singularity This is Ray Kurzsweil’s timeline on technologies progress toward the singularity.
  • MIT Media Lab Check out what future technology they are working on!
  • MIT Media Lab — Research MIT Media Lab Research Projects
  • Personal Computer Information This is the Wiki site that has all kinds of information about the personal computer.
  • Ray Kurzweil's site about all things coming in the future Ray Kurzweil has been described as “the restless genius” by The Wall Street Journal, and “the ultimate thinking machine” by Forbes. Inc. magazine ranked him #8 among entrepreneurs in the United States, calling him the “rightful heir to Thomas Ed
  • Sideways Dictionary A Dictionary that uses analogies and metaphors to help regular, non-techy people understand IT terms.
  • TED: Ideas Worth Spreading Riveting talks by remarkable people, free to the world
  • Texting Lingo and Abbreviations This site will help you decipher all those texting abbreviations your kids are using!
  • Wikipedia. The encyclopedia of the Internet! Here you can find info on just about anything and it is pretty accurate!

GCC

  • Class Folder – Project Class notes for Microsoft Project
  • Class Folder – Access Files for the Access class
  • Class Folder – Excel Class info for Excel
  • Class Folder – Integrated Technology Here you will find files for my Integrated Technology class.
  • Class Folder – Internet This folder contains information for my Internet Class
  • Class folder – Intro to Computers This is my class folder where I store information about the Intro to Computers Class.
  • Class Folder – Outlook GCC class folder for Outlook class materials
  • Class Folder – Power Point This is my public folder containing information for my Power Point students.
  • Class Folder – Windows Files for Windows class
  • Class Folder – Word This folder conatins all the info for my GCC Word class.
  • Creating your own website A good site that describes the different processes for building your own site.
  • Creating your website using Google This is googles answer to creating your own site
  • Dropbox Cloud storage Here is a free site that you can store data in the cloud. Useful for back ups as well.
  • FILExt – File Extension
  • For GCC Students – Cheap Microsoft Office Software You can get a great price on Microsoft Office at this site. You just need to be a student at GCC.
  • Get a Windows Live ID A necessary item to get free use of Windows Live Essential software and a number of other Microsoft services.
  • History of Computers This is the Wiki for all things related to the history of computers. Great info!
  • History of Computers — A Timeline Here is a nice timeline describing the history of computers.
  • Mac commands compared to Windows commands This will compare the Windows commands versus the Mac commands allowing you to more easily use both types of computers.
  • Measurements List of how we measure things in the computer world.
  • PCMags Top 100 Websites
  • Photo Sharing – Smugmug A photo sharing site dedicated more toward the professionals.
  • Picture Sharing – Flikr Share your pictures here
  • Picture Sharing – Photobucket Picture sharing site.
  • Podcasting This site helps you understand podcasting and how to do it.
  • Search the web – a tutorial This is an in-depth look at searching the web to find the information you are looking for.
  • Setting up a wireless network This should help you set up a wireless network.
  • Wordpress – Learn WordPress.com

Security

  • Comodo IceDragon IceDragon features privacy and performance enhancements over the Firefox core browser as well as many additional security features such as SiteInspector malware scanning, Comodo Secure DNS and improved social media functionality.
  • Distant Desktop Free software that allows remote viewing and control of your desktop.
  • Epic Privacy Browser First web browser engineered to protect your privacy. Epic is in always-on “private browsing mode”, so on close of Epic all browsing data is deleted (while you’re browsing as little as possible is stored). Plus many other safety features!
  • Password Manager and Password Protection This program will manage, store and help you create passwords.
  • PC Matic – Excellent Anti-Virus Software My recommendation if you need new anti-virus software. 100 percent US!
  • Securing your wireless router This should help you make sure your wireless network is secure.
  • Security – Carbonite – Automated Backup for your computer at a good price This is a completely automated solution for backing up your files on your computer.
  • Security – Check to see if a virus threat is real or a hoax.
  • Security – Check to see if that virus is real or a hoax.
  • Security – Darik's Boot And Nuke – Erase Hard Drive! CAUTION! This software completely erases your hard drive. To be used ONLY if you want to get rid of your computer and make sure the hard drive is empty.
  • Security – Eraser – Permanently erase files on your Hard Drive CAUTION! This is a free file shredder software program. It is used to get rid of file(s) you no longer want or need. Use with caution.
  • Security – Malware Software This software finds and rids you computer of Malware.
  • Security – Online Virus Checker called VirusTotal This free service will analyze suspicious files and URLs.
  • Surfshark The number one rated VPN service.

Categories

Archives

Follow Steve Simpson, Glendale College Computer Instructor on WordPress.com
March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Feb    

Hours & Info

simpsongcc@live.com
@slsimpson
818-813-1720
M,W 7:00- 11:00pm
T,TH 10:00-11:30pm
SAT, SUN 12:00-11:00pm

A WordPress.com Website.

  • Follow Following
    • Steve Simpson, Glendale College Computer Instructor
    • Join 80 other followers
    • Already have a WordPress.com account? Log in now.
    • Steve Simpson, Glendale College Computer Instructor
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...