How Do You Turn an E-Mail Signature into a Marketing Tool?

As the communication processes are digitalizing, e-mail signatures are becoming an important marketing tool for every sector. Digitalization of communication also plays an important role in the determination of the target audience. Bearing in mind that a worker sends an average of 121 e-mails every day and the average number of this is 293,6 billion globally, why would you wait more to use e-mail signatures correctly? 

Create your Marketing Strategy with your E-Mail Signatures! 

You can create a pretty  effective marketing strategy by including your workers to the marketing process in the equation where when your visibility increases so does your brand’s recognition. You wonder how? 

You can make sure to reach the correct target audience the fastest and cheapest way the moment you add your announcements, campaigns and advertisements to your e-mail banners in a system that you can manage all your signatures centrally.  

Numbers don’t lie!  

According to the studies every day the average worker sends 121 e-mails in average. Considering that the number of sent e-mails in a company with 100 workers is 12.100 making sure that your messages reach to thousands of people makes you obtain incredible results.  

What you have to do to use such a fast and easy communication tool is pretty simple.  

Design Your E-Mail Signatures without Waiting for your IT Department 

Being able to access your e-mail signatures anywhere and anytime is the most basic matter when it comes to announcing your new advertising campaign without wasting time. Keep the control of the signatures that you can easily manage and update centrally. A consistent and well-designed signature banner increases your brand identity and reputation. You can create your own designs and advertisements easily without needing the IT department. Wouldn’t you like to design your own signature right now?

Time to Say Goodbye to Business Cards 

We have a culture of loving traditionalism and not being able to detach from it. There are a lot of people who especially like to buy and even collect business cards. But in these times where lately the contact decreased, the meetings are done online, and the companies change to digital management the life of business cards comes to an end.  

You can use the announcements and campaigns that you have on your e-mail signatures that you always keep updated as your business card and also reach them to hundreds of your associates, clients and end users. This would be an excellent communication channel that is more interactive compared to handing out your business cards one by one and that you can get the feedback immediately from.

Locate your Banners Correctly!  

You can send the messages that you have highlighted the content of, advertised, and that you want to convey with the designs that reflects your corporation to your potential clients instantly.  

 Having more fame and sticking-in-mind better is as close to you as a signature. 

Your e-mail signatures that you have created with a short and effective message will increase the click rate as well. And this will provide you competitive advantage. The simpler and more comprehensible for your target audience the message content, design and content language is, the more impact you will have on the receiver.  

Imagine creating different advertisements for each one of your advertising campaigns and activities and having to updating them all the time. This process will be a burden for you in terms of both time and costs. The effects might ware off as you plan the right campaign and you might not be able to get the desired reaction right away. You can design your e-mail signatures for the campaign and the target audience you desire on a department, sector or person base. Thus, the messages you send will be more personalized. Making a good impression on the e-mail receiver will be very important in terms of your persuasiveness. 

You can liven up your mails with the signatures you can effortlessly design on Sign&GO and reach your brand recognition to the target audience you desire with a right strategy.  

 

Power BI – 2020 July Favoruites

Hello dear reader! This month’s updates are for those who can resist the charm of sea and sand right in the middle of summer. There are two very important features among Power BI July 2020 updates. Let’s go and take a better look right away.

1-   The most important update: Financial Functions on Excel are now on Power BI!

A total number of 49 financial functions are coming to the infrastructure of Power BI. Since we build financial reports on Power BI, it is especially nice to have these functions. These functions added to Power BI have the same function same and syntax as in Excel. You can reach functions and their details here. You can find the names of new functions below.

