Excel 2019 or Office 365

Microsoft Office 2019 or Office 365
Microsoft Office 2019 or Office 365

With Microsoft releasing new versions every 3 years, you may be wondering if you need to upgrade, and to what version. Many people are confused if they should buy Microsoft Office 2019 or Microsoft Office 365.

Here we list a few considerations that will help you choose the correct version of Office

The main difference between Microsoft Office 2019 and Office 365 is a cosmetic one – it’s about the license.

  • Microsoft Office 2019 is a perpetual license. You pay for it once, and then you use it forever. You don’t have to pay for it again.
  • Microsoft Office 365 is a subscription product. You have to pay a subscription fee monthly or annually to use it.

Now you may be thinking, pay once and use it forever is a better choice. Right?

But wait till you check out the pros and cons of a perpetual license of Microsoft Office 2019.

Benefits of Microsoft Office 365 Over Excel 2019

Office 365 Applications
Office 365 Applications

Microsoft Office 365 is purchased directly online, from Microsoft. And the product receives continuous updates, new functions, features, charts, formulas etc. on a monthly basis.

In the beginning, both Microsoft Office 2019 and Office 365 are similar but give it a few months, and you will see new functions emerge in Office 365 that are not going to be there in Office 2019.

Microsoft has already released a fantastic function called XLOOKUP, which is only available if you subscribe to Office 365. This is a much better function than the most used VLOOKUP. With XLookup you can look up anything, from any column, left or right of the searched value, and this new function does EXACT match by default.

I would say that this function alone is sufficient to consider buying a subscription to Microsoft Office 365. And you get to install your Office 365 on 5 different devices, and you can share the same license with 5 other family members. Isn’t it amazing.

Plus, everyone gets 1TB worth of space on OneDrive – Microsoft’s Cloud storage solution.

Online Connection For Office 365?

And contrary to popular belief, you DO NOT NEED to be connected always to the Internet to use Office 365. You just need to connect to the Internet during the initial download and setup, and to sync your OneDrive or license for updates. There is no need to be online every time you have to use  Office. Because Office 365 Home can be used offline. You only need an Internet access when installing and activating your office.

Our Recommendation for Office 365 or Microsoft Excel 2019

We would recommend that you choose a Subscription model Microsoft Office 365. It will be updated regularly, you get to share it, and the 1TB cloud storage is more than what Google Drive or Google Photos etc. give you for storing all your photos or documents.

Office 365 Training in Singapore

Once you have the software installed, make sure you learn the new functions & features added, so you can make the most of your Office 365 license. You can attend Office 365 Training in Singapore at Intellisoft Systems. We conduct training classes for Excel, Word, PowerPoint for Microsoft Office 2019 and Office 365.

You can join our public classes at Beach Road in Singapore, or if you have a group of people, we can conduct training at your office also.

Just contact us at training@intellisoft.com.sg for any training on Office 365 in Singapore.

Cheers,
Vinai Prakash

Why Learn Python For Data Analysis: An Eye Opener

Python Popularity
Python - Number 1 Programming Language

The workplace has already changed. As technology continues to rapidly transform industries & jobs, staying relevant & competitive requires continuously updating, diversifying, and building completely new skill sets.

Today, Data analysis is no longer the job of IT folks. Everyone is required to analyze the past, adapt to change, and forecast the future. The ability to do so well is increasingly what will keep your job.

Learn Python & Stay Relevant

Python is a great programming language for data science and general data analysis. It is open-source & free to download for anyone, unlike commercial tools like SAS or SPSS. Find out why you must learn Python for your current & future jobs.

Purpose of Learning Python

It is suitable for almost any data science task, from data manipulation and automation to ad-hoc analysis and exploring datasets.

Python is easy to learn, even for complete beginners. You don’t need a background in IT or computer science.

Who Uses Python?

Python is used by people that want to go deeper into data analysis or apply statistical techniques, and by most people who turn to data science.

Python is a production-ready language, meaning it has the capacity to be a single tool that integrates with every part of your workflow!

Why Learn Python
Why You Must Learn Python

Python Usability

Whether you work in Manufacturing, Services, Banking, Finance, Logistics, Telecom, Marine, Oil & Gas, Shipping, IT or any other industry, you’ll be able to apply Python to everyday work, just like millions of other people. People with a software or engineering background may find Python comes more naturally to them.

  • Coding and debugging is way easier than other programming languages because of the simple syntax of Python
  • Python has a robust ecosystem and is commonly considered one of the easier programming languages to read and learn. Its programming syntax is simple and its commands mimic the English language.
  • Python code is syntactically clear and elegant, easily interpretable, and easy to type.
  • It’s great for building data science pipelines and machine learning products integrated with web frameworks at scale.

Python is Flexible

Python is flexible for creating something that has never been done before. You can also use it for scripting websites or other applications.

Python Is Easy To Learn

Python’s focus on readability and simplicity means its learning curve is relatively linear and smooth.

