Mastering MS Excel

About this course

The Mastering MS Excel is aimed at MS Excel 2010 to 2016. The course videos are based on MS Excel 2016, used on a Windows computer. No prior knowledge of MS Excel is required. The course will take you from the beginner level to the advanced level. The course focuses on those aspects that are important in everyday working life and helps you get the most out of MS Excel. Intermediate users will also benefit from this course as it covers the in-depth topics of Complex Charts, PivotTables, PivotCharts and Interactive Dashboards. The course is aimed at job seekers trying to gain MS Excel Skills for todays job market. It will also help existing workers, who use MS Excel, to fascinate and astound their colleagues and managers with their newly gained skills. Course Breakdown: Chapter 1        covers important definitions of the terms : spreadsheet, workbook, worksheet and cell. It also covers how to start MS Excel, and the layout of the window, including the ribbon menu. Chapter 2        is editing and looks at font sizes, types, colors, text alignment, text wrap, merging cells, borders and shading. Chapter 3        looks at formatting cells as decimals, currency, percent and date&time. Chapter 4        opens up new opportunities for you to dazzle people. We discuss conditional formatting. Chapter 5        looks at how you can move easily and quickly around a worksheet containing data. You will be impressed. Chapter 6        covers copying, cutting, pasting and moving data Chapter 7        is the longest chapter and looks at the