Sort and Fill Data with Custom Lists

In this article, we will be talking about how to create a custom list in Excel and what we can do with it. We can get faster in entering and analyzing data by creating data tables quickly with custom lists. If you already have a data list, i.e. certain product names, brands, stock names, region names etc.; if you add them to custom lists once, it is possible to list all the data in the list quickly instead of writing them over and over again. You just need to write any data from that list into a cell and drag it down. In addition, you can find articles concerning other features of Excel on our blog.

HOW ARE THE CUSTOM LISTS STORED?

Once you create a custom list, it is added to your computer registry, so that it is available for use in other workbooks. If you use a custom list when sorting data, it is also saved with the workbook, so that it can be used on other computers, including servers where your workbook might be published to Excel Services and you want to rely on the custom list for a sort.

However, if you open the workbook on another computer or server, you do not see the custom list that is stored in the workbook file in the Custom Lists popup window that is available from Excel Options, only from the Order column of the Sort dialog box. The custom list that is stored in the workbook file is also not immediately available for the Fill command.

If you prefer, add the custom list that is stored in the workbook file to the registry of the other computer or server and make it available from the Custom Lists popup window in Excel Options. From the Sort popup window, in the Order column, select Custom Lists to display the Custom Lists popup window, then select the custom list, and then click Add.

 

HOW ARE CUSTOM LISTS CREATED?

You need to access the existing custom lists box to create a custom list. There are two ways to access that box.

  1. File > Options > Advanced >  Edit Custom Lists

özel listeleri düzenle

 

2. Data > Sort > Order > Custom Lists

özel listelere ulaşmak

 

BUILT-IN LISTS

Excel provides day-of-the-week and month-of-the year built-in lists. The names will change depending on the language you use.

Built-in lists

Sun, Mon, Tue, Wed, Thu, Fri, Sat
Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

January, February, March, April, May, June, July, August, September, October, November, December

Note: You cannot edit or delete a built-in list.

 

For this reason, when we type January into a list and drag it down, a list that goes like February, March, April is created. If these lists didn’t exist, when we dragged the list it would have gone like January, January, January.

yerleşik özel listeler

 

HOW DO YOU CREATE A CUSTOM LIST MANUALLY?

  1. Access the Custom Lists Box with one of they ways we’ve mentioned above.
  2. Enter the data you want into the List entries field.
  3. Click Add.
  4. You will see that it is added in the Custom Lists field.
  5. Finally, click the OK button.

özel liste penceresi

 

Now you will see that when you write and drag any data that you’ve entered to the List entries field, every single one of them will be listed.

manuel özel liste

 

Let’s quickly create a data table that contains of the data we created and also months.

 

özel listeler hızlı doldur

 

IMPORT YOUR DATA TO YOUR CUSTOM LISTS

If you have steady and unique data in a range of cells, you can import that date to the customs listens box as a whole and use them in your lists. For that you need to go to the Custom Lists box from File > Options > Advanced > Edit Custom Lists. Afterwards, we will select the cell range and import the content.

 

 

toplu listeyi custom listden içeri aktarmak

 

And the thing about accessing these lists from the Sort window is that you can use them with the Sort feature.

For example; there are multiple lists in a table and you want to sort the list but you want 2019 and 2020 be the primary ones. You can add the 2019 and 2020 data into the Lists box and sort the way below.

 

custom list sıralama yapmak

 

You can get detailed information on Office Support.

See you in other articles, bye. 🙋🏻‍♂️
You can share this post with your friends and make sure that they are informed too.👍🏻

Create Custom Rules in Conditional Formatting

I will be talking a bit about how you can create custom rules for conditional formatting. Of course, to be able to create these rules, you need to be able to write formulas, at least a bit. I will tell you about how to create simple formulas and use them in conditional formatting. As you get better at writing formulas, I am sure that you will create better rules. You can take a look at our blog to find other articles about the other features.

 

