Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Complete Microsoft Excel Course – Beginner to Advanced course will set you up with a solid foundation to become a confident office admin and develop more advanced skills.
This comprehensive course is the perfect way to kickstart your career in the field of Microsoft Excel. This accredited course will give you a competitive advantage in your career, making you stand out from all other applicants and employees.
As one of the leading course providers and most renowned e-learning specialists online, we’re dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience.
How Will I Benefit?
- Boost your career in Microsoft Excel
- Deepen your knowledge and skills in your chosen field just in hours not years!
- Study a course that has been designed by industry professionals.
- Save money and time by studying your convenient time
- Have access to a tutor whenever you are in need
So, what are you thinking about! Start getting the benefits by enrolling today!
Why Choose Lead Academy:
- Lifetime Access
- High-quality e-learning study materials
- The UK and globally recognised qualification
- Self-paced, no fixed schedules
- 24/7 customer support through email
- Available to students anywhere in the world
- No hidden fee
- Study in a user-friendly, advanced online learning platform
Who is this course for?
This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Excel.
- There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.
- As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol.
On successful completion of the course, you will be eligible to obtain a verifiable certification as proof of your new qualification. This means that you/your employer can verify your qualification through our website. Certificate can be obtained in PDF version at a cost of £10, and there is an additional fee to obtain a printed copy certificate which is £24.
This course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your qualifications to your CV, enhance your career and become more competitive in your chosen industry.
|MS Excel 2019 New Features|
|Introduction to MS Excel 2019 New Features||00:06:00|
|Concat with Excel 2019||00:01:00|
|IFS with Excel 2019||00:01:00|
|Maxifs with Excel 2019||00:01:00|
|Minifs with Excel 2019||00:01:00|
|Switch with Excel 2019||00:02:00|
|Textjoin with Excel 2019||00:01:00|
|Map Chart with Excel 2019||00:01:00|
|Funnel Chart with Excel 2019||00:01:00|
|Better Visuals with Excel 2019||00:06:00|
|Pivot Table Enhancements with Excel 2019||00:01:00|
|Power Pivot Updates with Excel 2019||00:01:00|
|Microsoft Excel Beginners|
|Introducing with Microsoft Office Excel 2016|
|Navigate the Excel User Interface||00:28:00|
|Use Excel Commands||00:10:00|
|Create and Save a Basic Workbook||00:19:00|
|Enter Cell Data||00:12:00|
|Use Excel Help||00:05:00|
|Create Worksheet Formulas||00:15:00|
|Reuse Formulas and Functions||00:17:00|
|How To Modify a Worksheet|
|Insert, Delete, and Adjust Cells, Columns, and Rows||00:10:00|
|Search for and Replace Data||00:09:00|
|Use Proofing and Research Tools||00:07:00|
|How To Format a Worksheet|
|Apply Text Formats||00:17:00|
|Apply Number Format||00:08:00|
|Align Cell Contents||00:09:00|
|Apply Styles and Themes||00:12:00|
|Apply Basic Conditional Formatting||00:11:00|
|Create and Use Templates||00:07:00|
|Preview and Print a Workbook||00:10:00|
|Set Up the Page Layout||00:08:00|
|Configure Headers and Footers||00:07:00|
|How To Manage Workbooks|
|Manage Workbook and Worksheet Views||00:07:00|
|Manage Workbook Properties||00:05:00|
|Supplementary Resources - Microsoft Excel 2016 for Beginners|
|Supplementary Resources – Microsoft Excel 2016 for Beginners||00:00:00|
|Microsoft Excel Intermediate|
|How To Work with Functions|
|Work with Ranges||00:18:00|
|Use Specialized Functions||00:11:00|
|Work with Logical Functions||00:23:00|
|Work with Date & Time Functions||00:08:00|
|Work with Text Functions||00:11:00|
|How To Work with Lists|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09:00|
|How To Analyse Data|
|Create and Modify Tables||00:15:00|
|Apply Intermediate Conditional Formatting||00:07:00|
|Apply Advanced Conditional Formatting||00:05:00|
|How To Visualise Data with Charts|
|Modify and Format Charts||00:12:00|
|Use Advanced Chart Features||00:12:00|
|How To Use PivotTables and PivotCharts|
|Create a PivotTable||00:13:00|
|Analyze PivotTable Data||00:12:00|
|Present Data with PivotCharts||00:07:00|
|Filter Data by Using Timelines and Slicers||00:11:00|
|Supplementary Resources - Microsoft Excel 2016 Intermediate|
|Supplementary Resources – Microsoft Excel 2016 Intermediate||00:00:00|
|Microsoft Excel Advanced|
|How To Work with Multiple Worksheets and Workbooks|
|Use Links and External References||00:12:00|
|Use 3-D References||00:06:00|
|How To Use Lookup Functions and Formula Auditing|
|Use Lookup Functions||00:12:00|
|Watch and Evaluate Formulas||00:08:00|
|How To Share and Protect Workbooks|
|Collaborate on a Workbook||00:19:00|
|Protect Worksheets and Workbooks||00:08:00|
|How To Automate Workbook Functionality|
|Apply Data Validation||00:13:00|
|Search for Invalid Data and Formulas with Errors||00:04:00|
|Work with Macros||00:18:00|
|How To Create Sparklines and Mapping Data|
|Determine Potential Outcomes Using Data Tables||00:08:00|
|Determine Potential Outcomes Using Scenarios||00:09:00|
|Use the Goal Seek Feature||00:04:00|
|Forecasting Data Trends||00:05:00|
|Supplementary Resources - Microsoft Excel 2016 Advanced|
|Supplementary Resources – Microsoft Excel 2016 Advanced||00:00:00|
|Order Your Certificate Now|
|Order Your Certificate Now||00:00:00|
No Reviews found for this course.