3519 Courses

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Whether you work in machine learning or finance or are pursuing a career in web development or data science, Python is one of the most important skills you can learn. Python was developed upon the premise that there should be only one way (and preferably one obvious way) to do things, a philosophy that has resulted in a strict level of code standardization. The core programming language is quite small and the standard library is also large. In fact, Python's large library is one of its greatest benefits, providing a variety of different tools for programmers suited for many different tasks. Learn how to build a promising and lucrative career by training to become a Computer Programmer without any previous skill needed. By utilising the popular Python programming platform and language, you will swiftly learn how to understand the principles of writing programs and using variables in their construction. You will also be taught how to set up conditional and repeated executions in a routine, alongside the ability to recode and reuse other programs for templates or loops. Code yourself a bright future now. With a single payment you will gain access to Python Training including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. What other courses are included with this Python? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Benefits you'll get from choosing Apex Learning for this Python Training: Pay once and get lifetime access to 11 CPD courses including this Python Training Course Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Python Training designed by expert instructors Learn about Python Training at your ease - anytime, from anywhere Study the Python Training from your computer, tablet or mobile device The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Python Training expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum: Course 01: Python Programming for Everybody Module 01 A Installing Python Documentation Command Line Variables Simple Python Syntax Keywords Import Module Module 02 Additional Topics If Elif Else Iterable For Loops Execute Exceptions Module 03 Data Types Number Types More Number Types Strings More Strings Files Lists Dictionaries Tuples Sets Module 04 Comprehensions Definitions Functions Default Arguments Doc Strings Variadic Functions Factorial Module 05 Function Objects Lambda Generators Closures Classes Object Initialization Class Static Members Classic Inheritance Data Hiding How will I get my Certificate? After successfully completing this Training course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Excel Intermediate Course, 1-Day. This course covers the essential Excel Intermediate, in our interactive, instructor led Live Virtual Classroom. You already know your way around Excel e.g. you understand some of the functionality on the Home Ribbons, can move around and format cells. etc. In the Excel intermediate course we cover in-depth functions and Formulae so that you will be able to create fantastic spreadsheets like budgets, forecasts, and more. You will be able to understand and unravel the complicated formulae created by your colleagues. During the course you will excellent spreadsheets so that you have examples to take away. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Excel Intermediate Certification Hours: 1 Day, 10am-5pm Excel Intermediate Course, Course Outline. Working with Functions and Formulas The Function Wizard Using Functions in Excel: The 5 Popular functions If-else function Working with Names and Ranges Copying formulae Creating Formulae in Excel, general calculations. Lookups: Vlookup, Hlookup, Index, Match. Formatting a Range as a Table: Properties and behaviour of a table. Managing Tables: Working with Tables. Working with Tables: Working with Records and Fields. Filters and Sorting, Freeze panes, split, protecting and unprotecting. Using Excel as a Database: Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy. Pivot-tables: Create Pivot Table, Refresh Data. Amend, Filter, Sort, Format Pivot Tables, Add additional Pivot formulae. Pivot Charts: Excel Pivot Charts and Sparklines. Examples and exercises with Pivot Charts and Sparklines. Other Excel Courses Inlcuded with the Excel Intermediate Course PCWorkshops Excel Intermediate Certificate on completion Excel Intermediate Notes Excel Code Examples Practical Excel Intermediate exercises Personal attention in a small group of up to 4 delegates Book the Excel Intermediate Course About us Our experienced trainers are award winners. More about us FAQ's Client Comments

