2018 Excel Workshopl 1

Excel 1

Excel 2

2018 Excel Workshopl 2

Create tables for efficiency

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.


Thumbnail Image 1

Beginner Class

 

2

sort, filter, freeze

3

stocks

Lesson 7

2017 Basics

Weather

Thumbnail Image 1

Intermediate Class

Part 1

1 working with multiple sheets

2 Find and Replace

3 Spell Check, Track Changes

4 Page Layout, printing

5 Formulas

6 Cell Reference

7 Functions

8 Freeze pane, new window

9 Sort

10 Filter

11 Subtotals

12 Tables

13 Charts

14 Condional Formatting

15 Inspect - protect

16 Pivot Tables

17 More pivot tables

18 What if

19 Trim and duplicates

20 Invoice with Vlookup

21 Invoice - fix Vlookup

22 Invoice Data Validation