Apr 3

In techtudo.com.br
“Apartir de abril, usuários de versões antigas do Office não terão mais suporte para editar documentos gerados nas edições mais recentes da suíte de produtividade da Microsoft. Essa possibilidade é garantida pelo Pacote de Compatibilidade do Office. É ele que garante que usuários de versões anteriores ao Office 2007 possam abrir e modificar arquivos gerados em versões mais recentes do Excel, Word e PowerPoint sem perda de funcionalidades. Segundo a Microsoft, o Pacote de Compatibilidade será retirado do ar no próximo mês.”

Link:

https://www.techtudo.com.br/noticias/2018/03/microsoft-vai-encerrar-pacote-de-compatibilidade-do-word-excel-e-powerpoint.ghtml

May 5

Sempre e acima de tudo… Excel

May 5

Imagine transformar as suas Listagens e BD em Excel numa aplicação Mobile totalmente funcional.
A sua aplicação em Excel mantém-se inalterada e em paralelo têm um app mobile em que pode consultar e modificar os seus dados. Mais informações durante este mês de Maio…

Source: Hootsuite

Apr 22

Está também previsto para o final de Março mês que o serviço passe a criar relatórios capazes de mostrar a maneira como cada utilizador interage com as diferentes características do serviço.

 

 

 

 

 

 

 

 

–Link para artigo–

Dec 22

A Excel Consulting deseja a todos um Feliz Natal e um excelente ano de 2016!

Nov 8

Today we unbox Excel 2016’s new and improved business
analytics features, so you can take full advantage of each
capability as it applies to your unique business needs.
Excel 2016 improvements have been designed with the
analyst’s journey in mind, from gathering to consuming data.

Source: What’s new for business analytics in Excel 2016 – Office Blogs

Nov 8

Office 2016, mais possibilidades em Pivot Tables, publicação para power Bi, etc. Muito a ler neste artigo da MS.

<Link>

Nov 8

Ms VBA no AMA de reddit… A ler!

http://www.pcworld.com/article/3001573/business-software/microsofts-excel-team-talks-visual-basic-vs-javascript-and-mac-woes-in-reddit-ama.html

May 4

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database. Excel can handle a lot of day-to-day office data this way, and we’ll show you how to set it up.

How Excel makes a relational database
Relational databases—databases structured to recognize relations among the information stored in them—are essential for working with large amounts of business data. They let you quickly search and retrieve specific information, view the same data set in multiple ways, and reduce data errors and redundancy. Try doing that with a spreadsheet.

To show you how Excel makes it easier, we will create two tables: the master table and the detail table. The master table is the primary table, which generally contains unique records (such as name, address, city, state, etc.). This table rarely changes except to, say, add or delete individuals.

For every record in the master table, there can be many records in the detail tables (also called slave or child tables) that link back to the master table. This is called a one-to-many relationship. The data in the detail tables—such as daily sales, product prices, quantities—usually changes constantly.

To avoid repeating all the master information in every detail table, you create relationships using one unique field, such as the Sales ID, then let Excel do the rest. For example, you have 10 sales people who all have unique, demographic information (master table). Each sales person has 200 products that he/she sells (detail or child table). At the end of each year, you need a report that provides the total yearly sales by person, but you also need a report that provides the total sales by city.

For this tutorial, we’ll create a master table with the salespersons’ information and a second table that provides their total sales, by quarter, for the year. The Sales ID is the relational field that connects the tables. Then, we’ll create a report (or pivot table) that shows which cities had the highest sales.

Open Excel and select a new, blank worksheet.

LINK

Jan 23

Segundo o site Pplware  a microsoft irá lançar uma segunda versão do Office 2016 preparada para ser utilizada em dispositivos com ecrãs de menores dimensões e com a capacidade de serem controlados directamente com o toque.
Esperemos que as funções de programação e compatibilidade total de mantenham.

Para ler o artigo PFF siga o link
http://pplware.sapo.pt/informacao/microsoft-vai-lancar-uma-segunda-versao-do-office-para-windows/

« Previous Entries