WHAT IS CONDITIONAL FORMATTING?

 koşullu biçimlendirme

One of the most frequently used features in Excel is Conditional Formatting. This feature is usually used to color and highlight backgrounds of certain cells that comply with a specific rule. It is found within Styles in the Home menu. There are some available rules you can use. When the available rules are not enough for you, you can create your own rules and format the cell in compliance with those rules. Of course, for this you need to know how to write formulas like I have mentioned above.

We can see the available prepared rules when we choose Conditional Formatting like you can see below. We can easily format by color, text, and date. If the available rules are not enough for you, then you can choose “Use a formula to determine which cells to format” from the New Rule option and highlight the cells that comply with your rules by writing to the formula into the related field. If we want, we can create more than one Conditional Formatting in a field. We can use the Manage Rules option to see and change the conditions of these formats.

You can use the Clear Rules option to clear rules in a part of the page or in the whole page.

Let’s dig a bit deeper with practical examples.

APPLY CUSTOM RULES IN CONDITIONAL FORMATTING

HIGHLIGHT TEXTS

In our first example, we will make a simple application about creating custom rules in conditional formatting. Let’s detect and highlight backgrounds of texts in the field we determine. For this, we need a function that would detect if a value in a cell is text or not. This function is called: ISTEXT. We will be able to automatically highlight the data if they are text in the specified field.

You can see how to do it in this GIF and do the same thing for your work.

emetinse ile koşullu biçimlendirmede metin olanları renklendirmek

 

HIGHLIGHT WEEKENDS

Let’s detect the weekends of the dates in a columns and highlight their backgrounds for our second example. We will need a function for this as well, and it is called WEEKDAY.  With this function, we can find out which day a date is in its week. I.e, it will give us a number between 1 and 7; and we will highlight the dates that happen to be weekends by writing a rule of if the number is bigger than 5.

First, I want to do a live application of this formula for you to do it live as well and comprehend it better. After writing the formula to the cell, we will copy that formula and paste it to the use formula section in conditional formatting.

 

koşullu biçimlendirmede hafta sonunu renkli göstermek

 

And as the last step, we will write this formula to the related field, click on format and complete the action.

 

koşullu biçimi uygulama

 

If you say that you need more information, you can check Office Support.

 

See you in other articles, bye. 🙋🏻‍♂️
You can share this post with your friends and enable them to get informed as well.👍🏻

Rename a Worksheet

In this article, we will be informing you about how to rename a worksheet. Two changes that help to edit and define worksheets and the data they contain is to rename the worksheet and to change the color of the sheet tab under the work area. You will see the instruction and actions concerning this. You can take a look at our blog to find our articles about the other features.

 

3 ways to rename a worksheet

  1. Double-click the sheet tab and type the new name.
  2. Right-click the sheet tab, click Rename, and type the new name.

  3. Use the keyboard shortcut Alt+H > O > R, and type the new name.

 

1- Double-click the Sheet Tab

excel sayfa adını yeniden adlandırma

This method works in all versions of Windows, Mac, 365 and online Excel.

  1. Double-click on the name of the sheet tab to emphasize the name in the tab.
  2. Type a new name for the worksheet.
  3. Press Enter to complete renaming the worksheet.
  4. The new name should be displayed on the sheet tab.

 

sağ tık menüsünden sayfa adını değiştirme2- Right-click the Sheet Tab

This method works in all versions of Windows, Mac, 365 and online Excel.

  1. Right-click the sheet tab of the worksheet you want to rename to open the context menu.
  2. Click Rename on the menu list to emphasize the current sheet name.
  3. Type a new name for the worksheet.
  4. Press Enter to complete renaming the worksheet.
  5. The new name should be displayed on the sheet tab.

 

3- Access the Ribbon Options with your mouse

çalışma sayfalarını adlandırma

