This week Michael Tejedor joins Jeremy Chapman on Office Mechanics to give a first look at the updates to Power BI. The preview announced yesterday adds a number of new Power BI capabilities, including dashboards, new visualizations, support for popular software-as-a-service applications, a native iPad app and live “hybrid” connectivity to on-premises SQL Server Analysis Services tabular models. Michael demonstrates all this and more on the show and explains how to establish a secure connection to on-premises data using Power BI.
Overview of Office 365
Office 365 is suite of Microsoft products delivered software as a service from cloud. For consumers it represents a simplified pay as you go model, helping them use office products across multiple devices while for the enterprises the value proposition is workplace transformation by driving Enterprise Mobility.
Consumers can now pay a monthly subscription fee and have the word, excel and other office tools installed across 5 PCs and Macs. Users also get 5 more mobile office installs for Android and iOS platforms and there is a feature available called Office on demand which allows users to temporarily stream office 2013 applications on a windows 7 / 8 PC. In addition, one gets 20 GB of SkyDrive integrated with Office Web Apps (a subset of desktop version) and 60 Skype world minutes to make calls in over 60 countries.
Enterprises, on the other hand, are being disrupted by various…
View original post 195 more words
Getting started with VBA
This article is get you started with VBA.
After almost 20 years I have learned VBA, Microsoft never changed Macro to be able to use C# without using Visual Studio. Hence, many people stuck with VBA.
This article will show you how to start VBA in Excel 2013.
1. Start Excel 2013.
2. Go to File Tab -> Options -> Customize Ribbon then enable the Developer tab.
3. Go to Developer tab choose Insert, under ActiveX choose Command Button.
4. Double click the Command Button Excel will bring you to Visual Basic. Type the following code inside the CommandButton1_Click().
Private Sub CommandButton1_Click(
Worksheets(“Sheet1”).Activate
Range(“A1”).Value = “1”
End Sub
5. Back to the Excel sheet click the Design Mode to enable to run mode.
Now you can try to click the button.
Elliot Balynn's Blog 