No matter what you do in your life, at one point you will need it, you cannot escape it, and you’d better be prepared when that moment will come.
Of course now you can choose the hard way: Try to figure it yourself by going to search what you need through thousands of internet pages, Youtube videos or hundreds of old fashioned books, but REMEMBER: neither is all in one, and both contain long hours of search and long tutorials or pages to read or view.
OR, You can choose the easy way: This book is giving you the structured and accurate information that you need, including where to find it, how to use it and how long you need to learn it. This will be the game-changer for your life.
Simply Master Microsoft® Excel, Beginner to Basic
As the title says this book is designed for Beginners and Basic users of Microsoft® Excel application.
For work or for personal use nowadays it is mandatory to know how to use and perform activities in Excel. Also, it is well known that Excel represents a bridge between our ERP, CRM, Banking systems, Internet platforms or personal needs (such as Crypto Portfolio, Expenses, Planning, trackers). All previous mentioned use import or/and export functions that convert the information from these systems into Excel spreadsheets. This can and should be used to better evaluate, represent and read the data.
This book is addressed to the newies that want and have the desire to learn Excel.
In this book we have used a new concept: Learn by Design. What does this mean? We have designed the content in such a way that all the information that you actually use or need is compressed and described step by step. This book represents a guide for what you need, where to find it and how to use it. Remember! You do not need hundreds of pages to learn something, you need good and compressed information, and this is exactly what we offer!
What you will learn
A Basic user of Excel is someone who can perform the following activities in Excel:
- Perform tasks and work with data in worksheets
- Enter and correct data
- Format data
- Enter simple formula
- Modify a workbook
- Format a worksheet
- Use printing functions
The book is structured in 3 modules and each module has lessons with indicated timing needed for learning:
Module 1 – Excel Basics – Total learn time: 1 h and 10 min
- Lesson 1 – Introduction in Microsoft® Excel: Excel Tabs, Structure, Worksheets, Cells, etc.
- Lesson 2 – Entry, editing and formatting data in active (range)cell: Information Type and Format, Conditional and Advanced Formatting
- Lesson 3 – Working with Cells and Ranges in Excel: Formating, Shortcuts, Information management, etc.
- Lesson 4 – Managing the Worksheets: Customization, Working with Worksheets, etc.
Module 2 – Excel Main Features / Options – Total learn time: 1 h and 10 min
- Lesson 1– Tables: Everything you need to know about tables
- Lesson 2 – Sort and Filter: Working Filters, Slicers, etc.
Module 3 – Introduction to Excel Formulas f(x) – Total learn time: 60 min
- Lesson 1 – Introduction to formula: Formula structure,insert and edit formula, help, errors handling, Audit & Check Formulas, List of most used formulas and their structure, etc.
And, because you will learn all this with us and you supported us with this project, we have created some Excel tools to reward you for your Effort because we want you to have a great start up in this new Chapter of your life. Take a look on our packages and select the best fit for you.
ABOUT the REWARD TOOLS
When I started this KICKSTARTER, and while writing these lines I figured out I want to give even more so I will share with you some Excel tools that will not only help you practice what you learned but also help you in your personal/hobby life.
These tools are Excel sheets that are fully automated. You only need to feed your information in, and all the rest will be done by the buttons inside the tools. Some of the tools will require you to fill your own API in (for example the one for the Crypto Portfolio) or to do some small changes.
These tools are definitely made for someone who already read the book and learned its content. Any additional steps that might not be covered in the book will be definitely included in each Tool Instruction.
This is the selection of the tools I’ve included:
- EXPENSES Tool (also known as Cash Flow tool)
This tool is created to help you monitor your Monthly and Yearly expenses. With a clear overview of your income and expenses you can become financially responsible and manage your money better so that you can enjoy life better and reach your financial goals. (Works also on Google sheets)
- Cryptocurrency tracker (with API included)
With this tool you can track your crypto currencies and most importantly your profits and return on investment based on actual daily price. Additionally you can monitor how your portfolio changes from day to day, compared with the past 24 hours and all time investment. This will help you make better decisions when it comes up to buying and selling your crypto. REMEMBER it is very important to know your numbers! (Works only on EXCEL)
- Basic Management templates
With these templates, you have all you need to manage and become business oriented. Why are these templates so important? Because once you start using them, they will provide you a clear overview on what you do and what you should do to become time effective when it comes to your business activities, input and output information and processes. Also they will help you understand what the root cause of your issues is and to correct them. Time is money! A structured way of work will reduce your time of process and will increase your profit. (Works also on Google sheets)
- Business Plan Template
Congrats on starting your own business or for having your own business already. But, do you know exactly where you are heading this year, or in 5 years? Unfortunately, the statistics show that 20% of businesses fail in the first year and 45% in the first 5 years! The top reason for this is NOT HAVING a GOOD Business Plan. We have created a template that will help you make your Business plan and this will considerably increase your chance of success. (Works also on Google sheets)
- Long & Short time Goals Planner
We all have dreams and goals! Have you ever wondered why only 2% of the world wide population achieve its goals? This is because the first step is the most difficult, and the first step is to TAKE ACTION. With this Goal planner you take action, you set your long term goals on paper and you make a plan to achieve them. This is a MUST HAVE because this will transform your unpolished ideas into clear goals, and once put in writing they become physical therefore they exist and start manifesting. (Works also on Google sheets)
- Accountability Diary
So we have dreams and goals and we set our mind to take action…then we start and in the beginning we are so focused and full of determination. GREAT! But then something happens and in no time we see ourselves one month later and we realise that we didn’t do anything for one month…this is because we are not keeping ourselves accountable for what we must do to get to the result we want. This tool will help you understand the Victim behaviour and will guide you to become accountable for your actions. Once you become accountable your road towards your goals is only forward. (Works also on Google sheets)
- Daily & Weekly planner
I’m so busy 🙁 … I couldn’t even feel my day passing by 🙁 … I don’t have time 🙁 … Let’s be honest, we all have this! Why? Because we don’t manage our time properly. This tool will help you structure your time and not only. It also includes tips on exact actions to be taken so that you can effectively process different types of activities that occur during the day. You are effective, your free time increases, you can enjoy doing things you really like doing. (Works also on Google sheets)
The Reward chosen will be sent by Email after a few days (not more than 7 working days) from the project completion date and goal.