FINANCIAL FUNCTIONS
ACCRINT CUMIPMT INTRATE PDURATION SLN
ACCRINTM CUMPRINC IPMT PMT SYD
AMORDEGRC DB ISPMT PPMT TBILLEQ
AMORLINC DDB MDURATION PRICE TBILLPRICE
COUPDAYBS DISC NOMINAL PRICEDISC TBILLYIELD
COUPDAYS DOLLARDE NPER PRICEMAT VDB
COUPDAYSNC DOLLARFR ODDFPRICE PV YIELD
COUPNCD DURATION ODDFYIELD RATE YIELDDISC
COUPNUM EFFECT ODDLPRICE RECEIVED YIELDMAT
COUPPCD FV ODDLYIELD RRI

2-Notable Update: Azure Maps visual

Another update we see as important is Azure Maps being included among the defaults images of Power BI.  But, why is it so important? This chart has different  features than the other map charts.

Now we can add extra layers to maps. One of them is “Reference Layer”. With this feature a GeoJSON file containing custom location data can be uploaded and overlaid on the map. This way you can use it as a reference layer containing different information like population and real estate.

Another one is “Custom Tile Layer”. Tile layers allow you to superimpose images on top of Azure Maps base map tiles. What tiles? For example, weather forecast.

Another standing-out thing is that you can see the real-time traffic overlay on the map in your report. If you work in a logistic related area, it will be very useful for you in terms of increasing efficiency.

In order to activate this update, you need to activate Azure Map Visual in Preview Features. Then, when you restart Power BI, you will see it among default images on the right .


3-Update: External Tools ribbon- Preview

External tools are non-Microsoft tools that work with Power BI and that allow you to create calculations and calculation groups and analyze data in terms of performance. The prominent ones are:

  • DAX Studio
  • Tabular Editor
  • ALM Toolkit

These feature cannot be opened on Preview Features. We need to create a folder and set up these programs in that file. The folder shortcut should be:

Program Files (x86)Common FilesMicrosoft SharedPower BI DesktopExternal Tools

You can get details about downloading these tools here.

4- Gradient Legend

You can now see the color scale that have been conditionally formatted by columns and bar charts as a legend. Of course, unless you add a legend on purpose.

5-Global option to disable automatic type detection

Power Query tries to automatically detect column headers and types based on the data. This feature didn’t function on schema-less data sources and we had to fix it manually. Now we can disable automatic type detection against schema-less sources. This new option can be found under the Options dialog under Global > Data Load.

We cannot talk about data sources in Power BI 2020 July updates 😮 We haven’t come across this situation for a while. If you want to see prior Power BI updates or take a look at other Power BI articles on our blog, click here. Till the next time, take care!

Good game well played

Games as the Language of Children

The importance of games has an irreplaceable place in children’s development in terms of language development, physical and intellectual development and self-care development. Games help children to develop by bringing out their skills like exploration, imitation, and creativity. Games are an opportunity to solve problems.

Even though as parents we doubt the security of technology and feel worried about it, playing games also reflect as learning on our children.

Our children who were born in to a time of digitalization and see tools like phones, tablets, computers and imitate what they see with their imitation skills get involved in this situation -even though we are careful about it and draw the line- somehow. We complied a few applications that can be beneficial as long as parents are in control and that our children can learn as they play.

ABC WOW:

It is an interactive application that helps children to learn the alphabet and English words with objects and the sounds they make when you touch them,  and that helps to develop their visual and auditory memory. The sounds of the objects make children laugh and entertain them. It is a verbal-auditory app i.e an app that is based on language. Although legal age-limit of the app is 4+ you can use it with your babies over 1 under parental control.

 

WWF Together:

This application narrates the interactive story of endangered animals like giant pandas, tigers, monarch butterflies, sea turtles and polar bears thoroughly.It is a learning-centered game that enables getting to know 16 species of endangered animals with information like their features, populations natural habitats, weights and heights. There are also graphics in which origami art was used. There are “origami methods” where they can create these animals with paper within the app. You can execute this paper folding art with your children while having fun. Although legal age-limit of the app is 4+ you can use it with your babies over 1 under parental control.

 

Listen & Understand: 