The leader of today has greater challenges than ever before in terms of unlocking human potential in their organisation and delivering results. This programme will help you achieve those aims and help you initiate and manage change more effectively. In particular, it will help you to: Develop an effective strategy to achieve your business goals Understand the role of emotional intelligence in leadership Take away a practical leadership tool-kit Develop a more dynamic approach through enhanced strategic creativity Broaden your understanding of the corporate culture to increase your influence within it Improve your persuasion and influencing skills to achieve your strategic goals Learn the key functions of strategic leadership In today’s world, one of the main aims of the leader is to develop the capability of the organisation to handle change and the challenges of the future even if those challenges have yet to be discovered. Leading in the organisational setting is becoming increasingly difficult because of the increase in regulation in all sectors and the risk of litigation. All organisations need leaders who can handle these challenges effectively, in particular the complexities of organisational life. At the same time, people who feel they are led effectively from the top find it easier to cope with and perform under higher pressure levels and therefore achieve the ultimate business goals Who should attend? This programme has been specifically designed for senior managers and those middle managers who are on the fast track to senior positions. It is suitable for both public and private sector individuals and all senior managers, executives and directors who understand the benefits both personally and professionally of developing strategic leadership skills. Practical training methods The course leader uses a broad range of learning techniques including short input sessions, individual development exercises, group work and case studies to provide a strong mix between practical training and giving a sound foundation of strategic leadership theory. The course provides you with a unique opportunity to put into practice what you have learnt and benefit from the observations and perceptions of the other course members. Leadership is less about doing and more about being. Day One Introduction and objectives The need for strategic leadership The roots of leadership How thought on leadership has developed Current perceptions on strategic leadership The leadership/management debate People and process issues The integrated approach to deliver results Levels of leadership The capabilities required at the strategic level The difference between strategic leadership and strategy Qualities and capabilities of strategic leaders Illustration through case studies Review of strategic capability Developing specific leadership qualities A review of strategic capability using case study examples Developing an approach to leadership Reviewing the traditional and current approaches to leadership CASE STUDY 1: Developing a leadership strategy Understanding leadership processes at all levels Applying the leadership hierarchy Analysing the process PRACTICAL EXERCISE Demonstrating the theory of leadership processes in practice Leadership and emotional intelligence The relationship between leadership and emotion The essence of organisational climate PRACTICAL EXERCISE Participants will work on an exercise to illustrate the theory of emotional intelligence in practice Day Two Review of day one Understanding strategic creativity Examining the psychological aspects of strategic thinking Mind mapping and other approaches to creative thinking Developing a creativity toolkit CASE STUDY 2: A strategic leadership challenge Developing a new vision and plan to transform an organisation to face future challenges based on a real-life scenario Developing strategic leadership capability A review of current approaches Understanding the behavioural approaches Developing a contingency approach Understanding corporate culture The structural aspects The behavioural aspects The human aspects How leaders can change corporate culture Developing a toolkit for change Understanding the cultural web The link with emotional intelligence CASE STUDY 3: Analysing leadership techniques This practical case study illustrates how the strategic approach and the application of appropriate leadership techniques including ‘split screen ability’ work in a real-life scenario Performance aspects at the strategic level Developing vision, goals and objectives Creating corporate identity and alignment Working with individual influencers Effective strategic influencing skills The characteristics of effective persuasive leaders Understanding methods of persuasion Profiling others Building the top team The nature of the top team Accepting diversity and challenge The key functions of strategic leadership Putting these into action Personal leadership planning Identifying tomorrow’s leaders Practical approaches The challenges for the future. Programme closure Action logs Next steps Feedback

