-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Microsoft Excel Complete Course 2019
Microsoft Excel Complete Course 2019
£29 ex Vat
Take This Course OR
1 Year Access 
Advanced
56 Students -
1 day
Overview
Learn everything about Microsoft Excel from this one course which caters to Beginners, Intermediate and Advanced levels.
You will gain tremendous knowledge and skills on one of the world’s most widely used data visualising and analysing tool- Microsoft Exel. After this course, you will be able to create, analyse and visualise spreadsheets like a pro.
In the course, you will learn about the new features that Microsoft Excel 2019 brings. You will learn how to perform calculations, modify and format worksheets, how to print and manage workbooks, how to visualise and analyse data, how to work with multiple worksheets and workbooks, and so much more. This is a complete package that teaches you everything about MS Excel, from beginner level to advanced level.
Knowing how to work on MS Excel is an absolute necessity nowadays, almost every business in the world uses MS Excel and you will fall behind the competition if you do not know how to use MS Excel.
Enrol in this course today and become an expert in MS Excel, increase your job perspectives and earning potential.
Highlights of the Microsoft Excel Complete Course 2019:
- Learn About The New Features Of Microsoft Excel 2019
- Learn How To Get Started With Ms Excel
- Learn How To Perform Calculations In Ms Excel
- Learn How To Modify Worksheets
- Learn How To Format Worksheets
- Learn How To Print Workbooks
- Learn How To Manage Workbooks
- Learn How To Work With Functions
- Learn How To Work With Lists
- Learn How To Analyse Data
- Learn How To Visualise Data With Charts
- Learn How To Use Pivot Tables And Pivot Charts
- Learn How To Work With Multiple Worksheets And Workbooks
- Know About Using Lookup Functions And Formula Auditing
- Learn How To Share And Protect Workbooks
- Learn About Automating Workbook Functionality
- Learn How To Create Sparklines And Mapping Data
- Learn About Forecasting Data
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
- Assessments
Who is this Microsoft Excel Complete Course 2019 for?
This Microsoft Excel Complete Course 2019 is suitable for anyone interested in learning how to work in MS Excel. If you’re an individual looking to gain professional skills in this field then this Microsoft Excel Complete Course 2019 is for you.
This is a very comprehensive course and it is great for learners of all levels. It will give you skills that are a must in today’s world. So this course is just perfect for everyone.
Will I receive a certificate of 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.
Why Choose this Microsoft Excel Complete Course 2019:
- 24/7 access to the course for an extensive period of 12 months
- CPD accredited certification on successful completion
- Ease of access to the course material from any device of your choice
- No hidden fees or exam charges
- Full tutor support on weekdays (Monday – Friday)
- Efficient exam system, assessment and instant results
- Develop professional skills and advance your career, thus increasing your potential to earn more
Requirements
The Microsoft Excel Complete Course 2019 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.
Career path
Knowing MS Excel is a necessity. Having a working knowledge of MS Excel will come in handy in every profession.
Studying this Microsoft Excel Complete Course 2019 would benefit a range of careers, but would specifically boost employability in roles including:
- Accounts officer (average annual salary is £26,991 in the UK)
- Financial Analyst (average annual salary is £40,885 in the UK)
- Administrative Assistant (average salary is £20,108 in the UK)
- Retail Store Manager (average annual salary is £24,338 in the UK)
- Project Manager (average annual salary is £45,000 in the UK)
- Business Analyst (average annual salary is £42,618 in the UK)
- Data Journalist (average annual salary is £12 per hour in the UK)
Course Curriculum
| Microsoft Excel Complete Course 2019 | |||
| Microsoft Excel 2019 New Features | |||
| Introduction to Microsoft Excel 2019 New Features | 00:07:00 | ||
| CONCAT | 00:02:00 | ||
| IFS | 00:01:00 | ||
| MAXIFS | 00:01:00 | ||
| MINIFS | 00:01:00 | ||
| SWITCH | 00:02:00 | ||
| TEXTJOIN | 00:01:00 | ||
| Map Chart | 00:02:00 | ||
| Funnel Chart | 00:01:00 | ||
| Better Visuals | 00:06:00 | ||
| Pivot Table Enhancements | 00:02:00 | ||
| Power Pivot Updates | 00:01:00 | ||
| Getting Started with Microsoft Office Excel | |||
| 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 | |||
| 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 | ||
| Excel VBA Data Management | |||
| Create a Macro Using the Macro Recorder | 01:00:00 | ||
| Edit a Macro | 01:00:00 | ||
| Debug a Macro | 00:30:00 | ||
| Customize the Quick Access Toolbar and Hotkeys | 00:30:00 | ||
| Set Macro Security | 01:00:00 | ||
| Insert Text | 00:30:00 | ||
| Format Text | 00:30:00 | ||
| Sort Data | 00:30:00 | ||
| Duplicate Data | 01:00:00 | ||
| Generate a Report | 01:00:00 | ||
| Determine the Dialog Box Type | 00:15:00 | ||
| Capture User Input | 01:00:00 | ||
| Insert, Copy, and Delete Worksheets | 00:30:00 | ||
| Rename Worksheets | 00:30:00 | ||
| Modify the Order of Worksheets | 00:15:00 | ||
| Print Worksheets | 00:30:00 | ||
| Create User-Defined Functions | 00:30:00 | ||
| Automate SUM Functions | 00:30:00 | ||
| Activities and Exercise Files – Microsoft Excel 2016 and VBA | 00:00:00 | ||
| Excel Templates | |||
| Excel Templates | 00:00:00 | ||
| Resources | |||
| Resources – Microsoft Excel Complete Course 2019 | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam – Microsoft Excel Complete Course 2019 | 00:20:00 | ||
| Final Exam | |||
| Final Exam – Microsoft Excel Complete Course 2019 | 00:20:00 | ||
| Assignment | |||
| Assignment – Microsoft Excel Complete Course 2019 | 01:20:00 | ||
Related Courses
Important Links
- Affiliate
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add