G Com Solutions
About the instructor
All G Com Solutions trainers (both online and in person) are highly experienced IT professionals and qualified to deliver a wide range of Microsoft training courses.
They have a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes and have all obtained the MCSA BI Reporting certification.
This course uses a practical approach to learning this powerful software tool: analysis of key features, combined with step-by-step tutorials which will reinforce your understanding of what Microsoft Excel is all about.
Aimed at beginner to intermediate Excel users, who may already be familiar with the basics, this course will provide the practical insights, tips and shortcuts you need to start becoming an Excel power user.
It provides step-by-step practice in building formulas with useful text functions like LEFT, RIGHT, MID, PROPER and CONCATENATE; conditional functions like IF, IFERROR, SUMIF AND COUNTIF; lookup functions like VLOOKUP, INDEX and MATCH; and date functions like NETWORKDAYS.
The course also covers creating and customizing charts and graphics: practical exercises on creating the different types of Excel charts, creating sparklines, importing and creating graphics and embedding formulas into graphic elements.
We then move on to look at working with tabular data: sorting data numerically, chronologically, by colour and by custom order, filtering data and creating multi-level subtotals. Creating and customizing pivot tables, pivot charts and dashboards, featuring slicers and timelines which provide interactive data filtering and exploration.
All of the worksheets used by the trainer are available to students, enabling them to follow along and practice all of the techniques being demonstrated.