General Knowledge
Chapter 1: General Knowledge
Understanding the Excel Environment is extremely important. In this chapter, you will learn lots of magic tricks and techniques , that will enhance your work performance.
Read all posts from Chapter 1: General Knowledge
+ 1.1 How to work with Excel Cell Modes
The normal state of worksheet cells is the Ready Mode.
When you edit an Excel worksheet cell, a defined name formula, a conditional formatting formula, or a chart series, the Excel application can operate in 3 Input Modes:
- Enter Mode
- Edit Mode
- Point Mode
The Cell Mode is displayed in the bottom left corner of the Excel Application Window, also known as the Status Bar:
How can the Cell Modes affect your work?
+ 1.2 How to work with Excel Ranges
Tips and Techniques for Working with Excel Ranges
Learn how to operate with Contiguous Ranges, Non-Contiguous Ranges, Cells, in this collection of posts.
You will also learn how to easily navigate in worksheets, rows, columns with useful keyboard shortcuts and from Excel Menu functionalities.
+ 1.3 How to work with Excel Defined Names
Tips and Techniques for Working with Excel Defined Names
Creating Defined Names in your workbooks will give you the flexibility you want, you can define a name for a cell range, for functions, constants, or for Excel Defined Tables.
You will also learn how to use your Defined Names in your Excel applications, to make them flexible and dynamic.
Coming soon… Please subscribe to this blog, you will receive notifications when new content is added!
+ 1.4 How to work with Excel Cell References
Tips and Techniques for Working with Absolute and Relative Cell References in Formulas , Names and Conditional Formattings
Learn how to use References to make your formulas flexible when copied over multiple rows and columns.
You will also learn how to easily switch between reference types using keyboard shortcuts.
Coming soon… Please subscribe to this blog, you will receive notifications when new content is added!
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!