This one-day, hands-on Microsoft Excel Complete Course is fully Accredited by CPD and supports you build a strong foundation in Excel for careers in diverse sectors.
In this Microsoft Excel Complete Course, gain a comprehensive, practical understanding of Excel including tips, tricks, shortcuts, functions and formulas you need to be a power user. You will learn to create spreadsheets and workbooks using Microsoft Office Excel for storing, manipulating and sharing data.
This Microsoft Excel Complete Course is suitable for anyone, from beginners to advanced users, who are already performing professional financial analysis and financial modelling and wanting to learn 2016, 2013, 2010 or 2007, as it comprises all the aspects and differences between the versions.
Get succeed in the workplace through a focus on Microsoft Excel and prep for a wall street career.
Highlights of the Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course:
Enrol in a Microsoft Excel Complete Course online course absolutely FREE! So, what are you thinking about!! Start learning today.
Please note: Once you get the online access you have to secure your classroom spot by paying a fee of £159.
In order to earn an accredited certificate, you will attend practical training and get full access to our online student portal, where you will discover a treasure of high-quality learning resources including engaging lessons, tutorial videos and comprehensive manuals.
Benefits of studying Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course:
Course Objectives:
By the time you complete this Microsoft Excel Complete Course, you will be able to:
What’s included?
This Microsoft Excel Complete Course is suitable for learners seeking to gain the necessary skills and knowledge to create, edit, format, and print basic Microsoft Office Excel worksheets.
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course Private is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
In order to take this Microsoft Excel Complete Course, you should have sound knowledge of using personal computers, including the mouse and keyboard. You should be familiar with the Windows environment and be able to use Windows to manage information on the computer.
Notably, you should be able to start and close programs; navigate to information stored on the computer; handle files and folders; use the internet.
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Being an expert in Excel can unlock the door to many career opportunities such as:
Book Your Place | |||
Book Your Place – Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course | 00:00:00 | ||
Getting Started 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 | ||
Performing Calculations | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Modifying 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 | ||
Formatting a Worksheet | |||
Apply Text Formats | 00:16: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:08:00 | ||
Printing Workbooks | |||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:09:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Managing Workbooks | |||
Manage Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:06:00 | ||
Working 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 | ||
Working with Lists | |||
Sort Data | 00:10:00 | ||
Filter Data | 00:10:00 | ||
Query Data with Database Functions | 00:09:00 | ||
Outline and Subtotal Data | 00:09:00 | ||
Analyzing Data | |||
Welcome to the Course | FREE | 00:03:00 | |
Apply Intermediate Conditional Formatting | 00:07:00 | ||
Apply Advanced Conditional Formatting | 00:05:00 | ||
Visualizing Data with Charts | |||
Create Charts | 00:13:00 | ||
Modify and Format Charts | 00:12:00 | ||
Use Advanced Chart Features | 00:12:00 | ||
Using 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 | ||
Working with Multiple Worksheets and Workbooks | |||
Use Links and External References | 00:12:00 | ||
Use 3-D References | 00:06:00 | ||
Consolidate Data | 00:05:00 | ||
Using Lookup Functions and Formula Auditing | |||
Use Lookup Functions | 00:12:00 | ||
Trace Cells | 00:09:00 | ||
Watch and Evaluate Formulas | 00:08:00 | ||
Sharing and Protecting Workbooks | |||
Collaborate on a Workbook | 00:19:00 | ||
Protect Worksheets and Workbooks | 00:08:00 | ||
Automating 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 | ||
Creating Sparklines and Mapping Data | |||
Create Sparklines | 00:07:00 | ||
MapData | 00:07:00 | ||
Forecasting 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 | ||
Mock Exam | |||
Mock Exam – Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course | 00:20:00 | ||
Final Exam | |||
Final Exam – Microsoft Excel Complete Course – Beginner to Advanced – Classroom Training Course | 00:20:00 |
Membership renews after 12 months. You can cancel anytime from your account.