This app was developed with the goal of contributing to development of comprehension what is being said of children with normal development, along with children who has autism spectrum disorder.

The app consists of 2 parts and 10 modules in total. In each one of the 10 modules there are 10 questions. Another important feature of the application is that it collects and analyzes data for the family and educators. It is a learning-based and a dramatic game as an education method. Although legal age-limit of the app is 4+ you can use it with your babies over 1 under parental control.

Paintbox :

Children’s senses work really well during the game. They develop their skills like perceiving, distinguishing and classifying the data they obtain by their senses in their brains. It is an app designed to improve children’s drawing skills by using colors with graphic and drawings activities on a digital environment. There are 8 types of different brushes and you can automatically save the images. Although legal age-limit of the app is 4+ you can use it with your babies over 1 under parental control.

Stack the Countries:

Provides 193 country flash cards and colored interactive maps of continents. It is an educational app where children can improve their geography and atlas information. It is one of the learning-focused interactive apps where they can get information about capitals, borderlands, flags of countries and continents. The parents can brush up on their information as well and spend some time with their children. Although legal age-limit of the app is 4+ you can use it with your babies over 1 under parental control.

 

Nasa Kids Club

We couldn’t forget about science and technology enthusiasts! Along with the activities on the web page where children can learn a lot about NASA and play games about the space, there are coloring activities for younger space enthusiasts. You can visit their website. With the NASA mobile app we can recommend for adults, you can explore the latest images, videos, task information, news, feature stories, tweets and NASA TV features. Although legal age-limit of the app is 4+ you can use it with your babies over 1 under parental control.

Safe Collaboration with Office Applications and OneDrive

In the 2nd week of our event we talked about some actions we can take in order to prevent data loss in some issues about our computer while working from home. For example, we showed that it is possible to access that data on our phone or another device by keeping a backup of our desktop and other files on OneDrive. We took a deeper look at the simultaneously working on a shared document feature: Writing comments while editing these documents, tracking changes in the documents with the “Track Changes” feature and even accessing old version makes accessing without losing the copies of each document easier. This week we also made our work sustainable with being able to scan our documents by bringing the scanner option at our offices home, saving these documents as PDF and even signing them within the new mobile Office application.

Azure Sentinel Fortinet Connection

Hello everybody! As you know we had the chance to talk about Azure Sentinel before. In this article I want to take a look at the integration with agent, the most important one of the Azure Sentinel Data Connectors. As you might remember, we mentioned that we need to use the integration with agent in order for the Forti Firewall logs to be taken on Azure Sentinel.

We need a linux server on our existing Azure subscription for integration with agent on Azure Sentinel. Python should be installed on the server before setting up agent on the relevant server. I don’t want to lose time on the steps of creating linux server so I will assume that you have set up the linux server and connected with Putty. After we connect with Putty we can move on to the steps of installing python. After setting up the linux server and python, we can move on to the steps necessary for collecting logs in CEF Format.

Command We Need to Run on the Linux Server:

sudo wget https://raw.githubusercontent.com/Azure/Azure-Sentinel/master/DataConnectors/CEF/cef_installer.py&&sudo python cef_installer.py de8f7beb-7100-4d76-a8e1-3d25537a985f dGVvuS4ixQxJhn+R9L0aKep4VpTXinjoBZwNWVqeitXNwYxW485TfZVNvsoVOe0o/mJOzSJ7ivSN0fY8GaTOzw==

 

Strengthen Your Communication with the Right Infrastructure

During these times we see the world from a different window. When we look through this window, which companies are the ones that will maintain their strength, quality and economy? Actually, the answer is pretty simple, each company that managed to play its role in digitalization well will be able to take advantage of the change. It is easy to be one of them by benefiting from the blessings of easy adaptation, practical and fast technological solutions. So, how can we do it and what are these applications? 

Velocity for Teams

