Change Users & Groups settings on Mac

If your Mac has multiple users, you should set up an account for each person so each can personalize settings and options without affecting other users. You can let occasional users log in as guests without access to other users’ files or settings. You can also create groups and choose automatic login options. You must be an administrator of your Mac to perform these tasks.

Both standard users and administrators can join network account servers.

To change these settings, choose Apple menu  > System Settings, then click Users & Groups  in the sidebar. (You may need to scroll down.)

[mai mult...]

Change the login password on Mac

It’s important to change your login password from time to time to protect your privacy.

Note: Your login password is the password you enter to unlock your Mac when you turn it on or wake it from sleep. It is not your Apple ID password, which gives you access to the iTunes Store, App Store, Apple Books, iCloud, and other Apple services.

[mai mult...]

Two-dimensional Pivot Table

If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. First, insert a pivot table. Next, to get the total amount exported to each country, of each product, drag the following fields to the different areas.

[mai mult...]

Create a graph in Excel

 There are three basic types of graph that you can create in Excel, each of which works best for certain types of data:

  • Bar – Displays one or more sets of data using vertical bars. Best for listing differences in data over time or comparing two similar sets of data.
  • Line – Displays one or more sets of data using horizontal lines. Best for showing growth or decline in data over time.
  • Pie – Displays one set of data as fractions of a whole. Best for showing a visual distribution of data.
[mai mult...]

Connect your Excel workbook from OneDrive for work or school to Power BI

When you choose Connect, your workbook appears in Power BI just like it would in Excel Online. However, unlike Excel Online, you have some great features to help you pin elements from your worksheets right to your dashboards.

You can’t edit your workbook in Power BI, but if you need to make some changes, you can select Edit from the Workbooks tab of your workspace. Then choose to edit your workbook in Excel Online or open it in Excel on your computer. Any changes you make are saved to the workbook on OneDrive.

[mai mult...]

Create a copy of a dashboard in the Power BI service

There are many different reasons to make a copy of a dashboard. Maybe you want to make changes and test its performance against the original; or create slightly different versions to distribute by colleague, region, or team. Perhaps a colleague admires your dashboard design and wants to use it for reporting out to their managers. Another reason would be if you have a new database with the same data structure and data types and want to reuse the dashboard you’ve already created. This can be done but would require work in Power BI Desktop.

Dashboards are created and copied using the Power BI service and can be viewed in Power BI mobile and Power BI Embedded. Dashboards aren’t available in Power BI Desktop.

[mai mult...]