Coursepig.com

Master Excel From Novice to Expert!

From Beginner to Highly Advanced. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Microsoft Office 365

I have designed this course to take you from a complete beginner to a highly advanced user. You will learn:

What you’ll learn

Course Content

Requirements

I have designed this course to take you from a complete beginner to a highly advanced user. You will learn:

. Adjusting Excel Worksheets

. Protection in Excel

. Formatting to make cells look good

. Inserting Shapes and Images

. Using Charts

. Shapes and Images

. Printing

. Excel Templates

. Sorting Data

. Data Validation

. Database Functions

. Pivot Tables

. Excel’s Conditional Functions

. Lookup Functions

. WhatIf Tools

. Text Based Functions

. Audit Formulas

Course Phisolophy:

I have created short videos for every topic in Excel to make it convenient for you to learn Excel even on a very tight and busy schedule. To take full advantage of this course, please watch a video and practice it to see if you understood the contents of the video and have a schedule to practice the things you learned in this course because practising is the most important part of this course. Learning excel relies more on practice rather than memorisation. Try to use the things you learn in this course in your Excel projects more and more to understand them in a deeper sense.  I have also included a Excel Practice file in the section 11 of this course with already made formats ready to be used to practice the things you learn in this course.