Categories
Excel Training

What can I use Excel for?

This may seem a back-to-basics question, but it a useful one, at any stage of Excel.  This is something I’ve learned from attending our courses – it is always good to ask “What else can I do with Excel?”, “Can I automate that function?”, and “Can Excel do that?”

Excel is a spreadsheet and a versatile one at that.  It is fantastic for number-crunching and great for managing text data.  Excel functions such as sorting, filtering, charts and formulas allow you to analyse text and numerical data.  You can save time by automating functions such as calculations or conditional formatting, such as highlighting overdue invoices.

What can you use Excel for?  Well, everything from lists to charting progress and financial modelling.  Take a look at the list below and see if you are using Excel to the max.

Organising information with Excel
I know I can use Word to create a list but with Excel I have more scope to organise lists, categorise information, sort and filter lists, and set deadlines for items.  I use Excel for lists for work, home and even for study.

Excel for time management of work. I have an Excel sheet with the daily core tasks and project-based work.  This allows me to allocate time for each item, over the day, week, month and year.  I have the flexibility to manage tasks based on their priority, change time allocated and immediately see the impact of changing or adding tasks.  The lists includes text plus working with dates and currency (for costing up projects).

Excel for learning vocabulary in another language.  I use Excel to learn my French vocabulary.  I can colour code words by gender (using conditional formatting), add categories so I can filter lists by topic area.  I can even test myself by hiding words, typing in the word and Excel has a formula to say “correct” or “incorrect”.

Excel for Charts
Charts are useful for work and home.  Excel has ready-made tools so that I can create charts within a few clicks.  This is great for visual presentations of sales data, changes in customer demand, and income and expenditure figures by month or quarter.

Charts for monitoring sales performance.  Simple to set up, Excel can automatically update your chart to identify trends, highlight categories.  You can even embed these in your Powerpoint presentations – when you update your Excel sheet, the Powerpoint presentation is automatically up to date.

Charts for tracking weight and fitness measures.  You can customise an Excel worksheet so you can manage your health and fitness.  When you update your data, such as weight, time trials for stamina, or number of repetitions with weights, Excel charts can instantly show you the trends.  This can help you to tailor your training, by identifying potential over-training, spot trends in reduced performance and revise goals accordingly.

Number crunching
From Inland Revenue tax returns, to working out project costs, income and expenditure patterns, and client records, number-crunching is Excel’s strong point.  Never one for mental arithmetic, I can set up formulas in Excel so it automatically updates when I add new figures.  With formulas ready-made for me to customise, I can analyse data more quickly…so my focus is on outcomes, not on data entry.  Number-crunching is more accurate with Excel, with error and formula checking available with a click.  With Excel VBA you can set up and develop functions, debug codes and control program execution.  Number crunching covers everything from introductory level to advanced VBA.

Creating dashboards in Excel 
I have Excel workbooks with many worksheets and creating a dashboard in Excel allows me to have a summary of all the key data in one sheet in a clear format.  I can set it up to automatically update with figures from other worksheets, or even other workbooks.  Fantastic for sharing data with colleagues, dashboards provide an immediate overview so that discussions are based on accurate and current data.

Excel for creating diagrams and adding graphics  
Maybe this isn’t the most common use of Excel but diagrams and graphics in Excel can give your work the wow factor.  It is a great way to tailor information to suit your audience, for example, those who need more visual representations of numbers through diagrams or charts.  If your audience includes everyone from HR to Finance, your Excel worksheet can include graphics to show project staffing to assessing the return on investment. I can even add a screenshot if I want…Excel really is that versatile.

Graphic items can add a professional edge to your workbook and enhance the content in your worksheets.  SmartArt graphics such as organisational charts or process diagrams can complete an Excel project proposal, with the financial data linked to the project processes shown in a diagram next to the figures.  Remember, graphics can include your organisation’s branding – a quick way to customise your documents.

Save time by automating complicated tasks in Excel 
Possibly my favourite thing about Excel.  Once I have figured out that I can automate a task, Excel can do the leg work for me.  Automating tasks can include using macros, using formulas, or conditional formats.  For example, I can update my time sheet  and Excel will automatically update the figures for my invoice, or project monitoring worksheet.  With 3D formulas, I can link calculations across my workbook or even other Excel worksheets – cutting out the need to update several documents with the same data.

It doesn’t matter if you are new to Excel or an experienced user, you can always get more out of the program by asking questions, experimenting with formulas and developing more complex skills using VBA Excel or PowerPivot.  Take a peek at what you can learn at https://www.stl-training.co.uk/excel-vba-2010-training-course.php.

 

 

 

 

Categories
Excel Training

Excel 2007 training – workbook protection

If you ever need to send an Excel workbook by email to someone else, you may want to hide certain worksheets. When they receive the file, you want to ensure they cannot unhide any hidden worksheets. After attending an excel training course you may only learn the skills of how to protect a worksheet with a password.

The first step towards protecting the workbook is to hide the required sheets so they are not in view. After that go to the Review Tab on the ribbon:

 

 

 

 

Click on Protect Workbook and then type a password in:

 

 

 

 

 

Once you have entered and confirmed the password click ok. If you right click over one of the Worksheet tabs, the Hide and Unhide options will be greyed out. The password would then be needed to obtain access to the hidden sheets.