![]() ![]() The key points is that if you add data to the end of ordinary Excel lists, your Lookup Functions, your Named Ranges or your Pivot Tables will not automatically pick them up. How to create and use them and how they differ from ordinary lists and Named ranges. L ike the above modules this is another essential module you need to master in our online Excel Course, especially if your work in Excel involves analyzing large chunks of data. What is an Named range and how to create them? We will show how to create proper lists or databases in Excel. There is no point going any further in the course until you have mastered these three concepts. This module explains the concepts of ‘Relative Reference’, ‘Absolute Reference’ and using ‘Cell references”. I am always amazed that so many Excel courses online only give a few minutes to these concepts. Probably one of the most important module in our online Excel course. We will master all of these in this module of our online Excel training course Because without this, you cannot use Excel’s powerful data analysis tools like Filters, Advanced Filters and the SubTotal Tool. This module of our online Excel training course starts of by stressing the importance of setting up your lists or tables property. ![]() So much of your work in Excel will be spent dealing with lists or tables of information,whether it be a list of orders, suppliers,employees etc. This module in our online Excel training Course shows you I ts vital,especially if others will be using your spreadsheets that they are protected fully to insure integrity of your data. Also how to rename, move or copy your worksheets.Įverything you need to know about printing your worksheets and workbooks. T his module in our online Excel course will teach you how to freeze rows and columns, split your screen, size and hide your rows and columns. This module shows various methods to access data from different worksheets & workbooks. Covers the SUM,AVERAGE,MIN, MAX and COUNT Functions.Īn extremely important Excel skill to learn in our Excel courses online, as in real life workplace situations, data is kept in different worksheets and workbooks. This online Excel training course explains what Functions are and how to use them to their full potential. This module in our online Excel training course finishes by providing a simple but powerful Two step method to create even complex formulas. Viewing it from this point of view makes Formulas and Functions must easier to understand. This module’s of our online Excel training course emphasis is that Formulas ,like Functions simply automate a ‘Human Process’. Shows the difference between a Formula and a Function. Also shows you how to delete formats correctly and how Excel views Formatting. All types of Formatting,especially number and currency formatting will be covered in this online Excel course. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |