Over 5 tutoring hours

Heidi L.

Racine, WI


Heidi - Excel Phemon

4.7 average from 3 ratings
Very knowledgeable in Excel!
— Shawn, Franksville, WI on 7/20/15


Send a message explaining your needs and Heidi will reply soon.

Response time:

Contact Heidi

Gateway Technical College


Gateway Technical College (MIcrocomputers)

About Heidi

I am Microsoft Excel Certified and my real passion is working with databases, lookup formulas, and pivot tables. I continue to advance my skills whenever possible so that I can keep my high standards of being an exceptional power user. I am a highly motivated, "out-of-the-box" thinker who always enjoys a challenge. I have a strong work ethic and am known as a successful multi-tasker balancing my work load and meeting deadlines.

I enjoy the breakdown of working with various databases, as well as using my advanced Excel skill set using Megaformulas, importing and exporting data, charts, graphs, data validation, conditional formatting, lookup formulas, macros and VB modules, along with having security formulas in place to verify that the output data is 100% accurate, before presenting my results.

I have worked in the Data Analysis field for over 20+ years, I can slice and dice data to all levels and concluded with outcomes no one can believe were ever possible. My analytical mind allows me to go into deep breakdown of data manipulation and validation. I look forward to sharing my knowledge and skill set with you.

[Advanced Skill Set: Pivot Tables, Connect single & multiple Pivot Tables using Slicers, LOOKUP, HLOOKUP, & VLOOKUP Formulas, Megaformulas, Data Validation, Accuracy & Compliance Formulas, Subtotals Function, Text-to-Columns Function, Import/Export, Extract & Import data, Macros, VB Modules, Filters & Advanced Filters, Formulas linking multiple worksheets & workbooks, Custom Forms, Conditional Formatting, Working with Objects, Camera Tool for functional snapshots of data placement.]
I am Microsoft Excel Certified and my real passion is working with databases, lookup formulas, and pivot tables. I continue to advance my skills whenever possible so that I can keep my high standards of being an exceptional power user. I am a highly motivated, Read more

1 hour notice required
Travel Radius
Travels within 30 miles of Racine, WI 53403

"Very knowledgeable in Excel!"

- Shawn, Franksville, WI on 7/20/15
Microsoft Excel,
Microsoft PowerPoint, Microsoft Word

Approved subjects are in bold.

Approved subjects

In most cases, tutors gain approval in a subject by passing a proficiency exam. For some subject areas, like music and art, tutors submit written requests to demonstrate their proficiency to potential students. If a tutor is interested but not yet approved in a subject, the subject will appear in non-bold font. Tutors need to be approved in a subject prior to beginning lessons.

Computer Science

Computer Sciences consists of the all around system of a computer and what is needed to make it function. It is based upon scientific and mathematical concepts using 1's and 0's to transfer, communicate and process data. Programming code language is used for hardware and software functionality. All these pieces are put in place for users to access the world wide web (Internet). Send electronic mail (Email) and software programs for Instant Messaging from one computer to another to communicate with someone else on their computer. The software aspect of computer sciences is just one area effected. More goes on behind the scenes when you are using your computer. Memory stores information from software and hardware. Now a days there are tons of type of computers out there. From a desktop tower model to a mobile laptop. But, they all use the basic scientific and mathematical concepts. There are also many different types of operation systems for a computer, but they all pretty much run on the same concept.

Microsoft Access

MS Access is a database program. You can create databases to run queries, filters, reports, etc. When creating a database there are many views you can use to review the data entered from the file. There must be a Primary Key listed in the database as to what is especially designated. There is a very helpful Wizard to help walk you through how to create a new database. Once the database has been created and a Primary Key assign, review and analysis can begin. Macros can also be created to run and provide specific information.

Microsoft Excel

I am Microsoft Excel Certified since 2005, and my real passion is working with databases and pivot tables. I continue to advance my skills whenever possible so that I can adhere to my high standards of being an exceptional power user.

I enjoy the challenges of working with diverse users, as well as linking multiple workbooks together using mega formulas and importing and exporting data (along with having security formulas in place to verify that the output data is 100% accurate before presenting my results). I take pride in my work and work ethics.

I have also worked in the Information Technology Help Desk field for 15+ years, providing technical support throughout my overall career.

I created a budget for a multi-billion dollar Pharmaceutical company when recommended by a friend. They were currently using calculators to do their budgets. She recommended me to create a spreadsheet for them to enter their data to make sure it was correct. It is a 48-sheet workbook with a summary page. It contains formulas and also double checking formulas to validate the information is correct. It is still used to this day.

I've enjoyed using Excel since I was in 6th grade. I started by using it to balance my checkbooks and little things like that. Then I enjoyed the challenges of creating Pivot Tables and Macros to make things easier. It was when I started dreaming of cells moving that I knew I had to advance my skills in Excel and go get certified!

Microsoft Outlook

I am highly advanced in working with MS Outlook in a regular PC environment and within a corporate domain. I can teach everything from starting with creating meetings, booking resources, making sure all resources and members are available by viewing their calenders, importing and exporting contacts, creating signatures, show you how to use and set up .pst files that will not take up space in your mailbox and data will be saved to a directory where it will be kept safe if something happens to Outlooks. Run Detect and Repairs, Explain different types of Views in Outlook of how to read your emails. Set up Rules and Alerts, Import Rules and Alerts, Ways to use Notes feature. Sending and Receiving emails. Using carbon copy and blind carbon copy to email people. Print contacts in different styles and formats and other advanced features and plug-ins.

Microsoft Project

I have worked with MS Project along with the web based application of Project Web Access. The MS Project program and Project Web Access application are a syncing tool for users assigned to tasks in a project plan who are responsible to update their task percentage complete via the Project Web Access website. Once they update their percentage complete and submit it via the web, it gets sent to me. I then enter the percentage complete for that user into the actual MS Project plan for review by Management on the progress of individual project plans. I know how to create custom views in both MS Project and Project Web Access making it easier for Management to review exactly what they want to see in each Project Plan.

Microsoft Windows

I have worked on many versions of Windows over the years. Starting with WinNT up to Windows 7, and all in between. Windows is basically the whole operating system that controls the entire computer. It is the first thing you see when you turn on your computer. It includes features such as adding and removing programs, installing software, connecting to internet access, adding printers, mapping drives via a network, and can be configured or customized with different user rights. It has many features that control the computer. It is a custom program and requires a disk to install and a installation key for each operating system installed. Windows contains many features to functionality to work with hardware and software.

Gateway Technical College


Gateway Technical College (MIcrocomputers)

Very knowledgeable in Excel! — Heidi was very diligent in completing the tasks that needed to be done. She has a great understanding of Excel, was prompt with all correspondence, and accommodated my quick deadline. Would definitely recommend! ...

— Shawn, Franksville, WI on 7/20/15

Hourly rate

Standard Hourly Rate: $40.00

Cancellation: 1 hour notice required

Travel policy

Heidi will travel within 30 miles of Racine, WI 53403.