This method works in all versions of Windows, Mac, 365 and online Excel.

  1. Click the sheet tab of the worksheet to be renamed to make it the active page.
  2. Click the Home tab of the ribbon.
  3. Click Format on the Cells to open the drop-down menu.
  4. Click Rename Sheet to emphasize the sheet tab on bottom of the screen.
  5. Type a new name for the worksheet.
  6. Press Enter to complete renaming the worksheet.

 

Things to pay attention to while naming a worksheet:

  • Page name cannot be blank.
  • It cannot consist of more than 31 characters.
  • It cannot contain any of these characters: / ? * : [ ] For example, 05/04/2020 cannot be a valid worksheet name but 05-04-2020 can be.
  • It cannot start or end with an apostrophe (‘), but it can be used between texts and numbers in the name.
  • It cannot be named “History“. This is a special dictionary used for special purposes within Excel.

 

You can click here to get more information.

See you in other posts, bye. 🙋🏻‍♂️
You can share this post with your friends and enable them to get informed as well. 👍🏻

A Para TV “Center of Finance” Program

Our CEO Ahmet Toprakçı starred as guest in the “Finansın Merkezi (Center of Finance)” Program of A Para TV presented by Hande Özdemir and talked about the impact of corona virus on work conditions, digitalization processes, companies adapting to digital transformation and working from home. You can click the here to watch the program.

Tag Channels and People in Teams with Power Automate

That mysterious topic everybody curiously searches in google and gets lost between tabs! We will look at how to automatically share posts with tagging channels and people in Microsoft Teams with Power Automate.

This is how our main question was born:

“HR departments shouldn’t spend half of their work day looking for who’s birthday it is and sending them e-mails, we use Teams as a communication platform within our company. Let’s create a system that can automatically create a birthday post. It can notify everyone and celebrate that person’s birthday.”

Power Automate is the name of Microsoft’s product that was known as Flow before. For this reason, when you are searching “power automate”, you can see the name of “Flow” in most of the websites you visit. Power automate is a workflow product that can work integrated with 200-250 products and you can transfer, write, read and create between these products. You can send your unfinished tasks to yourself every morning at 9 am and create flows integrated with a lot of products like creating tasks depending on the results of the poll you’ve sent.

Now, if we go back to our main problem, here is what we need to do:

  • We will create a data source that contains birthdays and e-mail addresses.
  • We will check the data to see if the birthday is today or not.
  • For those who have their birthdays today, we will choose a channel on Microsoft Teams, mention the person and channel; and thus, notify everyone.
  • We need the system to repeat this everyday.

Let’s move step by step. First, go to Power Automate’s website and create a new flow.

1-CHOOSING THE TRIGGER

A trigger is what you need the most to start a flow. The question should be: “When do I want this flow to start running?” We will use “Recurrence” in this flow. After we choose the trigger, we enter information concerning when it will start running. We chose 10 am every morning for this flow.

power automate ile teams de mention için yineleme triggeri gif

2- Connection to the data source that contains birthdays and personal information

We will use SQL as data source here. If you want, you can you Excel. I need to mention something very important before we start; when you want to change the data source, you have to create the flow from the beginning. Because we will control and make actions using this source. The action we choose is the “Get rows” action. This way, it will be able to check for all in the table.

sql bağlantısı

3- The “Is their birthday today?” control

For this control, we choose condition. In this condition there will be two pieces: the first one will check the birthday piece (is it the same day of the month?), the second one will check the month (is it the same month?). Now we will write an expression into the “Choose a value” section.

power automate kosul ekleme

I left an image below so that it is not hard for you to follow conditions. You can find the code version of one below as well. We use the formatDateTime function to get the day parts of date expressions on the first row. And we use the utcNow function to see if they match up with today or not. The ‘dd’ and ‘MM’ expressions next to them represent date and month respectively. When you add these expressions it will include it to the “Apply to each” step. The items(‘Apply_to_each’) step in the formulas comes from here. [‘Birthday’] is the name of the row in which the birthdays are stored in our data source.

PS: We have to use the ‘MM’ expression in capital like this or it doesn’t get detected, we didn’t type it incorrectly.