Python is considered a good language for beginners. No wonder it is the Number 1 Programming language in the world.

Python Programming Training Singapore
Python Programming Training Singapore

Advantages of Python Over Other Languages

  1. General-purpose programming languages are useful beyond just data analysis.
  2. Python has gained popularity for its code readability, speed, and many other functionalities too.
  3. It is great for mathematical computation & learning how algorithms work.
  4. Python has high ease of deployment and reproducibility.

Popular Libraries and Packages

  • pandas to easily manipulate data
  • SciPy and NumPy for scientific computing
  • Scikit-learn for machine learning
  • Matplotlib and seaborn to make graphics & charts
  • statsmodels to explore data, estimate statistical models, and perform statistical tests and unit tests

Getting Started in Python

There are many Python IDEs to choose from which drastically reduce the overhead of organizing code, output, and notes files. Jupyter Notebooks and Spyder are 2 such popular tools that we teach at Intellisoft.

Learn Python Step-By-Step: Instructor Led Training

The best approach to get initiated with using Python is to go for our Step by Step, Beginner Course to introduce the Python Language to you.

With an experienced and knowledgeable instructor ready to explain simple to complex topics with ease, it will be a much better experience.

Plus, attending training will significantly reduce the learning curve, and you will thank yourself for having a quick and rapid start to learning the world’s most popular language – Python.

Contact Us for our Python Training Programs.

Call +65-6296-2995 or email training@intellisoft.com.sg for a Python course brochure.

Article Written By: Vinai Prakash, Intellisoft Systems

Power BI Tip #6: Fixing The Vertical Axis in Power BI Visualisations

Power BI Visualizations are amazing.

The charts and dashboard created in Power BI make it easy for end-users to slice and dice it, visualize the data in any way.

While this is great, some care is needed on the part of the Power BI Dashboard Designers, to make sure that the data is understood in the correct way, and does not lead to any confusion or miscommunication due to the lack of presentation oversight.

Take control of Power BI Charts by manually configuring the Power BI visualizations, and gain more power.

Automatic scaling can mislead people into assuming that the data is all good, and may not yield clear comparison.

In Power BI Charts & Reports, the Vertical axis scales automatically, based on the current slicers, current data and filtered context.

To get more control over the axis, watch this important video tutorial on Power BI, and learn to fix the Y-axis to your advantage.

Tutorial Presented by

Vinai Prakash, Founder & Master Trainer at Intellisoft Systems, Singapore.

For more tips on Power BI, head over to our YouTube Channel, and subscribe to it, to be notified of latest videos and tutorials.

Recommended Reading:

Learn Power BI From Practicing Professionals in Singapore

Intellisoft Systems conducts PowerBI training in Singapore each month. Do attend our hands-on practical training to learn Power BI from the beginning, and be able to analyze and visualize data easily with Microsoft tools.

Visit PowerBI Training in Singapore or email to training@intellisoft.com.sg for a course brochure.

Written & Presented by: Vinai Prakash, PMP, ACTA, ITIL, GAP, MBA

Vinai conducts the Microsoft Power BI training in Singapore. His Power BI courses are extremely popular, fun and easy to learn for beginners and experienced professionals alike.

Join Vinai in his next Power BI training course at Intellisoft. Hundreds of Power BI beginners, power analysts and super users have attended the training and benefited. You could be the next superhero with Power BI training!

Power BI Tip #5: All About Slicer Controls in Power BI

Slicers are really the key feature in Power BI, that make the Dashboards & Visualizations come alive. They add a bit of interactivity in the dashboards and allow the users to select, slice and dice the information in different ways and methods.

With a slicer, you can choose any available year, and the entire report can be filtered to that particular year, or month, or product category, fiscal period, department or division.

Slicers can be created using Checkboxes, Radio buttons, Flat Chicklet style buttons and can be formatted to allow a single, multiple or all value pick.

Since there are a plethora of features, I decided to record a short Power BI tutorial highlighting the key features of Slicers in Power BI.

Hope you will benefit from these features and will be able to build some interactivity in your Power BI dashboards.

Hope you found this tip useful.

For more tips on Power BI, head over to our YouTube Channel, and subscribe to it, to be notified of latest videos and tutorials.

Recommended Reading:

For tips on loading data from the result set of another query, you can use the Reference feature of Power Query

Power BI shows only rows where data is found. If you want to see all rows, you’ve got to see this tip on Showing Rows With No Matching Rows.

Learn Power BI From Practicing Professionals in Singapore

Intellisoft Systems conducts PowerBI training in Singapore each month. Do attend our hands-on practical training to learn Power BI from the beginning, and be able to analyze and visualize data easily with Microsoft tools.

Visit PowerBI Training in Singapore or email to training@intellisoft.com.sg for a course brochure.

Written & Presented by: Vinai Prakash,
Founder & Master Trainer, Intellisoft Systems

