Search

Brian L.

Bentonville, AR

$35/hour

Sherlock Spreadsheets

$35/Hour


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

Response time:

Contact Brian

University of Arkansas
Financial Management

Education

University of Arkansas (Financial Management)

About Brian

Hello, my name is Brian. But if you would like, you may call me Sherlock Spreadsheets.

I am not great at a great many things. But I really know Excel, and also like learning more about the vast tool-sets available in the application. Excel can provide insights, automate work, organize record-keeping systems, and greatly enhance your effectiveness at work. If you are not tired at the end of the day, you can even apply your knowledge of Excel to create your own personal finance application at home.

So. If you are new to working in an office environment, and are realizing you need to know more about spreadsheets. Or maybe your an intermediate-level data analyst looking to get to the next level. Please contact me-- and I will help you learn what you need to know.

Other areas in my domain are: Excel (and PowerBI technology), TSQL/ PLSQL (and other SQL Technology-- SSRS, PowerPivot), Microsoft Office (Outlook, PowerPoint, Word), Accounting (general practices-- AP/ AR/ Chart of Accounts, P&L)

Thanks for dropping in!
-Sherlock Spreadsheets
Hello, my name is Brian. But if you would like, you may call me Sherlock Spreadsheets.

I am not great at a great many things. But I really know Excel, and also like learning more about the vast tool-sets available in the application. Excel can provide insights, automate work, organize record-keeping systems, and greatly enhance your
Read more

Policies
Cancellation
4 hours notice required
Travel Radius
Travels within 15 miles of Bentonville, AR 72712
Business:
Microsoft Excel

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.

Microsoft Excel

I have 3+ year experience utilizing advanced Excel features: formulas (nested formulas, array formulas), formatting, charts & graphs, Visual Basic, pivot tables, PowerPivot, PowerQuery. I do not know everything about Excel all at one time-- but I have an lots of skills, experiences, best practices, & tips to share.

SQL

I have advanced query authoring skills with the following methods: SELECT, CTE, PARAMETERS, SUB-QUERY, CLAUSES, JOINS, and PIVOT. I have experience integrating databases using linked servers, and SSIS packages. I have also had success developing OLTP processes using data manipulation methods (TRUNCATE, DELETE, UPDATE, MERGE) and database objects (STORED PROC, UDF, VIEWS).

Visual Basic

I have two years experience developing VBA code, usually in the Excel application. I have successfully developed solutions using the software for: process automation, formatting, chart customization, and user-interface design. The code I have developed usually includes named variables, different copy paste methods, reading object values, cell formula writing, and event handler procedures. I enjoy sharing and learning with pupils and peers.

University of Arkansas
Financial Management

Education

University of Arkansas (Financial Management)

Hourly rate

Standard Hourly Rate: $35.00

Cancellation: 4 hours notice required

Travel policy

Brian will travel within 15 miles of Bentonville, AR 72712.