kosullar

formatDateTime(items('Apply_to_each')?['Birthday'],'dd')

4- TAGGING IN TEAMS

And now let’s come to the main topic! After we do the steps below, the important thing is to share the post of the birthday. In this step, first, we need to choose in which group and channel the post will be shared and get the id of the group&channel. After choosing the said group and channel, you can get their ID fields with Power Automate. There are two actions for that: Get Groups, Get Teams Channels. You can find the IDs on their outputs by running these requests.

power automate list channel

Write the ids you got into its place in this address:

https://graph.microsoft.com/beta/teams/TEAM_ID/channels/CHANNEL_ID/messages

We will send a request to graph.microsoft.com  in order to use this feature about Teams. Microsoft Graph is a developer platform that connects multiple devices and services to each other.

The action we will use to tag and mention in Teams with Power Automate: HTTP with Azure AD – Invoke an HTTP Request

 

power automate invoke http request

If you have never used this action before, you will not come across a screen like the one below; first you will come across a screen where you need to login. You need to copy graph.microsoft.com into two fields in the screen.

base eresource

After this step, you need to fill in all 4 fields in the screen.

  • First we choose the POST option for the method field since we will be publishing a message.
  • Next, we will write the link we’ve created above that starts with graph and continues with teams_id and channel_id for the Url of Request field.
  • We write Content-Type into the Enter Key field and application/json into the Enter Value field for the Header section.
  • We paste the code block below into the Body of Request field.
{
"body": {
"content": "General Happy Birthday @{items('Apply_to_each_2')?['DisplayName']}
",
"contentType": "html"
},
"mentions": [
{
"id": 0,
"mentionText": "General",
"mentioned": {
"conversation": {
"id":"19:[email protected]",
"displayName": "Business Applications Trials",
"[email protected]": "#Microsoft.Teams.GraphSvc.conversationIdentityType",
"conversationIdentityType": "channel"
}
}
},
{
"id": 1,
"mentionText": "@{items('Apply_to_each_2')?['DisplayName']}",
"mentioned": {
"application": null,
"device": null,
"conversation": null,
"user": {
"id": "@{items('Apply_to_each_2')?['Id']}",
"displayName": "@{items('Apply_to_each')?['DisplayName']}",
"userIdentityType": "aadUser"
}
}
}
]
}

 

It will look like this after all these steps:

 

http isteği dolu hali

BODY EXPLANATION

Let’s explain the body section a bit. We enter an HTML content we want to the content. You can add images etc. to that content. Inside in the HTML content, we tag the people we want to tag. We you IDs while doing that. We define the ids inside these tags into the mentioned field at the bottom of the code block. We will both tag the channel -which is tagging the group-, and the person. You can give the ID numbers, it doesn’t matter which number you give. The important thing is that it matches with the mentioned field below.

In the mentioned field, we will determine in which chat this post will appear, i.e. we will tag the channel first. And for us, this is the general channel of our Business Applications Trial group. We write our channels id into the id field in conversation. And enter the “Channel” info into ConversationIdentityType. Another thing is to tag the person. We need that person’s Office 365 id while writing their tag. We can get this id through Power Automate. The action we need to use at this point is Office 365 Users- Search User. We get the user’s id by using their e-mail address.

search user

 

We write this id into the related id field. Since we will tag the person, userIdentityType comes instead of ConversationIdentityType. We write “addUser” here aannndd save.

 

That’s it! We are done. The last thing I want to mention is that you can get more detailed information about Teams APIs on Graph from the links below. We also have some other great articles about Power Automate and Teams on our blog, you can check them as well. And also here is the output of this flow.

power automate ile teams de mention

https://docs.microsoft.com/en-us/graph/api/channel-post-messages?view=graph-rest-beta&tabs=http

https://docs.microsoft.com/en-us/graph/api/resources/chatmessage?view=graph-rest-beta