Since strengthening communication with a right infrastructure is the most important thing, having Microsoft Teams and Velocity will be enough for you.  While Microsoft Teams, actively used chat-based teamwork platform with Over 70 million users,  shows its features from working on a shared file together to sharing ideas and socializing; from doing group conferences to sharing meeting notes; using Velocity, Intranet Communication Portal, in your Teams gets ahead of all the other portals with its successful integration structure.  

Make tracking your work easier with hundreds of application cards  

Velocity enables the HR to give the most correct information about Carrier, Performance and all the procedures the most practical way possible while the announcements you make about LPPD, OHS and other topics reach out to all your workers and off day for birthday-advances can be created with work flow applications on the same channel. Corners exported from external sources like weather forecast, exchange rates, news and twitter will enable you to get informed while staying in the portal. Velocity also supports integration to a lot of applications that are used by HR, Finance and other departments with the infrastructure it has. On top of that, with Velocity that you can customize however you want with its design suitable for the corporate identity, you create an amazing connection between your workers and the identity of your company.  

How Can you Access Velocity? 

When it comes to accessing the indispensable pair Velocity for Teams, let us tell you that it is very easy. There are tabs for Activity, Chat, Teams, Calendar, Files on the left navigation bar of Microsoft Teams Apps. When you search Velocity on Global Store on the Apps section below, it will appear on the corner you added the app on.  

Moreover, another amazing news for Velocity&Teams is that it is among the best 8 applications in the world in Global. Velocity was chosen among the first 8 applications in all the applications that can be integrated to Microsoft Teams in global. In the evaluation that has been conducted, the first 8 applications were identified and the statute they all have is the same.  

We would like to walk with you on your way to digitalization, to have the best application in global by planning an online demo.  

Office Insider Program – How to Join

What is the Windows Insider Program?

Microsoft Insider

was created for all Microsoft 365 users.

  • Office insider participants are granted first-hand access to new features and updates.
  • You can access dynamic array formulas.
  • In addition to this, you can share your comments about developments with the developers.

Click here to become an Office Insider member.


Access to the Insider Program

The procedure below is the simplest and most complete one.
For a long time it was blocked to go back to “standard” Excel version after you became an Insider .

But with this method you can change between channels anytime you want. smiley

When you go to File> Account menu and want to see information about Microsoft Account like synchronized files, you will see that there are 3 standard buttons that enable you to know your software version number and Office news. If you cannot see the Office Insider button there, follow the steps below.

1st Step: Add Office Insider Button to your Account

After yo do the settings below, you will see that the 4th button is added too. Click on the Insider button.
To do it you need to add a key into registry.  To open your registry type regedit on your Windows taskbar.

Normally Office, 16.0 and Common arrays are not on registry, you need to create them.

Path : HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOffice16.0Common
Key Name: insiderslabbehavior
Value type : REG_DWORD
Value : 1

After you restart Office you will see that on the File > Account menu you have the Office Insider button.

 

2nd Step: Changing Office Channel 

Then, to see both of the recommended levels click on the Insider > Modification Level button.

You can see 2 levels of the available update by clicking on the popup menu: Monthly Channel or Insider.
Needless to say you need to accept terms of use to change the channel of your application.

3rd Step: Differences between the Two Programs

 

Insider Channel
This is the level that open the latest Office updates. Some of them didn’t have the chance to be tested by the developers or to be completed. Thus, it carries a risk to fail your Excel functions and collapse your workbooks (it is pretty common). However, it is the only way to access latest features like XLOOKUP.

My recommendation: Don’t set up this version on a professional environment. Would be better in a test machine.

Monthly Channel
This channel is not for test users, it is for very advanced level Excel users. This version opens up persistent features that are usually non-existent in Office standard version (six month channel). For example, to be able to use dynamic array functions you need to subscribe to one of the 2 levels of Insider. If not, you cannot use them.

For this, if some of your employees want to access features that require Insider, this channel is the one that needs to be set up.

