Microsoft Excel is a spreadsheet application consisting of a collection of cells arranged into rows and columns to organize and manipulate data. Excel features the ability to perform calculations, format & store data, use graphs & histograms, create pivot tables, and create macros. Excel is typically used to do data processing & analysis. Excel is used across all business functions and at organizations of all sizes. The main uses of Excel include: Data entry, Data management, Accounting, Financial analysis, Charting and graphing, Programming, Time management, Task management, Financial modeling, Customer relationship management (CRM), and so on.
Section 1: Foundation Unit 1.1 – Excel Introduction A description of the purpose and application of Excel – what it can do, why it’s useful. Unit 1.2 – The Excel Interface Understanding and working with the Excel interface – getting to know your way around the application, how to access functionality and how to customize it. How to create, save and open Workbooks. Under Save As, a brief explanation of backwards compatibility and other formats (e.g. PDF) save options. Skydrive, alternative online storage, and ‘local’ saving. Basic printing. Unit 1.3 – Basic Navigation & Editing Selection and navigation. Moving around a spreadsheet efficiently. Entering information into cells, types of data (text, numbers, dates). Basic formatting. Working with multiple Worksheets. Unit 1.4 – Getting going Takes a quick look at a first ‘real’ spreadsheet, in order to introduce the concept of functions and formulas, and give a feel for how Excel can be useful. Section 2: Orientation and efficiency Unit 2.1 – Editing Copying, pasting, inserting and deleting cells, ranges of cells, rows, columns and Worksheets. ‘Special’ pasting – for example to copy just formulas, or just values. Common problems with pasting. The differences between copying and ‘cutting’.
About Course Provider
Uplatz is an innovative digital marketplace for smart learning. It is a tutor-based 1:1 learning platform. We have a strong network of qualified and experienced tutors providing hot courses (such as Big Data, Hadoop, SAP FICO, Informatica, Python, and more..) in a virtual classroom set-up.
And guess what? No one in the market can beat us in course prices! Each of our courses is listed at 80% discounted rate from average market price of the same course.
What more, we have a strong technical team with a mentor from IIT Kanpur! Digital, digital, digital...
Happy Learning at uplatz!
How to enroll?
Provide us with your contact details, course provider will get back to you.