https://docs.microsoft.com/en-us/graph/api/resources/chatmessagemention?view=graph-rest-beta

https://docs.microsoft.com/en-us/graph/api/channel-post-messages?view=graph-rest-beta&tabs=http

See you guys, social isolation is important

 

How to Make a Histogram in Excel

In this article, we will be talking about how to make a histogram in Excel. It looks a lot like the other bar charts, but separates your numbers into ranges the way you determine. Compared to the other chart types, histograms facilitate determining categories and frequencies of occurrence alongside different data. Don’t forget that you can take a look at our blog to see our articles about other topics. Let’s start. 👍🏻

 

HISTOGRAM IN EXCEL

You can find the Histogram Chart within built-in charts in Office 2016 and later version. Also, you can create a histogram in Excel with the Histogram tool. You create it by entering the numbers that represent the frequency range you want to use and the data you want to analyze. Histograms are supported by Office 365, Excel 2019, 2016, 2013, 2010, 2007 and Excel for Mac, but the steps you take depend on the Excel version you use.

Reminder: You need the Analysis ToolPak extension to use the Histogram tool in the previous versions of Excel 2016. This extension is not supported in Excel Online. But, you can display a histogram created in a desktop version of Excel by using Excel Online.

 

How Do You Create a Histogram Chart in Excel?

Since it is one one the built-in charts in Excel 2016 and later versions, it is pretty easy to use.

  1. To start, enter the data you want to use in your histogram into a worksheet. For example, enter the names of your employees in your company with 1000 workers into a column, and their ages into another column.
  2. Select any cell on your data table.
  3. Go to the Insert menu.
  4. Choose Insert Statistic Chart in the charts group.
  5.  Choose Histogram chart type.
  6. Double-click on the horizontal axis.
  7. Arrange the bin width as 5.
  8. Add Data labels.
  9. Your chart is ready.

Creating a Histogram chart is as simple as that. If we want to apply the steps above, a Histogram chart like this will come up. (The colors have been edited.)

Excel'de histogram grafik nasıl oluşturulur?

 

Let me show you how the steps are done with a GIF:

excel'de histogram oluştur

 

Creating a Histogram in Excel 2013, 2010 or 2007

Like I mentioned above, you need to active the Analysis ToolPak extension to be able to create a histogram chart in versions prior to 2016.

  1. Click the File menu.
  2. Choose Options.
  3. Click on Extensions.
  4. Push the Go button.
  5. Choose the Analysis ToolPak extension.
  6. Click on the OK button.

 

After following these instructions, you will see the Analysis ToolPak extension within the Analysis group on the right of the Data menu. We will show you how to activate it on the GIF below.

Excel'de histogram eklentisi aktif etmek

 

To get a Histogram from the Analysis tool, let’s write the bin width into a field first. For example; let’s write the bins starting from D2 as 28, 33, 38, 43, 48 to find how many people there are between the ages of 23 and 48 with 5 year gaps in a company with 1000 employees. You can check the GIF below for the next step.

 

histogram veri çözümleme

 

HINT: We can obtain the same Histogram that comes with data analyzes with the FREQUENCY function. We have data, and certain tracking ranges. With the FREQUENCY function, we can easily find the frequency of repetition of all values within the specified range.

sıklık fonksiyonu ile histogram

 

You can find chart and application samples about everything I’ve mentioned in this Excel file.  👉🏻 excel icon

 

 

You can get more information on Microsoft Support.

 

See your in another article, good bye.🙋🏻‍♂️
You can share this post with your friends and help them get informed as well.👍🏻

The Impact of an Intranet Portal on the Corporate Culture

Intranet is the most important and effective notion between a company’s workers. When we look at it, this notion is pretty simple but when we go into more details it gives us a range that helps us to create a corporate image and increase productivity.

As important the communication notion is while creating the corporate culture, you can also make it dynamic with the portal structure that will accompany you in your digitization processes and keeping up with the changing and developing world.

Let’s get into more details…

