Excel First

Excel Solutions

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:

 

Enter ModeEdit ModePoint Mode

 

How can the Cell Modes affect your work?

Read All Posts –>

+ 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.

Read All Posts –>

 

+ 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!

Start Your Free Excel Learning Journey!

Enter your email address to subscribe to this blog:

 

Leave a Reply

Your email address will not be published. Required fields are marked *