The leader of today has greater challenges than ever before in terms of unlocking human potential in their organisation and delivering results. This programme will help you achieve those aims and help you initiate and manage change more effectively. In particular, it will help you to: Develop an effective strategy to achieve your business goals Understand the role of emotional intelligence in leadership Take away a practical leadership tool-kit Develop a more dynamic approach through enhanced strategic creativity Broaden your understanding of the corporate culture to increase your influence within it Improve your persuasion and influencing skills to achieve your strategic goals Learn the key functions of strategic leadership In today’s world, one of the main aims of the leader is to develop the capability of the organisation to handle change and the challenges of the future even if those challenges have yet to be discovered. Leading in the organisational setting is becoming increasingly difficult because of the increase in regulation in all sectors and the risk of litigation. All organisations need leaders who can handle these challenges effectively, in particular the complexities of organisational life. At the same time, people who feel they are led effectively from the top find it easier to cope with and perform under higher pressure levels and therefore achieve the ultimate business goals Who should attend? This programme has been specifically designed for senior managers and those middle managers who are on the fast track to senior positions. It is suitable for both public and private sector individuals and all senior managers, executives and directors who understand the benefits both personally and professionally of developing strategic leadership skills. Practical training methods The course leader uses a broad range of learning techniques including short input sessions, individual development exercises, group work and case studies to provide a strong mix between practical training and giving a sound foundation of strategic leadership theory. The course provides you with a unique opportunity to put into practice what you have learnt and benefit from the observations and perceptions of the other course members. Leadership is less about doing and more about being. Day One Introduction and objectives The need for strategic leadership The roots of leadership How thought on leadership has developed Current perceptions on strategic leadership The leadership/management debate People and process issues The integrated approach to deliver results Levels of leadership The capabilities required at the strategic level The difference between strategic leadership and strategy Qualities and capabilities of strategic leaders Illustration through case studies Review of strategic capability Developing specific leadership qualities A review of strategic capability using case study examples Developing an approach to leadership Reviewing the traditional and current approaches to leadership CASE STUDY 1: Developing a leadership strategy Understanding leadership processes at all levels Applying the leadership hierarchy Analysing the process PRACTICAL EXERCISE Demonstrating the theory of leadership processes in practice Leadership and emotional intelligence The relationship between leadership and emotion The essence of organisational climate PRACTICAL EXERCISE Participants will work on an exercise to illustrate the theory of emotional intelligence in practice Day Two Review of day one Understanding strategic creativity Examining the psychological aspects of strategic thinking Mind mapping and other approaches to creative thinking Developing a creativity toolkit CASE STUDY 2: A strategic leadership challenge Developing a new vision and plan to transform an organisation to face future challenges based on a real-life scenario Developing strategic leadership capability A review of current approaches Understanding the behavioural approaches Developing a contingency approach Understanding corporate culture The structural aspects The behavioural aspects The human aspects How leaders can change corporate culture Developing a toolkit for change Understanding the cultural web The link with emotional intelligence CASE STUDY 3: Analysing leadership techniques This practical case study illustrates how the strategic approach and the application of appropriate leadership techniques including ‘split screen ability’ work in a real-life scenario Performance aspects at the strategic level Developing vision, goals and objectives Creating corporate identity and alignment Working with individual influencers Effective strategic influencing skills The characteristics of effective persuasive leaders Understanding methods of persuasion Profiling others Building the top team The nature of the top team Accepting diversity and challenge The key functions of strategic leadership Putting these into action Personal leadership planning Identifying tomorrow’s leaders Practical approaches The challenges for the future. Programme closure Action logs Next steps Feedback

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. An Overview of Python Why Python? Python in the Shell Python in Web Notebooks (iPython, Jupyter, Zeppelin) Demo: Python, Notebooks, and Data Science Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Sequences, Arrays, Dictionaries and Sets About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Generator Expressions Nested sequences Working with Dictionaries Working with Sets Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Functions Defining functions Parameters Global and local scope Nested functions Returning values Essential Demos Sorting Exceptions Importing Modules Classes Regular Expressions The standard library Math functions The string module Dates and times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Python and Data Science Data Science Essentials Pandas Overview NumPy Overview SciKit Overview MatPlotLib Overview Working with Python in Data Science Additional course details: Nexus Humans Python for Data Science: Hands-on Technical Overview (TTPS4873) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Python for Data Science: Hands-on Technical Overview (TTPS4873) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Course Overview: Data analysis is a hot skill in today's job market. According to a recent study by LinkedIn, demand for data analysts is growing 15 times faster than the average for all occupations. And the salaries are good too. The average salary for a data analyst in the UK is £40,000. If you're looking to get ahead in your career or learn a new skill that's in high demand, then the Data Analysis in Excel Level 3 Course is for you. In this course, you'll learn how to use Excel to analyse data like a pro. You'll learn how to clean, format, and analyse data using various Excel tools and techniques. You'll also learn how to create charts and graphs to visualise your data. This course won't merely make you adept at Excel. It will mould you into a data wizard, wielding Excel as a potent tool to make data sing and secrets reveal themselves. Enrol Today and Start Learning! Key Features of the Course: Embark on your data analysis journey with us and discover these exciting features: A CPD Certificate to validate your newfound skills. 24/7 Learning Assistance for any hour inspiration strikes. Engaging learning materials to ensure an enriching learning experience. Who is This Course For? Our Data Analysis in Excel Level 3 Course caters to ambitious individuals with a basic understanding of Excel, eager to take their skills to new heights. This course welcomes everything from budding data enthusiasts to established business analysts seeking to fortify their analytical toolkits. What You Will Learn: Dive deep into the labyrinth of data as you master essential modules such as 'Search for and Replace Data,' 'Sort and Filter Data,' and 'Query Data with Database Functions.' Venture further into data exploration with our 'Outline and Subtotal Data' module, where you'll learn to summarise your data for a more organised view efficiently. The journey continues with modules like 'Create Charts' and 'Modify and Format Charts,' enabling you to translate complex data into easy-to-understand visuals. Furthermore, our dedicated modules on 'Creating a PivotTable' and 'Analysing PivotTable Data' promise a comprehensive understanding of one of Excel's most powerful tools. Why Enrol in This Course: Rated as a top-reviewed course and constantly updated to keep up with the latest trends, our Data Analysis in Excel Level 3 Course equips you with sought-after skills like data forecasting, creating sparklines, using advanced chart features, and more. Requirements: While no specific prerequisites are required, a basic understanding of Excel and an eagerness to explore the fascinating world of data analysis would be beneficial. Career Path: On completion of this Data Analysis in Excel Level 3 Course course, you'll be ready to step into diverse roles such as: Data Analyst (£30,000-£35,000) Business Intelligence Analyst (£32,000-£37,000) Market Research Analyst (£28,000-£33,000) Operations Analyst (£31,000-£36,000) Financial Analyst (£35,000-£40,000) Supply Chain Analyst (£30,000-£35,000) Sales Analyst (£29,000-£34,000) Certification: Upon successful completion of the course, you'll be awarded a prestigious CPD Certificate, demonstrating your expertise in data analysis using Excel. So, are you ready to discover the hidden stories in data and revolutionise decision-making? Enrol in our Data Analysis in Excel Level 3 Course and start your journey today! Course Curriculum 11 sections • 32 lectures • 04:43:00 total length •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 •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 •Apply Intermediate Conditional Formatting: 00:07:00 •Apply Advanced Conditional Formatting: 00:05:00 •Create Charts: 00:13:00 •Modify and Format Charts: 00:12:00 •Use Advanced Chart Features: 00:12:00 •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 •Use Links and External References: 00:12:00 •Use 3-D References: 00:06:00 •Consolidate Data: 00:05:00 •Use Lookup Functions: 00:12:00 •Trace Cells: 00:09:00 •Watch and Evaluate Formulas: 00:08:00 •Apply Data Validation: 00:13:00 •Search for Invalid Data and Formulas with Errors: 00:04:00 •Work with Macros: 00:18:00 •Create Sparklines: 00:07:00 •MapData: 00:07:00 •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 •Assignment - Data Analysis in Excel Level 3 Course: 00:00:00