What are the Essentials of the Portal that Creates Your Corporate Culture?

1 Announcements

HR Departments have the biggest part of responsibility in terms of enabling a strong and dynamic structure in intranet processes. They relieve their  workload by publishing the announcements on the portal. They manage the processes through a single center with sections like LPPD, Performance Management, OHS documents and open positions.

2 Files

The palest ink is stronger than the sharpest memory. Files, the apple of companies’ eyes… Finding them on a secure common workplace will be one of the best factors that will relieve the workers’ workloads.

3 Celebrations

The joy of the portal; celebration corner… It becomes a piece that celebrates new friends that have joined us, birthdays and brings our emotions together and that cheers us all up.

4 Finding Personal Reasons

Considering that employee loyalty is achieved through touching their social lives; the portal keeps people within itself with horoscope, news, market condition, movies, music and books.

5 Integrations

Every company has multiple applications and communication tools that they use. Let’s benefit from the blessings the portal offers us at the same time and speed with the integration of a lot of different themed applications like finance, marketing, customer relations, sales and management. 😊

The most important goal of the portal that solves the hardest matters for you is to increase productivity by staying on a single common area, to provide organization and parallel to that, to offer us a corporate culture with a mature and strong communication.
The first step is to decide to use a prepared portal for your company and employees.

And the second step is to meet Velocity! 

The Effects of Severe Paper Usage in the Office on the Deforestation

Forests cover approximately the 30% of the land mass of our planet. While forests provide food, medicine, fuel for more than one billion people, people ruin this fundamental living space on a large scale and cause deforestation.  Unfortunately, long-term benefits of trees are sacrificed for short-term gain.

This year, one of the topics of World Economic Forum was the long-terms hardships of climate change alongside decreasing the economical and political threats.  Limiting climate change is on our hands just like we reversed the ozone depletion. Because there is one earth only and the risks awaiting us in the next 10 years can bee seen in the table below.

In terms of long-term risks, according to the report in which all the first 5 global risks of the next 10 years was about environment for the first time, extraordinary weather events, failures about decreasing climate change, large-scale natural disasters, loss of biological diversity, the downfall of ecosystem  and the damages people cause to the environment are seen as global risks that can cause serious effects.

Deforestation

With the general definition, it is making the forests or planted fields non-forested lands by ruining them. Turning forestlands into fields, farms or urban usage areas can be shown as an example.

The positive impact of forests and trees make the base of our existence. For this reason, they touch a lot of areas from fighting poverty and hunger to decreasing climate change and protecting biodiversity. We can sort out some of the impacts that touch our lives like this:

Impact on Contagious Diseases:

In 1997 , Indonesia’s rain forests were burned down to make roads; the fire intensified with drought. Trees didn’t produce fruits, fruit bats didn’t have a choice but to fly somewhere else to look for food, and brought along a deadly disease. A short time after the bats places on the trees of Malaysia gardens, the pigs around them started to get sick. They probably started getting sick after they ate the fruits that fell onto the ground after bats chewed them, just like the pig farmers… In 1999, 265 people had a serious brain infection and 105 people died. It was the first know break-out of the Nipah virus among people, and this caused recurring pandemics in Southeast Asia from then.

In the last 20 years, scientific researches show that deforestation creates parasites that cause deadly diseases like malaria and Lyme caused by contagious viruses like Nipah, Lassa viruses by triggering a complicated action sequence. A lot of viruses coexist with the animals in the forests without any harm, because animals have evolved with them. But when humans go into the forest habitat or change it, they can be unwanted owners of pathogens. Also, the rodents that carry viruses have been detected in deforested lands in Panama, Bolivia and Brazil.

Impact on Water;

The three out of four of world’s freshwater comes from forests basins and the quality of water is impacted by the loss of trees. Forests are our water fountains. They provide water for more then 1/3 of the world’s biggest cities.

Impact on Food;

