# Creating My First Profile

This guide will show you how to create a custom Flexbar profile to boost your productivity - using Microsoft Office Excel as an example.

![1744983288735](image/create_my_first_profile/1744983288735.png)

## Creating an Excel Page

Find the Page key in the Navigation category of the Key Library and drag it onto your Flexbar.

![1744982158836](image/create_my_first_profile/1744982158836.png)

For better visual appeal and usability, we recommend customizing this Page. For example, you can set the background color to dark green and use the Excel application icon.

![1744982357101](image/create_my_first_profile/1744982357101.png)

In the Function tab, you can bind this page to Excel. This way, when you focus on an Excel window, Flexbar will automatically switch to your Excel page.

![1744982406689](image/create_my_first_profile/1744982406689.png)

## Adding the Keys You Need

Now you can add the keys you need to your Excel page.

### Adding Shortcuts

When editing Excel data, you often need to change cell formats. For example, switching to number format requires pressing Ctrl+Shift+1, while switching to percentage format requires Ctrl+Shift+5.

You can find and add the Keyboard key from the Key Library.

![1744982919747](image/create_my_first_profile/1744982919747.png)

For the number format shortcut, set the appearance to a number icon and configure the shortcut as Ctrl+Shift+1.

![1744982955406](image/create_my_first_profile/1744982955406.png)

For the percentage format shortcut, set the appearance to a percentage icon and configure the shortcut as Ctrl+Shift+5.

![1744982986771](image/create_my_first_profile/1744982986771.png)

We've successfully added two shortcuts to Flexbar. Operations that previously required pressing three keys can now be done with a single tap on Flexbar - what you see is what you get, and you don't need to memorize complex keyboard shortcuts.

### Adding Text Input

Excel requires memorizing many formulas. You can add a text input key to Flexbar to enter complex formulas for you. You can find this in the Input category.

![1744983098548](image/create_my_first_profile/1744983098548.png)

For example, for the commonly used average formula, simply configure the key to input the formula when pressed.

![1744983173361](image/create_my_first_profile/1744983173361.png)

Now you can enter this formula in Excel with just one tap on your Flexbar.

### Getting Pre-made Excel Keys

We provide pre-configured shortcut sets for many applications - including Excel. You can install our Excel key preset from FlexGate, which includes hundreds of Excel shortcuts and common formulas.

![1744982098558](image/create_my_first_profile/1744982098558.png)