My Excel “journey” started way back in 1995. Since then, I’ve been using Excel almost daily, (excepting legal holidays, of course 🙂 ); over this time, I have gained a broad knowledge base and advanced my expertise in Excel by developing more and more complex Excel applications for my clients as well as for my own use.
The Excel Learning Journey that I propose for you, is structured in such a way as to offer you the most practical way to learn Excel, free.
You can master Excel, that is a fact, if you dedicate enough time and effort to learning and mastering the basic fundamental concepts. Everyone wants to be the Excel Superstar in their office, right? 🙂
Spreadsheets have become a fundamental and integral part of the workplace, not only scientific, but in the business world as well. Those who are capable of mastering the different aspects of Excel can insure they have a bright and prosperous future.
First time, all I knew about Excel is how to open it… but i was so sure I can do more than that 🙂
At first, it was curiosity… Then, curiosity turned into ambition… Now, it became an extraordinary way to help other people and to pay the bills…
All my experience has been gained through self learning, using online resources and countless hours of research and hard work.
I appreciate and am indebted to all the free help I received along my Excel journey, and I am now most willing to share my knowledge with you.
There are many things that you have to take into consideration when building an Excel application.
To begin with, you need a good and fundamental understanding of the Excel environment and the built – in functionalities that Excel has. This knowledge base will help you build flexible, solid Excel applications, which will save you a lot of time.
There is a dark side of building Excel applications: If the application is not carefully thought-out and designed, a poorly designed application may make you lose money, and this is not a desirable outcome.
An important step in Your Free Excel Learning Journey is that you should subscribe for new posts, this way you will be notified when a new tutorial is published. Use the Subscription form below to “sign up.” Remember it’s FREE!
Start Your Free Excel Learning Journey!
Chapter 1: General Knowledge
In chapter 1, you will find the most useful things you need to know about the Excel environment and techniques, including:
|#||Chapter 1: General Knowledge||Introduction|
|1.1||How to work with Excel Input Modes||Read All Posts|
|1.2||How to work with Excel Ranges||Read All Posts|
|1.3||How to work with Excel Defined Names||Read All Posts|
|1.4||How to work with Excel Cell References||(Link – Coming soon…)|
Chapter 2: Excel Functions
In chapter 2, you will find the most useful things you need to know about Excel Functions, including:
|#||Chapter 2: Excel Functions||Introduction To Functions|
|2.1||Working with Formulas||Read All Posts|
|2.2||Date And Time Functions||(Link – Coming soon…)|
|2.3||Information Functions||(Link – Coming soon…)|
|2.4||Logical Functions||(Link – Coming soon…)|
|2.5||Lookup and Reference Functions||(Link – Coming soon…)|
|2.6||Math and Trigonometry Functions||(Link – Coming soon…)|
|2.7||Text Functions||Read All Posts|
Chapter 3: Excel Defined Tables
In chapter 3, you will find the most useful things you need to know about Excel Defined Tables, including:
|#||Chapter 3: Excel Defined Tables||Introduction To Defined Tables|
|3.1||Excel Table Components||Read All Posts|
|3.2||Selecting Table Components||Read All Posts|
|3.3||Formula References in Tables||(Link – Coming soon…)|
Chapter 4: Excel Pivot Tables
In chapter 4, you will find the most useful things you need to know about Excel Pivot Tables, including:
|#||Chapter 4: Excel Pivot Tables||Links|
|4.1||Excel Pivot Tables Overview||(Link – Coming soon…)|
|4.2||Pivot Table Fields||(Link – Coming soon…)|
|4.3||Report Layout||(Link – Coming soon…)|
Your feedback is always wellcomed, please take a minute to leave a comment.