![]() ![]() ![]() Also, running, recording, and basic editing of macros is included. In addition, importing and exporting data will be covered. Working with nested functions, naming cells and absolute referencing will be taught too. This course covers many of Excel’s built in functions. Performing–and re-performing– calculations is one of the main reasons to use Excel. Formatting Excel tables and pivot tables are also explored. In addition, this course covers many of Excel’s database management tools, such as, data validation, sorting, filtering, and automatic subtotals. This course covers creating charts in Excel. No prior Excel knowledge is necessaryĭepicting numerical information visually is often helpful in making your point. Formatting the worksheet and preparing to print will be covered too. It starts from opening the application and progresses through creating a worksheet with some basic formulas. This session covers the basics of working with Excel. The course covers some of the more advanced Functions, a range of Data Analysis techniques including Advanced Filter, Database Functions and Pivot Tables, and Workbook management facilities such as multiple linked workbooks, Auditing, Shared Workbooks, Protection and Templates.Details & Benefits of Microsoft Excel Training Microsoft Excel: Basics This course is aimed at delegates who are familiar with the essentials of Microsoft Excel covered in the Level 1 and Level 2 courses and wish to extend their knowledge to make the most of the facilities available in the software. On completion of the course, the delegate will be familiar with most of the main features of Excel, including several features for Data Analysis. This course introduces some of the more advanced features of Excel, to enable the delegate to make the most effective use of the software, including the use of linked Workbooks. It also introduces some useful features such as Range Names that form a basis for some of the more advanced features covered in the Level 3 course. The course covers the main features of Excel that are used by most people on day to day basis, including text functions, simple logical functions, creating Charts, Sorting and Filtering Lists, inserting diagrams and comments, and Importing and Exporting data. This course is suitable for delegates who are familiar with using Excel spreadsheets, including entering simple formulas and functions, copying and pasting, using AutoFill, and formatting and printing spreadsheets. This course provides a foundation for the Excel Level 3 course that introduces some of the more advanced features of the product. This course builds on the Excel Level 1 course on completion of the course, the delegate will be familiar with the main features of Excel that are generally used on a day to day basis. The course covers the essential techniques for creating a spreadsheet, entering and editing data and formulas, formatting a spreadsheet and printing spreadsheets. No previous knowledge is assumed, but familiarity with one or more other Windows applications would be an advantage. This course is suitable for delegates who wish to learn to use spreadsheetsĮffectively. ![]() The material covered in this course provides a foundation for the Excel Level 2 course. On completion of this course, the delegate will be able to create and use spreadsheets effectively for straightforward calculation and simple data manipulation. This course provides an introduction to the basic concepts of Microsoft Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |