Excel logoOne of my favorite Microsoft programs is Excel. It is probably used in most businesses as the Excel program or as Google Sheets. There are many advantages to Google Sheets as it can be saved in the Google Drive, it can be shared with anyone you choose and can be edited by more than one user. There are still some advantages to the oringal version as it is generally more robust. Sheets offers Add-ons to ccomodate this though I haven't tried them.

Do you find yourself or your employees doing the same actions over and over again in your spreadsheets? I can create macros (a set of instructions) so that Excel can do that repetitive work for you. I have helped many companies over the years do just this. If you want to see your business run more efficiently, please contact me.


Class description: Excel, an electronic spreadsheet program is integral in today's workplace and for personal use. Explore the Excel environment and create, save, send and retrieve a worksheet. Learn how to perform calculations using formulas and functions, modify and format a worksheet, prepare for print, and create impressive graphs and charts.

Target students: Today virtually every business relies on Excel to organize data, calculate values, keep inventory tables, and use charts. In the beginning class you will learn enough to be comfortable creating and evaluating spreadsheets. In the intermediate class we further explore with complex formulas, create pivot tables and increase proficiency and efficiency.


Excel notes and downloads

Thumbnail Image 1

Beginner Class

1

2

sort, filter, freeze

3

stocks

Thumbnail Image 1

Intermediate Class

1
Create complex formulas, comment, relative and absolute references, charts, templates, mixed references, format painter, formulas to change case of text

2
Transpose data, remove duplicates, use various functions, advanced sorting, filters, and outlines.

3
Condtional formatting, logical functions.

 

Lesson 4
Trace prescedents/dependents, more on average formulas, vlookup, rounding #'s, Password protect cells

Lesson 5

Review & share workbooks, PIvot Tables, Go to Command, PMT function, Goal Seek, Sparklines, Text to column, concatenate