0
0
1
Students
GET THIS COURSE AND 1500+ OTHERS FOR ONLY £149. FIND OUT MORE
Course Overview
Gear up to get well equipped in Excel for Bookkeeping now, and make up your mind to be the best in the business! All you need is proper training, firm support and a push to shine in your vocation, and Compliance Central is determined to provide you with it all! Explore what you got in this exclusive Excel for Bookkeeping Skills, start learning and excel in it! This amazing Excel for Bookkeeping course has been designed and developed by the industry specialists.! You’ll get to-the-point knowledge both practical and theoretical, and gain valuable insights into the business which will help you understand the drill better than ever! Join today, be skilled, learn with positive energy and enthusiasm, and create an excellent career using your full potential! Brace yourself, enrol now for an amazing venture!This Excel for Bookkeeping Course Package Includes
- Free CPD Accredited PDF Certificate
- Comprehensive lessons and training provided by experts on Excel for Bookkeeping
- Interactive online learning experience at your convenience
- 24/7 Access to the course materials and learner assistance
- Easy accessibility from any smart device (Laptop, Tablet, Smartphone etc.)
- A happy and handy learning experience for the professionals and students
- 100% learning satisfaction, guaranteed by Compliance Central — a leading compliance training provider
Certification
You can instantly download your certificate for £4.79 right after finishing the Excel for Bookkeeping course. The hard copy of the certification will also be sent right at your doorstep via post for £10.79. All of our courses are continually reviewed to ensure their quality, and that provide appropriate current training for your chosen subject. As such, although certificates do not expire, it is recommended that they are reviewed or renewed on an annual basis.Who Is This Course For
Compliance Central aims to prepare efficient human resources for the industry and make it more productive than ever. This helpful course is suitable for any person who is interested in Excel for Bookkeeping. There are no pre-requirements to take it. You can attend the course if you are a student, an enthusiast or a- Employee
- Employer
- Manager
- Supervisor
- Entrepreneur
- Business Professional
- Company Leader
- HR Professional
Course Currilcum
-
- 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
-
- 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
- Insert Functions 00:17:00
- Reuse Formulas and Functions 00:17:00
- 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
- Manage Worksheets 00:05:00
- Manage Workbook and Worksheet Views 00:07:00
- Manage Workbook Properties 00:06:00
- 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
- Create Charts 00:13:00
- Modify and Format Charts 00:12:00
- Use Advanced Chart Features 00:12:00
- Use Links and External References 00:12:00
- Use 3-D References 00:06:00
- Consolidate Data 00:05:00
- Collaborate on a Workbook 00:19:00
- Protect Worksheets and Workbooks 00:08:00
- Create Sparklines 00:07:00
- MapData 00:07:00
Student Reviews
Ben lim
Gaining improve knowledge in the construction project management and the course is easy to understand.
Mr Brian Joseph Keenan
Very good and informative and quick with marking my assignments and issuing my certificate.
Sarah D
Being a support worker I needed add a child care cert in my portfolio. I have done the course and that was really a good course.
Sam Ryder
The first aid course was very informative with well organised curriculum. I already have some bit and pieces knowledge of first aid, this course helped me a lot.
Ben lim
Gaining improve knowledge in the construction project management and the course is easy to understand.
Thelma Gittens
Highly recommended. The module is easy to understand and definitely the best value for money. Many thanks
BF Carey
First course with Compliance Central. It was a good experience.
Course Currilcum
-
- 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
-
- 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
- Insert Functions 00:17:00
- Reuse Formulas and Functions 00:17:00
- 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
- Manage Worksheets 00:05:00
- Manage Workbook and Worksheet Views 00:07:00
- Manage Workbook Properties 00:06:00
- 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
- Create Charts 00:13:00
- Modify and Format Charts 00:12:00
- Use Advanced Chart Features 00:12:00
- Use Links and External References 00:12:00
- Use 3-D References 00:06:00
- Consolidate Data 00:05:00
- Collaborate on a Workbook 00:19:00
- Protect Worksheets and Workbooks 00:08:00
- Create Sparklines 00:07:00
- MapData 00:07:00