Duration 4 Days 24 CPD hours This course is intended for This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Overview Skills gained in this training include:The features that Pig, Hive, and Impala offer for data acquisition, storage, and analysisThe fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with HadoopHow Pig, Hive, and Impala improve productivity for typical analysis tasksJoining diverse datasets to gain valuable business insightPerforming real-time, complex queries on datasets Cloudera University?s four-day data analyst training course focusing on Apache Pig and Hive and Cloudera Impala will teach you to apply traditional data analytics and business intelligence skills to big data. Hadoop Fundamentals The Motivation for Hadoop Hadoop Overview Data Storage: HDFS Distributed Data Processing: YARN, MapReduce, and Spark Data Processing and Analysis: Pig, Hive, and Impala Data Integration: Sqoop Other Hadoop Data Tools Exercise Scenarios Explanation Introduction to Pig What Is Pig? Pig?s Features Pig Use Cases Interacting with Pig Basic Data Analysis with Pig Pig Latin Syntax Loading Data Simple Data Types Field Definitions Data Output Viewing the Schema Filtering and Sorting Data Commonly-Used Functions Processing Complex Data with Pig Storage Formats Complex/Nested Data Types Grouping Built-In Functions for Complex Data Iterating Grouped Data Multi-Dataset Operations with Pig Techniques for Combining Data Sets Joining Data Sets in Pig Set Operations Splitting Data Sets Pig Troubleshoot & Optimization Troubleshooting Pig Logging Using Hadoop?s Web UI Data Sampling and Debugging Performance Overview Understanding the Execution Plan Tips for Improving the Performance of Your Pig Jobs Introduction to Hive & Impala What Is Hive? What Is Impala? Schema and Data Storage Comparing Hive to Traditional Databases Hive Use Cases Querying with Hive & Impala Databases and Tables Basic Hive and Impala Query Language Syntax Data Types Differences Between Hive and Impala Query Syntax Using Hue to Execute Queries Using the Impala Shell Data Management Data Storage Creating Databases and Tables Loading Data Altering Databases and Tables Simplifying Queries with Views Storing Query Results Data Storage & Performance Partitioning Tables Choosing a File Format Managing Metadata Controlling Access to Data Relational Data Analysis with Hive & Impala Joining Datasets Common Built-In Functions Aggregation and Windowing Working with Impala How Impala Executes Queries Extending Impala with User-Defined Functions Improving Impala Performance Analyzing Text and Complex Data with Hive Complex Values in Hive Using Regular Expressions in Hive Sentiment Analysis and N-Grams Conclusion Hive Optimization Understanding Query Performance Controlling Job Execution Plan Bucketing Indexing Data Extending Hive SerDes Data Transformation with Custom Scripts User-Defined Functions Parameterized Queries Choosing the Best Tool for the Job Comparing MapReduce, Pig, Hive, Impala, and Relational Databases Which to Choose?

Learn to write scalable, reusable, and maintainable code by leveraging the OOP concepts in Python. This comprehensive OOP course covers essential concepts, such as encapsulation, inheritance, and polymorphism. The last section of this course covers a real-world library management system project.

Description: Microsoft Excel, developed by Microsoft Corporation, is world's leading spreadsheet program for Windows, macOS, Android and iOS. The program includes calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications to make your task easy and for saving your precious time. You can hardly find any company where Microsoft Excel is not used. The knowledge of Excel is a must for meeting any career perspective. The course will help you to achieve the goals. Therefore after completing this video course, you will be a prolific user of the program. As the course is sectioned based on the level of difficulty, you will know the basics of Excel at first. You will know how to open an excel program, how to put data or know some simple calculations. After the primary knowledge, you will be introduced to some more features and functions of the program such as analyse massive amounts of data, extract actionable information from it, etc. Finally, you will learn different features of Excel program that allows you take the right business decisions for your company. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Excel Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface FREE 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:17: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:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08: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:05:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00