Microsoft Excel for Beginners - CPD Certified & IAO Accredited

Excel is the best spreadsheet software. You will learn to analyze numbers, keep track of data, and graphically represent your information. Excel also makes your job easier by providing an easy to use interface and an array of powerful tools to help you turn your data into useable information as better information leads to better decision making!

COURSE CURRICULUM

Module One: Getting Started

• Workshop Objectives

Module Two: Opening Excel

• Opening Excel
• Using the Recent List
• Opening Files
• Creating a Blank Workbook
• Creating a Workbook from a Template

Module Three: Working with the Interface

• Understanding the Interface
• About Your Account and Feedback
• Using Backstage View
• Understanding Worksheets
• Saving Files
• Closing Files vs. Closing Excel

Module Four: Your First Worksheet

• Entering Data
• Using Auto Fill
• Editing Data
• Checking Your Spelling
• Adding Rows and Columns
• Using Flash Fill

Module Five: Viewing Excel Data

• An Overview of Excel’s Views
• Switching Views
• Using Zoom
• Creating Custom Views
• Switching Between Open Files

Module Six: Building Formulas

• The Math Basics of Excel
• Building a Formula
• Editing a Formula
• Copying a Formula
• Relative vs. Absolute References
• Using the Status Bar to Perform Calculations

Module Seven: Using Excel Functions

• Formulas vs. Functions
• Using the SUM Function
• Using AutoComplete
• Using Other Basic Excel Functions
• Understanding the Formulas Tab
• Understanding Function Compatibility

Module Eight: Using Quick Analysis

• Formatting Data
• Creating Quick Analysis Charts
• Calculating Totals
• Creating Quick Analysis Tables
• Sorting and Filtering Your Data
• Using Sparklines

Module Nine: Formatting Your Data

• Changing the Appearance of Text
• Changing the Appearance of Numbers
• Adding Borders and Fill Color
• Removing Formatting
• Working with Alignment Options

Module Ten: Using Styles, Themes, and Effects

• Using Table Styles and Cell Styles
• Using Conditional Formatting
• Changing the Theme, Colors, and Fonts
• Module Ten: Review Questions

Module Eleven: Printing and Sharing Your Workbook

• An Overview of the Page Layout Tab
• Setting up Your Page
• Previewing and Printing Your Workbook
• Inviting People
• E-Mailing Your Workbook

Module Twelve: Wrapping Up

• Words from the Wise

John Academy: A Great Place to Learn for Everyone, Forever

Expert Authors: We select authors with expertise and experience of training professionals. Our authors are industry experts, academics, authors, face-to-face trainers or online trainers; most often they have a combination of these backgrounds

Engaging Content: Our succinct, bite-sized and business-focussed course materials are designed to deliver the most effective training for you. Each course is made up of modules, manageable learning chunks of text, images, videos and tasks.

Why choose us?

• Study in a user-friendly, advanced online learning platform;
• All the study materials are available in your student portal including videos tutorials.
• One of the most successful online education platforms in the UK.
• Affordable, engaging & high-quality e-learning study materials;
• You will have unlimited access to online learning platform in 24 hours a day, 7 days a week in 12 Months.
• Efficient exam systems for the assessment and instant result;
• The UK & internationally recognised accredited qualification;
• Access to course content on mobile, tablet or desktop from anywhere anytime;
• The benefit of applying for NUS Extra Discount Card;
• 24/7 student support.
• Technical supports and live chat service for your inquiries. This is very helpful for international learners.
• Excellent and flexible mentor supports by our team of experienced tutors/trainers via email.

Assessment:

• At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.
• Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

• In addition to the course price there is an additional charge for certificate. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at the following price:
• Hard Copy by post - £39.00
• Soft Copy PDF via email - £24.00

• Professionals who want to learn about Microsoft Office 365 Excel Web App features.
• People who have an interest in knowing all the essentials in Office 365 Excel Web App.

• This course is available to all learners, of all academic backgrounds.
• Learners should be aged 16 or over to undertake the qualification.
• Good understanding of English language, numeracy and ICT are required to attend this course.

The Microsoft Excel for Beginners course is a useful qualification to possess and would be beneficial for any Office job, such as:

• Admin Assistant
• PA
• Secretary
• Administrator
• Account Assistant
• Bookkeeper
• Accountant
• Office Manager

Currently there are no Q&As for this course. Be the first to ask a question.