Vitalij

I am a young professional with a degree in Economics, who for over three years has been a part of an exciting aviation business. My focus within the company is on leading finance-specific IT projects as well as process optimisation.

Availability: Weekdays from 7pm and all day on weekends.

Willing to travel: 10 miles

Experience: I will quickly bring your Microsoft Excel knowledge up to Advanced level, which will make you indispensable in your current organisation. If you are a job seeker looking to improve your skills or a recent graduate, together we will put you miles ahead of competition and make you an attractive hire to prospective employers.

I will take my time to understand your requirements and it is totally up to you whether you want to focus on specific topics or whether you want to improve your Excel proficiency to a certain level overall.

Furthermore, you will also receive a cheat sheet with the most useful Excel shortcuts as well as a worksheet, where you will be able to practice every single topic that we have covered.
The topics I can cover include, but are not limited to below.

INTERMEDIATE LEVEL
- Naming ranges
- Freezing and unfreezing panes
- Hiding and displaying rows and columns of data
- Conditional formatting
- Simple formulas and introduction to IF statements
- Introduction to VLOOKUP
- Relative and absolute cell referencing
- Sorting and filtering data, custom sorting
- Creating and formatting tables
- Creating and formatting charts
-

ADVANCED LEVEL
- Using nested IF statements
- Creating compound logical tests using AND, OR, NOT functions with IF statements
- Using VLOOKUP, HLOOKUP and INDEX MATCH to retrieve data as well as combining them with IF statements
- Using COUNTIFS, SUMIFS, AVERAGEIFS for tabulating data based on single or multiple criteria
- Calculating date and time using TODAY, WORKDAY, DATEDIF
- Formatting text and cleaning up data using UPPER, PROPER, FIND, MID, SEARCH, LEFT, RIGHT, LEN, TRIM, CLEAN
- Sourcing table structure information using CHOOSE
- Rounding figures using ROUND, ROUNDUP, ROUNDDOWN, FLOOR, CEILING, MROUND
- Tracing formula dependents, precendents and errors
- Correcting errors in formulas and using IFERROR statements to suppress error messages
- Using pivot tables and creating pivot charts
- Creating dashboards that present data and allow to manipulate visuals easily using slicers
- Creating drop-down lists using data validation and dynamic tables and making each selection dependent on the previous selection using INDIRECT
- Simple macros