4th Step: Update Office

Whatever Office level you choose, it is a must to update your Office.
Single selection of Office channel is not enough to open the Insider program.

After you choose one of the insider levels and click on update button, upgrade will start automatically.

 

5th Step: Restarting Excel

It is enough to restart your Office apps once or twice to see the changes.

 

Going back to the Six Month Channel (standard version)

The only thing you need to go back to the six month channel which is Office’s basic version:

  • Click on the Insider icon.
  • Uncheck Save to Preview new versions of Office option
  • Update Office again.

 

Don’t forget to check other articles on our blog.
You can share this article and make sure that many other people get informed as well.okay

Bye. 🙋🏻‍♂️

Enterprise Video Portal, Task and Feedback Management

We divided the 3rd week of our Working from Home Practices event into 3 main sections: Stream & Forms & Planner and Teams collaboration functions.

We started our video portal Stream with a general view of easy but very effective features like searching in the portal, uploading videos, adding videos to “Watchlist” and being able to watch them later. Cutting and sharing a video, editing sharing permissions, making the videos interactive by adding polls and quizzes to the minutes we want on Stream we can find our meeting videos is very useful.  Moreover we can obtain integrity by viewing our portal’s channels or videos within Teams.

In the second part we took a look at question types, theme settings for personalizing, sharing options by digitalizing our form and quizzes with our survey application Forms. It is possible to edit questions together by sharing a link to work together, enable one person to answer only or in a certain period of time, register names in answers or answer anonymously with Forms. Also, you can transfer the results to Excel and zeroize the error margin and connect to different reporting tools. These surveys can be used under one app only like Stream by publishing within Teams.

Our last topic the Planner application is our task management tool where we can assign tasks to people and get graphic reports. You can categorize tasks with this tool and filter by these categories or assigned people, and transfer it to Excel. We can add our tasks to Outlook calendar and receive reminders. We included this app as well under the roof of Teams and finished this week’s event.

 

Let PowerAutomate Do All your Routine Work

This week’s Working From Home Practices topic was the PowerAutomate application  on which you can create work flows. While you can create a new work flow from scratch with PowerAutomate, you can also utilize templates in the application. For the work flows to be created there must be a Trigger and an Action in consequence.  PowerAutomate automatizes your work by connecting to 3rd party applications (Google Sheets, Jira, Twitter, SalesForce etc.) with connectors. So this week we created work flows by utilising templates like receiving approval from specified people for a file added to SharePoint Online, notifying when a task is created on Planner by sharing a post on Teams, automatically saving e-mail attachments from Outlook to any area we want on OneDrive and reporting our location with one click. Also it is as easy to create a work flow from scratch without using templates!

Increase your Productivity with Windows 10

In the 4th week of our event we talked about making our work easier along with digitalizing our routine processes with Windows 10. In the previous weeks we mentioned importance of OneDrive and backed up our data. This week we talked about synchronization settings and smartly managing the files occupying our computer with “Storage Sense”. Storage Sense makes the not regularly used files Online Only and thus prevents them to take up unnecessary storage. We managed to have our computers locked when we got away from them with “Dynamic Lock“ by pairing our mobile devices with our computers via Bluetooth.

We talked about synchronizing all our choices from language settings and password to backgrounds between devices with “Sync Your Settings”. Also how to access the pages we worked on, the pages we opened in all devices with Windows’ Timeline feature; how to access everything we copied from one clipboard without copy-paste on “Clipboard” were important details. We wouldn’t skip mentioning the new Edge application. We asked “How can we pin the websites we opened in the browser to the taskbar as an app? We created the problem of opening millions of tabs and getting lost among them by creating Collections. While carrying the PostIt experience to digital with Sticky Notes, we introduced the new screenshot tool Snip&Sketch. And last but not least, we took a look at the Whiteboard feature we mentioned the first week, and left another event full of information behind.