Source of income and food safety of around 250 million of rural poor household depend on live forests and trees. Even around 50% of the fruit we eat come from trees; thus, non-wood forest products (NWFP) provide as food as well. Increasing food security without reducing forestland is one of the biggest hardships of modern-day.

Impact on Energy;

Around 2,4 billion people utilize wood for cooking, boiling water and heating. In general, forests provide approximately the 40% of global renewable energy as wood fuel. For that, it is necessary to focus on producing wood fuel more sustainably to reduce deforestation.

Impact on Air;

Forests that act as carbon sinks, are equal to approximately 2 billion tone carbon dioxide each year.

Impact on Our Children;

Children are usually more active when they are in a green field. For example, the rate of obesity in children in places where green fields are more reachable is around 11-19% lower compared to places where reaching green fields is limited or impossible.

When we analyze the World Economic Forum outputs in terms of the risks all these impacts will cause in short-time, extraordinary heat waves and degradation of natural life is among the negative impacts of which increase is expected in the upcoming period.

How Much Paper an Office Worker Consume in a Year?

Have you ever thought why leading companies of the world are trying to integrate the “paperless office” notion to their workflow within the scope of digital transformation? Here are some striking statistics:

  • An average office worker consumes 10 thousand papers a year. The same worker spends 30-40% of his/her time trying to find documents stored in his/her e-mail, file cabinet at the workplace or in drawers.
  • An average documents is physically copied 9 to 11 times a day.
  • 40% percent of the trees cut for industrial reasons are used for paper production only.
  • The cut trees make the 12-17% of the global greenhouse gas emission.

Is It Possible to Use Papers without Cutting Trees?

According to the statistical data, to make  100% non-recycled 10 batches of copying paper a bit more than half a tree is needed. A tree produces a bit more than 8333 paper sheets; for a roll paper of 500 sheets 6% of the tree is used.

While some people think that paper usage is a corporate culture, the others use it because of personal habits. But, wouldn’t it be cheaper to create and test digital versions of different business models? In fact, these days there is no aspect of an entity that cannot be modeled. You can choose the digital tools that are suitable for you and create your vision accordingly. We have compiled some of our solutions that will help you during your digitization process.

Let your e-mail signatures reach hundreds of people with Sign&GO.

As e-mail signatures take the place of business cards, the importance of messages they transmit increases. You can both announce your brand perception the best way possible and use the fastest and cheapest communication tool to increase your recognition with e-mail signatures that will reflect your corporate identity. Using less business cards equals to cutting less trees.

At the same time, it is not very easy to reach out to your customers fast and keep them up-to-date nowadays. Conveying your informative messages, current news to a lot of people will enable you to reach out to the right audience with your e-mail signatures. With your e-mail signatures, you can transmit messages that you can add like “During these hard times our country is going through, we are thinking about you, our partners, and share the most productive working methods on digital platforms with you” to hundreds of people.

 

Become Suitable for Collective Work with Velocity

Velocity is an intranet platform that digitizes and facilitates all the communication processes of companies. We know that the some of the essentials of a portal that creates your corporate culture are announcements, files, request forms (off-day, expenses, advance, training etc.). All these processes help you to solve your communication in a fast and integrated way with zero paper consumption.

You will spend less time sharing files and documents with your other branches. Enables you to show your corporate announcements on a single platform without needing any printed material like brochures of banners. It also helps you to publish documents in scope of Law of Protection of the Personal Data like employee clarification text and vehicle tracking system clarification text without using any paper.

 

Be Socially Responsible with Paper-free Projects

Maybe we should leave the old application methods aside and change to digital tools and create paper-free projects. During process we might be able to save our money, energy and a few forests… We should at least try it. Our world needs oxygen, water, food and our children.

We can start the change from our office where we spend most of our time  and our corporate culture with digital workplace applications. Because one day some topics we remain distant from might become an obligation. Just like the Covid-19 pandemic that caused us to lock ourselves in the house. We wish everyone a health feature.

Sources: