Microsoft Excel can be incredibly powerful in the right hands, however, often it is more than a little daunting. Knowledge of Microsoft Excel is often crucially required for gaining employment and most roles require a working knowledge. The purpose of this course is to bring you on a journey from basic level Excel use all the way through the most advanced charts, graphs, look ups and much more. The beauty here is the way the content is presented, in bite size chunks, which can be looked up at ease, almost like a video dictionary for Excel. Interactive downloadable workbooks ensure all points are grasped in real time so register now to start learning.
What is Excel? You will learn how to open and close Excel and a basic overview of Spreadsheet software. Topics covered in this lesson include: • Introducing Microsoft Excel • Starting Microsoft Excel • Understanding spreadsheets • Understanding the Excel window • Understanding the workbook window • Using the Ribbon • Using the Quick Access Toolbar • Getting help on Microsoft Excel • Exiting Microsoft Excel • Exercise / Solutions • Summary
What are Workbooks and Worksheets? How they work and what they assist with. Topics covered in this lesson include: • Creating and Saving Workbooks • Creating a new workbook • Saving a workbook • Auto-saving your work • Closing a workbook • Opening a workbook • Moving the cell pointer • Moving around a worksheet • Entering text 5 Entering numbers • Entering dates and times • Using the Zoom tool • Exercise / Solutions • Summary
How to alter Workbooks and make changes to the data held within them. Topics covered in this lesson include: • Editing Workbooks • Selecting ranges of cells • Editing cell contents • Clearing cell contents • Copying cell contents • Moving cell contents • Inserting and deleting cells • Inserting columns and rows • Deleting columns and rows • Copying cells with AutoFill • Inserting cell comments • Checking your spelling • Finding and replacing data • Exercise / Solutions • Summary
I've just completed Financial Trading and I have to say it was an excellent course!
I love the detail, the explanations and the wonderful teacher/instructor.
I love this leadership and management course. My first time doing an online one.
Amazing courses! Great people! Love the learning environment!
Really enjoyed it and loving the support