PowerPoint Shortcuts: The Most Frequently Used

You can have full control during your presentation with the PowerPoint shortcuts.

Start the Presentation: F5

You can start your presentation with the F5 shortcut.

Advance to the Next Slide: N

You can use the N key to advance to the next slide.

Return to the Previous Slide: P

You can use the P key to return to the previous slide.

You can use the N and P shortcuts (Next and Previous) to switch between slides.

Return to the First Slide: 1 + Enter

You might want to return to the first slide during the presentation. In this situation, you can return without having to return one-by-one. For that you need to press 1 and then Enter.

Start the Presentation from the Current Slide: Shift+ F5

You can start your presentation from the current slide without being lost between pages with the Shift F5 shortcut.

Display the Slide You Want: Slide Number + Enter

Use Slide page number and Enter to display the slide you want during the presentation. When you go 20 Enter you can go to the 20th slide.

Group Objects: Ctrl + G 

You can group the object for them to take actions together. Choose the object and then use the CTRL G shortcut for this action.

Blackboard: B 

You can use the screen as a blackboard during the presentation. You can write with a pen on the black background and make your presentation effective.

Whiteboard: W 

You can use the screen as a whiteboard during the presentation. You can write with a pen on the white background and make your presentation effective.

Erase all the Marks: E 

You can use this to erase all the marks done with the pen and cursor.

Return to the mouse cursor after you write with the pen: Ctrl + A 

You can use this shortcut to return to the mouse cursor after you write with the pen.

Hide the Pen or Cursor: Ctrl + H 

You can use this shortcut when you don’t want to see a pen or cursor in the screen.

Show hidden pen and cursors: Ctrl + U

Enables you to bring back the cursors you have hidden.

Save the Presentation As: F12

You can use this shortcut when you want to save your presentation as different formats like PDF or video, or when you want to change its location.

Now, you are ready you present faster with the PowerPoint shortcuts!

CONCATENATE vs TEXTJOIN

CONCATENATE vs TEXTJOIN

 

Hello everybody!

In this article, I invite you to say goodbye to the old CONCATENATE function that when we wanted to add a space or any other character while concatenating the data, obliged us to do it one by one and thus that was very laboring, and say welcome to a more efficient function. If you need to join the data in multiple cells and add characters like a space, comma, semi colon, and hyphen; there is just one function that you need to use and that is the TEXTJOIN function.

 

WHAT DOES IT DO 

Like I mentioned above, you don’t need to click cells one by one and use an expression like ;” “; to add a space in between each time  or a statement like & ” ” & when joining with the & character in the textjoin function. It joins each cell in the selected cell range by adding the slicer we’ve indicated. This way, we can join the data in hundreds of cells easily as a text.

 

SYNTAX

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

There are 3 main arguments in the function.

These 3 main arguments are required, the other arguments are optional.Now let’s take a look at what these arguments mean, i.e. what the function wants from us and what we will give it.

 

delimiter
(required)		 A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.
ignore_empty
(required)		 If TRUE, ignores empty cells.
text1
(required)		 Text item to be joined. A text string, or array of strings, such as a range of cells.
[text2, …]
(optional)

Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.

 

WORKING CONDITIONS

  • If the resulting string exceeds 32767 characters (cell limit), TEXTJOIN returns the #VALUE! error.
  • It came with Microsoft Excel 2019. If you are using and older Office version, you will get the #NAME? error and thus not be able to use this function.
  • If you Office 2019 or Office 365, you can easily use this function.

 

USING THE FUNCTION

After we write the function name, we specify the delimeter. And then we will choose how it should behave about the possible blank cells in the cell range. And in the last arguments, we choose the cell range to be joined. Now, let’s take a look at its use together.

 

In the example below, we join the data between the A and G columns with a semi colon in between them.

 

As you see, it is as easy as that to join a multiple cell range in a single text with any character between them.

 

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

Power BI & OneNote Relation: Publish to Web!

There is an increasing integration capacity among Microsoft products. We will start our article by talking about the integration between Power BI and OneNote. OneNote is a Microsoft product that has been released as a notebook and that has become more than a notebook with the updates it got. You can click here for general information about OneNote. You can get the text of an image with the updated (details here), and search between images (details here).

And Power BI is Microsoft’s popular reporting product. You can create interactive and impressive reports with Power BI. With the latest update, when you create a public Power BI report or come across one of those report and paste the report’s address to OneNote; OneNote automatically integrates with Power BI and show the interactive and live version of the report on itself. This way, it is not necessary for us to click the link and be directed to the website. And we don’t get to be left with the questions like which report was on this link.

 

Power BI bağlantısını OneNote'a kopyalama
Fig.1 – Copying the Power BI connection to OneNote

So, how do we make the reports made with Power BI public?

If you will not have any problems with sharing the reports you created with Power BI, you can make your reports public. After sharing, people don’t need to have Power BI license to view the report. It is enough for them to have the link.

Let’s take a look at how we create this link:

We will execute these actions on Power BI Web Portal ( app.powerbi.com). We don’t have to know with who and on which work environment this report will be shared in order to create the link. Open the report we want to share. Go to this option that was among “Export” options before through the “Embed” option on ellipsis. Click the “Publish to Web (Public)” command here.

publish to web komutuna erişim
Fig.2 – Access to the Publish to web command

You might come across two types of warning here:

1- Since this feature can be restricted on the Power BI Admin portal, it has to be enabled by your admin first. You might get an error message concerning this (Fig.3). If you get this error, you have to contact your admin and notify him/her.

Contact your admin to enable embed code creation
Fig.3 – Contact your admin to enable embed code creation

2- When you create this link, an info message indicating that this report and its content will be public and you shouldn’t use this feature is you will share it with certain people in the company will pop up (Fig.4).

Embed in a public website
Fig.4 –  Create an embed code for public reports that you can include on a website

Click the “Create embed code” option to share your report publicly. When you click, another warning message pops up(Fig.5). Click “Publish” as your last decision.

Embed in a public website
Fig.5 – Information about you are creating a code for public website

After you click, a link where we can share on mail, social media etc. and people can access is created. Right below it you will find the html format to embed it on a website (Fig.6). This way, anyone who has the link will be able to view this report doesn’t matter if they have license or not.

Link you can send in email
Fig.6 – Link of the code

When you have multiple embed codes or want to delete a link, you need to click on the setting icon and then click the manage Embed codes option in order to go to the window where you can manage these codes. You can get the embed codes again or remove these codes on the screen that pops up.

Manage Embed Codes
Fig.7 – Managing embed codes

Hope to see you in another article…

Good game well played.

 

THE TABLE FORMAT and ITS BENEFITS

In this article, we will be talking about the benefits of the table format of the data range in Excel. When we write titles and enter data under those title or when working on a prepared file we received, we say that we have prepared a table. But the data range we call a table is not a table for Excel yet. For it to be seen as a table, you need to format the data range as a table. At that point, it allows us to use a lot of features that table format allows us.

Now let’s take a look what we need to do before creating to table to use some features and how we do them after formatting as table. By the way, it would be very helpful to write the articles on our Blog when you have a chance. If you wish, you can read a detailed article on Office Support.

 

Choose Style for the Table Format

We can use this feature by choosing Format as Table in the Styles group in Home tab. Choose any cell on your data and click the Format as Table command and choose the table style you want. You will have turned your data into a table quickly. Don’t forget: Everything added to the page later is an object. An image, shape, chart, table, slicer etc. all of them are objects and a menu with features of objects added later is added to the Ribbon.

You can apply this feature easily with the shortcut keys.
Choose any cell on your data and turn your data into a table with the

  • CTRL + T

shortcut.

 

Now, let’s see what kind of features our data range gained with such a simple shortcut.

 

Benefits of the Table Format

  • When you choose a cell on the table and move upwards and downwards, the column titles will be the titles of your table. Thus, you don’t need to use the Freeze Top Row feature in the Freeze Panes field in the View tab.

 

 

  • A style is applied to our table automatically and each row is colored as dark and light successively one-by-one. And this creates a nice image.

 

  • When you keep entering data under the table or next to the table, your table gets longer and wider. And this enables the data we enter later to be included in the table and everything to be accepted as a whole.

 

 

  • Before applying the table format, when we want to get the 18% VAT in the Sum field written to the next column; we had to write the formula into a cell and drag it down first. If there are blank rows in between, we had do drag down again. But, when we format it as a table, it is enough to write the formula and press Enter for the formula to be applied on the whole column.

 

 

  • When we turn the data into a table, a menu named Table Design or just Design is created in the Ribbon. This menu contains the features that we can use for our table. One of the most important features is the Slicer feature that we are familiar with from the Pivot Table. This feature enables us to filter the area we want on our table with one click.

 

 

  • It allows us to add functions like sum, average, count, min, max easily when we filter on the table. You can take a look at the other Table Style Options.

 

 

  • When you create a Pivot Table from the data range, you have to choose Change Data Source most of the time when new data is added outside the field specified as the range. Considering that you add new data to your table every day, you will have to choose Change Data Source and specify the new data range all the time. But, when we turn our data into a table, the data we add under it or next to it will be accepted as a part of the table and is within the data range. Thus, it will be enough to Renew for the data to be reflected on the Pivot Table.

 

 

  • In the formulas, we get to specify the data range by writing the table’s name without having to choose the whole table.

 

 

We have seen a lot of positive features till now and we obtained them with CTRL + T only.

Big or small, we recommend you to use Format as Table while working with data.
This way, you will be able to use the features above that will make you gain visualization and speed.

 

Convert to Range

Lastly, when you want to convert your table to data range again, you have two options.

  1.  By choosing Convert to Range in the Table Design or Design menu.
  2. By right-clicking a cell on the table and choosing Convert to Range from Table.

 

 

I hope that this was a helpful article for you.
You can share this article with your friends and help a lot of people get informed as well.

Good bye. 👍🏻

 

Shape Power Automate Flows Based On Forms Responses

We mentioned that it is possible to securely collect data in electronic environment with MS Forms. The automatic workflows are done with Power Automate flows.

In this article, we will create a flow that will be shaped based on the choices of the user by adding the Choose Action question.

If the user chooses Send Form to Approval, the Approval process is going to start. In the other case, only an info e-mail will be send.

After you add the Choose Action question to the Form, you can start the actions with a blank flow by switching to Power Automate.

Power Automate

While creating all flows, a trigger is created in the first step. Trigger is a required step for the flow to start working and it is important to specify it correctly. The flow we will create in this article will work when the Form is responded. So, the flow will be triggered every time the form is responded and will start to work. Add the When a new response is submitted trigger.  It is specified from the list of which poll is going to cause the flow to start when responded.

In the next step, we will look at the responses of the poll. Add the Get Response Details step to access the responses.

Choose the name of the poll in the Form Identity field. Choose Response Notifications List Response Identity for the Response Identity.

This step enabled us to access all question fields. This way, we can get the response of the Choose Action question.

In the new step, add Condition to test the response. Add the Choose Action question to the left with dynamic content.

And on the right, one of the responses will be written. Since we will be controlling a String, we will be using the String function.

It will be checked if the response given with the String(‘Send Form to Approval’) expression is equal to this value.

Add Approval to the Yes field of the Condition and Send an E-mail to the No field, and complete the process.

The approval mails can be sent to the person who has created the request (to the person who sent the form to approval) based on Approved/Denied condition.

Click here to read the other Power Automate articles.

New Products on Power Platform

Power Virtual Agents

Power Virtual Agents, the system where you can create your own ChatBot!

With Power Virtual Agents, you can create a learning chatbot structure.

A system where you decide the questions and answers. The way it works lets you start the flow with Power Automate and is very prone to be developed.

 

You can create custom workflows with Power Automate within the Power Virtual Agent, or work in an integrated manner with the products and services with the help of hundreds of conductors by creating complex scenarios with Microsoft Bot Framework.

Evaluate Performance
You can track the bot’s performance and always make improvements by using the AI and data-based analysis on the dashboard.

Click here for detailed information.

In and Out Animations with Buttons

You can try different method to make a more effective presentation. This way, you can present in a more catchy way visually and more effectively.

The enveloped move outward when you click the mail box in the animation above.

We can start by adding images.

