Ms Excel: The Methods That Make A Huge Impact

Shortlisted methods for busy professionals, learn all you need to save time, expand capability on complexity

What you'll learn

Learn methodologies that can switch excel from a data canvas to a data management tool

Learn methodologies that can help you stand alone in any business culture, especially in data poor environments

save time on calculations (productivity methods, e.g. pivot tables, named ranges, macros)

solve problems with many dimensions (e.g tables relationships)

collaborate with others (e.g. protecting sheet)

troubleshooting (job saver), watch out topics

Requirements

Excel with English Functions

Excel version higher than 2013

familiar with Excel processes

Description

Dear friend and partner , We give the best we have to pursue a career path and we soon realize that a job is not only about the job title and the salary. We need to solve problems, effectively, quickly and take calls in an informed and business compatible way.I remember,M***** wanted badly to become DEPT manager, but she could not calculate effectively the required Work Force based on the active contracts and budget figures. It was a mess, every time she needed to record labor hours, calculate project cost,  organize project tasks and create historical data. Each time she did quotations to potential customers, she was like rolling the dice and project profitability was out of her control. It was hard for her to support a new investment or a business review , other than expressing thoughts and feelings, because … she did not have the data to show. The flight from a technical leader to a management leader was a little bit bumpy and clumsy. I remember,G*****, he wanted to be 2nd lieutenant, next to the chief officer the man of the power and the glory. He tried to coordinate teams , gather data and manage corporate reporting. He tried hard, however his excel solutions had 150 columns and each time we reviewed , you could find many mistakes coming from the fact that there was not a validation strategy and a keep it simple approach. He often found himself trapped into the procedures and he often lost a clear vision of what is the purpose. Authoritarian approach lucking the vision and the clear goal. Too much stress for today and too less action for tomorrow.How can i forget,A****** the new CEO, promised the Stars to the Board of Directors and he needed so badly to present quick wins. However, he had a major drawback. He relied too much on given data, He had no way to process information. In the first rounds, he took some bad decisions with people , just because the presented figures where biased and misleading. Too bad for Andreas, he was trapped into creating a team of flatterers rather than a team of doers. Maybe there is something common in these examples. No hands on mentality. No passion for informed decision making, no passion for historical observation and continuity. A hurry to manage others before we learn how to effectively manage ourselves. In this course i wish to transfer to you my 20years experience in solving Business Exercises in a way that you can develop methodologies which can help you to be effective in your daily routine. Excel is a very powerful tool as soon as you realize the performance potential and use it in the right way.I want to help you meet the following goals,1.Establish a methodology on MS Excel that can help you to:•Save time as a single user•Solve complicated problems as a single user•Collaborate effectively with teams by adopting certain techniques2.Shift our perspective from using Excel as Drawing Canvas to Data Management Tool that can perform•Calculations for us•Consolidation for us•Automate repeating actions and introduce some intelligence3. Help you to be able to stand alone and survive any business culture, from data reach down to data poor. Most of my skills where acquired in data poor environments and most of my tools where developed in companies with poor toolbox, this is the reality.4.Acquire a foundation that can help you move to the next level, which is to coordinate big scale teams and Big scale projects. You will need to master Excel methods so as you can then expand to Power BI or similar and automate your processes and analyze deeper and wider your business and your processes.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Part 1

Lecture 2 drag function and $

Lecture 3 named ranges

Lecture 4 vlookup and troubleshooting

Lecture 5 statistical functions (sum, average, min, max, …)

Section 3: Part 2

Lecture 6 PIvot Tables

Lecture 7 Tables

Lecture 8 data validation

Lecture 9 date functions

Section 4: Part 3

Lecture 10 macros

Lecture 11 conditional formatting

Lecture 12 protect sheet

Lecture 13 freeze panes

Lecture 14 text functions

Section 5: Case Study 1

Lecture 15 case study 1: Assignment

Lecture 16 case study 1: functions over tables

Lecture 17 case study 1: table relationships over pivot table

Section 6: Final Test

Professionals that use excel in the routine, Managers, Analysts , Engineers, Accountants,professionals already familiar w Excel material, searching for a way to boost performance