Do You Use These Advanced Features in Microsoft Excel?

Advanced Excel training at Intellisoft
Practical hands-on advanced excel training at Intellisoft
Practical hands-on advanced excel training at Intellisoft

Most people hardly use the huge number of features available in Microsoft Excel. Many are just using Excel as a calculator. This is a gross under use of Excel’s vast potential and feature rich functionality.

Do a quick check, and see if you use these advanced features of Microsoft Excel in your day to day work.

Some of the common things that can be done easily with Excel are:

  1. Finding the Top 10 Customers or Finding the Bottom 10 Performers in the organization
  2. Highlight values that are above or below a certain threshold – like all sales above $25,000 to be highlighted
  3. Sort the values in Ascending, Descending or any customized order – like sorting in order of Manufacturing, Accounts, Sales departments.
  4. Give Names to Range of Cells, and then use them in formulas for easy referencing and decoding
  5. Exploit Pivot Tables to Summarize the data and slice & dice it in any way – finding sales by product groups, or calculating productivity by department
  6. Write Macros to automate routine things that save you a huge amount of time – example creating pivots, charts, tables, and doing complex calculations automatically.
  7. Use advanced filtering conditions, and be able to filter data using multiple different criteria
  8. Create fantastic charts that portray the given business situation perfectly. There are over 50 different types of charts to choose from, and each has its edge, advantages and a reason.
  9. Create management dashboard that are dynamic, and provide a complete snapshot of the key business KPIs in the company – change the chart values at the click of a checkbox or change in a drop-down value
  10. Use Excel’s advanced What-If analysis to do projections for future, forecasting, trend analysis etc. with ease
  11. Use Lookup tables to find any value or corresponding value from a table using advanced functions and formulas

This is just the tip of the iceberg. Microsoft Excel is really extremely powerful. Each version of Microsoft Excel – be it Excel 2007, or Excel 2010 or Excel 2013 adds more and more features to the already powerful dynamite of a package.

At Intellisoft, we teach people how to leverage the maximum power out of Microsoft Excel in short training courses. Some of the popular courses are:

We have a number of Public Classes each month, and we also provided In-House Training to your staff and team at your office, if you have a group of 10+ people, and have a room to hold the training.

So what are you waiting for? If you would like to learn any one or more of such useful features of Microsoft Excel, come for a short Excel Training at Intellisoft.

Go ahead, equip your team with the right skills. Get everyone on board to learn the basic and advanced features of Microsoft Excel, and Be Awesome in Excel!

Email to training@intellisoft.com.sg or call +65-6296-2995 for the next available schedule of Microsoft Excel Training in Singapore.

We are located at Beach Road, in Singapore! Location Map of Intellisoft

Cheers,
Vinai Prakash, PMP, ITIL, Six Sigma, GAP,
Master Trainer

Printing Gridlines in Excel

Gridlines in excel

Do You Know How to Print Gridlines in Excel?

Make a nice report in Excel. Then print it. You’ll be disappointed. Because the gridlines that are visible in Excel, that make the rows and columns visible, don’t get printed by default when you print any Microsoft Excel file.

It is much easier to type in Excel when you can see the grid lines to demark rows & columns.  However if you print your beautiful Excel file, it may not seem so easy to read, because the lines that separate the rows and columns are not printed by default.

You may miss the row/column alignment and misread the wrong data with the wrong row… specially when there’s a lot of data on a page, and the fonts are a bit small.

That’s when printed gridlines in Excel reports come in handy.

Gridlines in Pagesetup
Gridlines in Page setup
Page setup
Page setup

Now there has always been a way to get the grid lines to print, since Excel 2000, and it is still available in Microsoft Excel 2016, 2019 or Office 365, in the same place. In  Excel , you have many ways to get to the Print Grid lines option.

Go to Print > Print Preview & Click on Page Setup. The option to print gridlines in Excel is hidden here.

You will see a popup box come up. Click on the 4th tab and select Sheet. You should see something like this screen shot below.

Page Setup Dialogue Box
Gridlines in Print Preview

As you can see, there is a checkbox which says – Gridlines in the Print section. Select the Checkbox, and then click OK.

You will see tiny gridlines appear on the screen. Now when you print the sheet, you will see gridlines being printed, and it is much easier to view the figures on the printed sheet with gridlines printed.

Hope you find this tiny tip useful…

If you want to learn more, you can join us for our Basic-Intermediate Excel Training course, or for the Advanced Excel Training in Singapore. We offer classroom and online trainings for your benefit.

Cheers,
Vinai Prakash

Founder, Intellisoft Systems

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!