Excel refers to a spreadsheet programme which is available in the Microsoft Office package. The main features available in Excel are graphing tools, calculation and pivot tables. Excel has become the most widely used programme by organisations. Excel spreadsheets are mainly used by organisations to record expenses and income, organise lists, plan budgets, create multi-layered and interactive reports and many more. Excel can benefit individuals as well in planning and organising their groceries, recording their income and expenditure and to calculate ROI value.
In the modern world, it has become an essential requirement to be acquainted with Excel in order to qualify for many job positions in the administrative and financial department. Therefore, if you are planning on embarking on a successful career in administrative or finance field, or if you are an employee in that specific field, it is important to have the necessary knowledge and skills related to Excel. This course is here to help you with the very basic and advanced features of Microsoft Excel 2016. You can start by learning to navigate the interface and familiarising yourself with the essential tools. Then move on to working with Functions, Data, Charts, and Tables. and then finish up by learning advanced features such as Macros, Sparklines, 3D Maps, and more!
With so many commitments in our lives, we may not have the time to learn new skills. The beauty of studying online is that you get to find this balance between your education and your daily commitments
Study 365 offers hundreds of online courses to students across the world. Gaining new skills has never been this easy as many of our courses are open to students with little or no qualifications or previous experience. All the courses are up-to-date, relevant, affordable, and will build on existing expertise or give you a jump-start to a new career. The courses are meticulously designed and equals what is offered in a classroom setting. With a solid reputation that has established and made us made us one of the most trusted and reliable online course providers we offer the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in your chosen career. You can learn at your own pace at Study 365 and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules, interactive quizzes and free resources which include Free CV writing pack, free career support and course demo to make your learning experience enriching and more rewarding.
The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course. The course is self-paced and you can complete it in stages, revisiting the lectures at any time.
At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed the course.
Those who successfully complete the course will be awarded the Mastering Excel 2016 certificate by CPD & iAP. The qualification will make you valuable to employers, and your motivation at gaining new skills will be recognised.
It doesn’t take long for people who meet Barbara Evers to recognize her talents in written and verbal communication. Tapping into this strength, Barbara has found success in many facets of her life. Her mission is to help others do the same professionally and personally.
Barbara received a Bachelor of Arts degree in Zoology and a Master of Arts in Professional Communication from Clemson University. She is an active member of the Association for Type International, and her certifications include:
Barbara has over twenty-five years’ experience in training and public speaking with an emphasis in Career Development. With a broad list of clients in the corporate, non-profit, and government arenas, she excels in teaching participants the skills and techniques that will advance their careers. Her educational and career pursuits have provided a diverse background for her to use in instructional design and in the classroom. She draws from this experience to customise her materials and provide a valuable, interactive experience for each participant. Her areas of expertise include Communication, Customer Service, Management, and Leadership as well as software training.
Barbara lives in Greer, SC and is a published writer and the recipient of several writing awards, including a Pushcart Prize nomination. She writes for several blogs including two of her own and is an active member of South Carolina Writers Association and HubCity Writers.
Christina Tankersley has been involved with software education and project management since 1994. Her career includes working on software development and varying manufacturing projects, helping people understand the power of diverse thinking, and continue to learn tools to share with customers, students, and the population at large.
Her primary focus for instruction includes:
She has a BS in Business from the University of Charleston, an MBA from North Greenville University, and certifications including Project Management Professional (PMP), Comptia A+, Comptia Certified Technical Trainer, and Microsoft Certified Trainer.
When not working or studying, she loves to travel, read, and spend time with friends and family.
Mastering Excel certificate 2016 (full course) is not a specific job-related qualification. Therefore, this course will not qualify you for any specific job position. However, this course certificate can be used to supplement your qualifications and to increase your candidature to land a job position in the administrative department of an organisation. The job positions this course will benefit, along with the average UK salary per annum according to https://www.payscale.com/career-path-planner, is given below,
|PART 1 BASICS|
|2: SELECTING AND NAVIGATING|
|3: KEYBOARD NAVIGATION AND BASIC DATA ENTRY|
|4: THE RIBBON|
|5: THE QUICK ACCESS TOOLBAR|
|6: CREATING A NEW SPREADSHEET|
|7: COMPATIBILITY ISSUES|
|8: CELL DATA & DATA TYPES|
|9: ACCESSING HELP|
|10: CREATING WORKSHEET FORMULAS|
|11: INSERT FUNCTIONS|
|12: RE-USING FORMULAS AND FUNCTIONS|
|13: INSERT, DELETE, & ADJUST COLUMNS & ROWS|
|14: FIND AND REPLACE|
|15: USE PROOFING AND RESEARCH TOOLS|
|16: APPLY TEXT FORMATS|
|17: APPLY NUMBER FORMATS|
|18: ALIGN CELL CONTENTS|
|19: APPLYING STYLES AND THEMES|
|20: CONDITIONAL FORMATTING|
|21: CREATING AND USING TEMPLATES|
|22: PREVIEW AND PRINT A NOTEBOOK|
|23: PAGE LAYOUT|
|24: CONFIGURE HEADERS AND FOOTERS|
|25: MANAGING WORKSHEETS|
|26: VIEW OPTIONS|
|27: MANAGING WORKBOOK PROPERTIES|
|PART 2 INTERMEDIATE|
|1.1 Working with Named Ranges|
|1.2 Using Named Ranges in Formulas|
|1.3 Using Specialized Functions|
|1.4 Working with Logical Functions|
|1.5 Displaying Functions/Formulas|
|1.6 Nesting Functions|
|1.7 Date and Time Functions|
|1.8 Text Functions|
|2.1 Sorting Data|
|2.2 Filtering Data|
|2.3 Using Database Functions|
|2.4 Using Subtotals|
|3: TABLES & CONDITIONAL FORMATTING|
|3.1 Create and Modify Tables|
|3.2 Manipulating Table Data|
|3.3 Conditional Formatting Rules|
|3.4 Using Logical Functions with Conditional Formatting|
|4.1 Creating Charts|
|4.2 Modifying and Formatting Charts|
|4.3 Creating a Dual Axis Chart|
|4.4 Chart Templates|
|5: SHAPES, TABLES, SLICERS & MORE|
|5.1 Formatting Shapes and Objects|
|5.2 Creating a PivotTable|
|5.3 Analyzing PivotTable Data|
|5.4 Pivot Charts|
|5.5 Slicers and Timelines|
|PART 3 ADVANCED|
|1: USING LINKS AND EXTERNAL REFERENCES|
|2: USING 3D REFERENCES|
|3: CONSOLIDATING DATA|
|4: USING LOOKUP FUNCTIONS, PART 1|
|5: USING LOOKUP FUNCTIONS, PART 2|
|6: TRACING PRECEDENT AND DEPENDENT CELLS|
|7: WATCHING AND EVALUATING FORMULAS|
|8: COMMENTS AND TRACK CHANGES|
|9: COMPARING AND MERGING WORKBOOKS|
|10: ACCESSIBILITY CHECKER|
|11: PROTECTING WORKSHEETS AND WORKBOOKS|
|12: APPLYING DATA VALIDATION|
|13: SEARCH FOR INVALID DATA|
|14: WORKING WITH MACROS, PART 1|
|15: WORKING WITH MACROS, PART 2|
|16: CREATING SPARKLINES|
|17: 3D MAPS|
|18: DATA TABLES|
|19: USING SCENARIOS|
|20: GOAL SEEK|
|21: FORECASTING DATA TRENDS|
|22: CHANGING YOUR DISPLAY|
|23: IMPORTING DELIMITED TEXT FILES|
|24: DATA FORMS AND FORM CONTROLS|
|25: CALCULATED FIELDS AND CUBE FUNCTIONS|
No Reviews found for this course.