We choose all of the envelope items that need to move when we click the mail box. Click the Add Animation button from the Animations tab and choose More Motion Paths. We add the animation by choosing Right.

When you add the animation it will look like the image below. The road map of the animation is shown with the dotted lines. Green dots are the start of the motion and the red dots are the end of the motion.

We change the start and end motion of the animation by dragging the green and red dots.

We drag and leave the green dots (starting points) to one point in the box since we want the envelopes to move outwards from the mail box. You can leave the end points the way you want.

Now, for the envelopes to move when we click the mail box let’s choose all the envelopes and click Trigger button next to the Add Animation button and then choose the mail box image within On click of. (If you don’t know the name of this image, or if there are multiple images and you don’t know which one, you can track the items with the Home Tab- Editing-Select.)

The Hard Exam of Technology Industry with Corona (Covid-19)

The Corona virus -which started to spread rapidly from Wuhan, China- affected the economic situation of many countries. While international events, seminars, conferences and concerts were canceled, entry and exit to countries came to a standstill. The virus, which negatively affects every area, also created negative consequences for the technology sector. Facebook has canceled the Global Marketing Summit, which was going to be held in San Francisco between 9-12 March, due to the Corona virus. In addition, many leading companies in the industry such as Amazon and Microsoft postpone or cancel their activities one by one. One of the most important of the canceled congresses was the Mobile World Congress (MWC) held every year in Barcelona on February 24-27. These cancellations remind us every time that we are on the brink of Pandemic.“In the statement made by the WHO stated that the world is not ready for the new type of corona virus and that China has gained experience by fighting with SARS and that this situation will be difficult in countries where there were no virus cases before.”

The Impact of Corona (Covid-19) Virus on the Technology Industry

In China, which is the heart of technology equipment production, new hardware investments have been difficult, and the procurement process of spare parts orders for broken parts of the hardware in the hands of companies has been very long. Prolonged hardware supply and uncertainties regarding the future negatively affect the shares of major hardware manufacturers in Nasdaq.

While production came to a stop, many equipment were also banned from entering countries. In the canceled meetings, summits and events, the business processes of the companies have come to the point of stopping. As much as possible, employees of technology companies canceled travel plans within the country as well as travel between countries. Even in European countries where Corona is not common, employees prefer to work from home. Companies trying to continue their business have started to organize their communications through online platforms.

While working from home was possible for white-collar workers, many factories had to be closed because the option of working from home was not possible. While working from home used to be seen as a way of working and a privilege that many employees embrace, this has become a necessity for many countries where Corona has spread.“Samsung closed its factory –where it produces mobile devices in the city of Gumi, South Korea- after an employee was infected with a virus in the factory .”

Companies want their employees to work from home

Companies that do not endanger the health of people against the risk of infection, but have to continue their business processes on the other hand, have started to continue their business from platforms where they can communicate with applications such as Teams.

It is possible to say that Corona (Covid-19) was the first serious test of collaborative platforms such as Microsoft Teams worldwide. We can say that business continues in institutions that can continue to communicate and collaborate through these platforms. In fact, Microsoft decided to offer its Office 365 E1 license free for 6 months due to Corona, which is an admirable behavior.

In this process where travel is not possible and meetings are canceled, it became important to provide video communication. Employees can continue to work from home as long as they can communicate by video and hold their meetings online. In this way, they can organize their work processes independently of time and place through platforms where they can work on the work file at the same time, exchange documents between teams, and chat and make video conferences.

Twitter announced that it “strongly encouraged” all of its nearly 5,000 employees globally to work from home. As employees are not able to go to their offices, the importance of communication via online platforms is increasing in order for the communication not to be interrupted and for the economy not to get affected further.

Click the link to contact us to discover Microsoft Teams and become and effective Teams user.

You can click on the report to follow the current distribution of the Corona virus within countries.

Briefing Concerning Covid-19 Pandemic for our Customers

]Corona Virus Covid-19 Pandemic Briefing and Emergency Action Plan

We have taken responsibility and brought a few practices to life in order to protect our employees, customers, suppliers and our shareholders because of Corona Covid-19 pandemic. You can download our emergency action plan to learn about the actions we take.