Vinai conducts the Microsoft Power BI training in Singapore. His Power BI courses are extremely popular, fun and easy to learn for beginners and experienced professionals alike.

Join Vinai in his next Power BI training course at Intellisoft. You won’t regret it!

Power BI Tip#4: Enter Data Into Power BI Quickly [Video]

Even though Power BI makes it extremely easy to load data from Excel and hundreds of other sources, clean it, and process it in any way, there are times when I wanted to do some testing, and bring in some test data.

I didn’t want to create Excel files and store them. I only wanted a simple way to bring in the data into Power BI.

Finally, I saw that Microsoft Power BI has actually thought about such a need, and there is a prominent button called Enter Data right on the Home screen.

I tested it out, and to my amazement, it worked perfectly. So I have been using it heavily in my work as a Power BI consultant, and architect of Power BI dashboards for our clients. Most importantly, this is one feature that our participants really loved in our Power BI classroom training.

So I recorded a short tutorial on how to use this nifty Enter Data feature of Power BI for your viewing pleasure, and for you to begin using it in your work.

Hope you found this tip useful.

For more tips on Power BI, head over to our YouTube Channel, and subscribe to it, to be notified of latest videos and tutorials.

Recommended Reading:

For tips on loading data from the result set of another query, you can use the Reference feature of Power Query

Power BI shows only rows where data is found. If you want to see all rows, you’ve got to see this tip on Showing Rows With No Matching Rows.

Learn Power BI From Practicing Professionals in Singapore

Intellisoft Systems conducts PowerBI training in Singapore each month. Do attend our hands-on practical training to learn Power BI from the beginning, and be able to analyze and visualize data easily with Microsoft tools.

Visit PowerBI Training in Singapore or email to training@intellisoft.com.sg for a course brochure.

Written & Presented by: Vinai Prakash,
Founder & Master Trainer, Intellisoft Systems

Vinai conducts the Microsoft Power BI training in Singapore. His Power BI courses are extremely popular, fun and easy to learn for beginners and experienced professionals alike.

Join Vinai in his next Power BI training course at Intellisoft. You won’t regret it!

Power BI Tip #3: Quick Formatting of Power BI Visuals

The default fonts in Power BI are quite small, and there is no global setting to set the font sizes in Power BI.

For every new visual you create in the Power BI dashboard, you need to change the sizes manually. This is quite painful and frustrating at times.

Here is a quick way to format Power BI Visuals – Watch this short tutorial to help you save time while formatting in Power BI.

Presented by: Vinai Prakash,
Founder: Intellisoft Systems & ExcelChamp.Net
Visit https://www.intellisoft.com.sg for indepth, practical, hands-on classroom training on Power BI in Singapore with master trainer Vinai.

Power BI Tip #2: Reference Query Results in Another Query With PowerQuery [Video Tutorial]

For most types of analysis, the base data is the same, probably coming from the same source. But the transformations will most likely be different, and the usage will be different too.

For example, Sales data from the past month could be used for many different analysis.

Some common types of analysis could be:

  1. to analyze the sales of the month and identify which products sold or did not sell well OR
  2. to forecast for future month based on past trends
  3. to understand inventory movement, analyze fast-moving and slow-moving goods by segmentation
  4. to recognize revenue
  5. to look at accounts receivable
  6. to analyze performance by salespersons, by geography, by division, by category, by department, and by customer segments

Now in both cases, the way we look at the data will be different, and the analysis will branch out differently too. And for each branch, we will have to load the same basic data, and do the same basic cleanup – remove duplicates, fill nulls, change data types, fix dates etc.

Rather than doing the same cleanup transformations again for each analysis, it is better to do the cleanup only once and save that query. Once the base query is ready, it can be used to extend for further transformation and analysis, depending on the need.

Power Query, which is available to you through Excel or Power BI can be used easily for this (Video Tutorial Below).  The thing to look for is

How to Reference a Query and Create a New Query from it

Referencing a Query allows us to simply take the result of one query, and take it further in another query.

I created a detailed, step by step video for you to see how to reference a query in Power Query. You can use it in Excel or in PowerBI. It works exactly the same way in both of these softwares.

I do hope you like it. You can subscribe to our YouTube Channel to be notified of new videos automatically.

Hope you do like our Excel & Power BI trainings, videos, and Online Blogs on Intellisoft website.

Learn Power BI From Practicing Professionals in Singapore
Intellisoft Systems conducts PowerBI training in Singapore each month. Do attend our hands-on practical training to learn Power BI from the beginning, and be able to analyze and visualize data easily with Microsoft tools.

Visit PowerBI Training in Singapore or email to training@intellisoft.com.sg for a course brochure.

Written & Presented by: Vinai Prakash,
Founder & Master Trainer, Intellisoft Systems

Vinai conducts the Microsoft Power BI training in Singapore. His Power BI courses are extremely popular, fun and easy to learn for beginners and experienced professionals alike.

Join Vinai in his next Power BI training course at Intellisoft. You won’t regret it!

 

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!