Excel is a spreadsheet application from Microsoft. It allows users to enter data, calculate values, and format cells. The latest version is Excel 2013. Excel uses workbooks that contain worksheets where data is entered into cells organized in columns and rows. Formulas can be used to perform calculations with functions. Data is formatted for appearance. A sample worksheet is created to track student course information and calculate GPA.
Excel is a spreadsheet program used to store and manipulate data. It consists of workbooks containing worksheets with rows and columns that intersect to form cells. The basic Excel features include functions, auto fill, charts, and pivot tables. Shortcut keys allow quick navigation between tabs, selecting ranges, editing cells, and common commands like save, print, open and close. The document provides an overview of Excel and its key components along with examples of functions and commonly used shortcut keys.
Microsoft Excel allows users to organize data into spreadsheets. It contains workbooks with multiple worksheets made of cells organized into rows and columns. Excel provides functions to perform calculations and analyze data. Users can format worksheets, insert charts and images, and print selections of cells or entire worksheets. Formulas using built-in functions can easily calculate and manipulate data in Excel.
Introduction to Microsoft Excel for beginnersBlogger Mumma
Microsoft Excel is a spreadsheet application developed by Microsoft that features calculation and graphing tools. It consists of worksheets containing columns and rows where data is entered into cells referenced by their column letter and row number intersection. The basic Excel interface includes a title bar, menu bar, toolbars and worksheets. Formulas and functions can be used to perform calculations on the data in cells. Charts and graphs can be generated from cell data to visualize information. Data can be copied, filtered, and sorted as needed.
This document provides an overview of the basic features and interface of Microsoft Excel, including how to open and save worksheets, customize Excel, modify worksheets by formatting cells and adding formulas and functions, and sort and filter data. It describes the main parts of the Excel interface such as the ribbon, formula bar, rows and columns, scroll bars, and sheet tabs. It also explains how to exit Excel.
This document provides an overview of Microsoft Excel basics, including defining key terms like worksheet and workbook, identifying the parts of a worksheet, opening and saving workbooks, entering and editing data, searching and replacing values, zooming and printing worksheets, and closing files. The objectives are to learn the basic functions and navigation of Excel in order to effectively manage and analyze data in spreadsheets.
This document provides an introduction and tutorial for Microsoft Excel. It begins with an overview of Excel and what it can be used for, such as budget creation, data analysis, and presenting information. It then discusses key Excel components like the ribbon menu, cells, columns, rows, and worksheets. The document provides instructions for common tasks like navigating, entering data, formatting text and cells, inserting and deleting rows and columns, sorting data, and printing. It concludes by explaining how to copy and paste formatting between cells using tools like the format painter.
The document provides an overview of Microsoft Excel, including:
- Excel is used to organize and manipulate numerical data in electronic spreadsheets. It allows users to perform calculations, create charts and graphs, and format information.
- The Excel interface includes tabs for worksheets, a title bar, menu bar, and toolbars for common functions like formatting and calculations.
- Key functions covered include entering and formatting data, creating formulas for calculations, sorting and filtering data, inserting charts and graphs, printing worksheets, and using keyboard shortcuts.
This document discusses Microsoft Excel and its features. It introduces Excel as a spreadsheet program that allows users to organize, format and calculate data. It describes the basic interface of Excel including cells, columns, rows and sheets. It also provides information on common Excel functions and formulas for calculations, examples of using Excel to create simple reports and bills, and a formula for calculating age based on date of birth and the current year.
Excel is a spreadsheet program used to store and manipulate data. It consists of workbooks containing worksheets with rows and columns that intersect to form cells. The basic Excel features include functions, auto fill, charts, and pivot tables. Shortcut keys allow quick navigation between tabs, selecting ranges, editing cells, and common commands like save, print, open and close. The document provides an overview of Excel and its key components along with examples of functions and commonly used shortcut keys.
Microsoft Excel allows users to organize data into spreadsheets. It contains workbooks with multiple worksheets made of cells organized into rows and columns. Excel provides functions to perform calculations and analyze data. Users can format worksheets, insert charts and images, and print selections of cells or entire worksheets. Formulas using built-in functions can easily calculate and manipulate data in Excel.
Introduction to Microsoft Excel for beginnersBlogger Mumma
Microsoft Excel is a spreadsheet application developed by Microsoft that features calculation and graphing tools. It consists of worksheets containing columns and rows where data is entered into cells referenced by their column letter and row number intersection. The basic Excel interface includes a title bar, menu bar, toolbars and worksheets. Formulas and functions can be used to perform calculations on the data in cells. Charts and graphs can be generated from cell data to visualize information. Data can be copied, filtered, and sorted as needed.
This document provides an overview of the basic features and interface of Microsoft Excel, including how to open and save worksheets, customize Excel, modify worksheets by formatting cells and adding formulas and functions, and sort and filter data. It describes the main parts of the Excel interface such as the ribbon, formula bar, rows and columns, scroll bars, and sheet tabs. It also explains how to exit Excel.
This document provides an overview of Microsoft Excel basics, including defining key terms like worksheet and workbook, identifying the parts of a worksheet, opening and saving workbooks, entering and editing data, searching and replacing values, zooming and printing worksheets, and closing files. The objectives are to learn the basic functions and navigation of Excel in order to effectively manage and analyze data in spreadsheets.
This document provides an introduction and tutorial for Microsoft Excel. It begins with an overview of Excel and what it can be used for, such as budget creation, data analysis, and presenting information. It then discusses key Excel components like the ribbon menu, cells, columns, rows, and worksheets. The document provides instructions for common tasks like navigating, entering data, formatting text and cells, inserting and deleting rows and columns, sorting data, and printing. It concludes by explaining how to copy and paste formatting between cells using tools like the format painter.
The document provides an overview of Microsoft Excel, including:
- Excel is used to organize and manipulate numerical data in electronic spreadsheets. It allows users to perform calculations, create charts and graphs, and format information.
- The Excel interface includes tabs for worksheets, a title bar, menu bar, and toolbars for common functions like formatting and calculations.
- Key functions covered include entering and formatting data, creating formulas for calculations, sorting and filtering data, inserting charts and graphs, printing worksheets, and using keyboard shortcuts.
This document discusses Microsoft Excel and its features. It introduces Excel as a spreadsheet program that allows users to organize, format and calculate data. It describes the basic interface of Excel including cells, columns, rows and sheets. It also provides information on common Excel functions and formulas for calculations, examples of using Excel to create simple reports and bills, and a formula for calculating age based on date of birth and the current year.
This document provides an overview of key aspects of Microsoft Excel including its features, file formats, navigation keys, worksheets, formatting, cells and ranges, formulas, functions, and error values. It describes Excel's abilities for number crunching, creating charts and graphs, organizing lists, and accessing other data. It also outlines the basic components of formulas in Excel including operators, cell references, values/text, and functions. Finally, it provides examples of commonly used functions like SUM, AVERAGE, VLOOKUP, and COUNTIF.
This document provides instructions for creating a basic financial worksheet in Microsoft Excel 2007. It includes steps for entering sample data on sales numbers for four months, using formulas to calculate totals, applying basic formatting and styles, inserting a clustered column chart to visualize the data, and printing and saving the worksheet. The instructions introduce foundational Excel concepts such as workbooks, worksheets, cells, formulas, charts, formatting, and printing.
This document provides an overview of key aspects of Microsoft Excel including:
- Excel is a widely used spreadsheet program that allows users to store, organize, and analyze information using workbooks, worksheets, and cells.
- The document reviews Excel interfaces such as the ribbon, toolbars, and shortcuts to help navigate and perform tasks more efficiently.
- Common functions and features like formulas, formatting, filtering, sorting, conditional formatting, and protecting sheets are described to understand how to manipulate and present data.
- Best practices for working with dates, times, and functions are covered to help properly store, display, and calculate dates and times in Excel.
Excel allows users to enter formulas to perform calculations on worksheet data. Formulas begin with an equal sign and can reference cell addresses to manipulate cell values using mathematical operators like addition and subtraction. Common functions like SUM, AVERAGE, and MAX simplify calculations. Formulas can be copied and filled using relative or absolute cell references.
This document provides information about Microsoft Excel, including:
- Excel is an electronic spreadsheet program that allows users to create graphs, worksheets, and perform calculations.
- It has features like calculation, graphing tools, pivot tables, and a macro programming language called VBA.
- Excel is useful for tasks like data entry, data manipulation, formulas, analysis, and automatic graphing.
- The document then reviews parts of the Excel window and interface like ribbons, tabs, and cells.
- It provides instructions on opening, saving, and manipulating Excel files and worksheets.
This document provides an overview and introduction to key features in Microsoft Word 2010, including:
The File, Home, Insert, References, View, and Page Layout tabs which contain various formatting tools and options for working with text, pages, tables, images, and more. Common tools include font styling, bulleted lists, tables, headers and footers, citations, and zoom controls. Page setup options allow customizing margins, orientation, columns, and other layout properties.
The document provides an overview of Microsoft Excel, including its interface elements like ribbons, tabs and groups. It describes how to work with cells, insert and delete rows and columns, format text, conditional formatting, sorting, cell referencing, functions and shortcuts. Functions covered include SUM, IF, COUNT, DATE, TEXT and logical functions. It also discusses auditing cell dependencies and precedents.
Microsoft Excel is a component of MS Office used to enter, analyze, and present quantitative data. It uses a spreadsheet format laid out in a grid of rows and columns. Excel is commonly used in business for tasks like budgeting, inventory management, and decision making. The Excel window interface includes elements like the ribbon, tabs, quick access toolbar, worksheet, formula bar, and status bar that allow the user to navigate, enter data and formulas, and view information. Formulas in Excel use operators to calculate and return values based on cell data.
Excel is an electronic spreadsheet program that allows users to store, organize, and manipulate data in a grid of rows and columns called a worksheet. Worksheets contain cells that can hold text, numbers, or formulas. Excel provides tools like functions, charts, and data analysis features to help work with large amounts of data. Users can enter values, edit data, search, zoom, and print worksheets.
This document provides a 3-paragraph summary of a PowerPoint presentation on Excel:
The presentation introduces Excel as a software program developed by Microsoft that allows users to organize and calculate data in a spreadsheet. It describes the basic Excel interface including worksheets, cells, formulas, and functions. Common functions like SUM, AVERAGE, MIN, and MAX are explained. The presentation also covers formatting text and numbers, inserting shapes and pictures, printing options, and other Excel features.
Excel functions and formulas are demonstrated including relative and absolute cell references. Logical IF functions are introduced to conditionally format cells based on comparisons. Syntax for IF functions is provided. Common Excel elements like toolbars, menus, sorting, and conditional formatting
Excel can be used for calculations, data management, charts and graphs. It contains worksheets organized into rows and columns within a workbook. Each worksheet has cells located at the intersection of rows and columns that can be referenced by their address. Data is entered into cells and basic navigation uses keyboard shortcuts like tab, arrow keys, page up/down and Ctrl+home. Cells, rows and columns can be selected using the mouse or keyboard for editing.
Ms excel basic about Data, graph and pivot table Alomgir Hossain
Microsoft Excel can be used to store, organize, and manipulate data. It allows data to be organized in workbooks containing worksheets with rows and columns made up of cells. Excel contains various built-in functions, formulas, charts, and data analysis tools. This document provides an overview of Excel's basic features and functions, how to enter and format data, use formulas and functions, sort and filter data, insert and delete rows/columns, and create basic charts and graphs. It demonstrates the core capabilities of Excel for organizing and analyzing data.
The document is a tutorial for using Microsoft Excel. It provides step-by-step instructions on how to navigate the Excel interface and use basic functions. The tutorial covers topics such as navigating the Excel screen, entering formulas and data, formatting worksheets, creating charts, and using keyboard shortcuts. It also includes explanations and instructions for common Excel tasks like opening and saving files, editing data, printing worksheets, and more.
MS Excel Learning for PPC Google AdWords Training CourseRanjan Jena
MS Excel learning to get expertise in Google AdWords training course. Learn all important tips and techniques in MS Excel for your fast and easy approach to Google AdWords analysis and reporting formats.
Ranjan Jena conducts Adwords Training session in Bangalore, currently with more than 45 students already graduated under his guidance and mentorship. For any training need, you can directly reach him at +91-7760969452
Microsoft Word is word processing software that allows users to create a variety of documents. It has features like tables, illustrations, fonts, and formatting tools. Documents can be opened, saved, printed, and shared. The ribbon interface contains tabs for common tasks like inserting objects, formatting text, and manipulating paragraphs. Users can also search and replace text, add page borders, and insert watermarks.
This document provides an introduction to Microsoft Excel. It begins with opening Excel and navigating within workbooks and worksheets. It describes entering different types of data like numbers, text, formulas. It discusses selecting cells, entering and editing data, copying and moving data using fill handle. It also covers saving workbooks in compatibility mode to allow opening in older Excel versions. The document is presented by Abdulbasit H. Mhdi and contains guidance, instructions and screenshots to explain key Excel concepts.
The document discusses various data analysis and visualization techniques in Microsoft Excel including filtering, sorting, formulas, functions, pivot tables, charts and conditional formatting. It provides step-by-step instructions on how to use these tools to extract insights from data by filtering to select specific records, using formulas and functions like VLOOKUP to perform calculations, sorting data, creating pivot tables and pivot charts to summarize and visualize data relationships, and applying conditional formatting to highlight important values.
This document provides an overview of word processing software and Microsoft Word. It describes the basic components of the MS Word interface and how to perform common word processing tasks like creating, editing, formatting and printing documents. Functions covered include saving, viewing and retrieving documents, as well as editing features, character formatting, paragraph formatting, page formatting, and tools to enhance document accuracy.
The document provides an overview of Microsoft Excel and its features. It discusses how Excel allows for data organization, calculation, charting and formatting. Key features mentioned include functions, formulas, sorting/filtering data, and creating charts. Examples are given of entering formulas for addition, subtraction, multiplication and division. The document also discusses entering and manipulating data, creating charts, and printing in Excel.
This document provides an introduction to using Adobe Photoshop. It discusses what Photoshop is, how it can be used for publications, websites, and video/digital materials. It also covers starting Photoshop, the interface including menus and tools, understanding layers and how to work with layers, common file formats like JPEG and TIFF, creating image archives, and image resolution. The document serves as a beginner's guide for getting familiar with the Photoshop environment and basic image editing and manipulation tasks.
Lesson 13: cooperative Learning with the Computermiss yhda
This document discusses cooperative learning with computers. It defines cooperative learning as students working in small groups on a common task. The elements of cooperative learning include having a common goal, interdependence, interaction, individual accountability, and social skills. Some advantages are that it encourages active learning, motivates students, improves performance, and teacher effectiveness. Disadvantages include some students talking off-topic, becoming impatient, or one student doing most of the work. The document also discusses how computers can be used to support cooperative learning while still developing students' social skills.
This document provides an overview of key aspects of Microsoft Excel including its features, file formats, navigation keys, worksheets, formatting, cells and ranges, formulas, functions, and error values. It describes Excel's abilities for number crunching, creating charts and graphs, organizing lists, and accessing other data. It also outlines the basic components of formulas in Excel including operators, cell references, values/text, and functions. Finally, it provides examples of commonly used functions like SUM, AVERAGE, VLOOKUP, and COUNTIF.
This document provides instructions for creating a basic financial worksheet in Microsoft Excel 2007. It includes steps for entering sample data on sales numbers for four months, using formulas to calculate totals, applying basic formatting and styles, inserting a clustered column chart to visualize the data, and printing and saving the worksheet. The instructions introduce foundational Excel concepts such as workbooks, worksheets, cells, formulas, charts, formatting, and printing.
This document provides an overview of key aspects of Microsoft Excel including:
- Excel is a widely used spreadsheet program that allows users to store, organize, and analyze information using workbooks, worksheets, and cells.
- The document reviews Excel interfaces such as the ribbon, toolbars, and shortcuts to help navigate and perform tasks more efficiently.
- Common functions and features like formulas, formatting, filtering, sorting, conditional formatting, and protecting sheets are described to understand how to manipulate and present data.
- Best practices for working with dates, times, and functions are covered to help properly store, display, and calculate dates and times in Excel.
Excel allows users to enter formulas to perform calculations on worksheet data. Formulas begin with an equal sign and can reference cell addresses to manipulate cell values using mathematical operators like addition and subtraction. Common functions like SUM, AVERAGE, and MAX simplify calculations. Formulas can be copied and filled using relative or absolute cell references.
This document provides information about Microsoft Excel, including:
- Excel is an electronic spreadsheet program that allows users to create graphs, worksheets, and perform calculations.
- It has features like calculation, graphing tools, pivot tables, and a macro programming language called VBA.
- Excel is useful for tasks like data entry, data manipulation, formulas, analysis, and automatic graphing.
- The document then reviews parts of the Excel window and interface like ribbons, tabs, and cells.
- It provides instructions on opening, saving, and manipulating Excel files and worksheets.
This document provides an overview and introduction to key features in Microsoft Word 2010, including:
The File, Home, Insert, References, View, and Page Layout tabs which contain various formatting tools and options for working with text, pages, tables, images, and more. Common tools include font styling, bulleted lists, tables, headers and footers, citations, and zoom controls. Page setup options allow customizing margins, orientation, columns, and other layout properties.
The document provides an overview of Microsoft Excel, including its interface elements like ribbons, tabs and groups. It describes how to work with cells, insert and delete rows and columns, format text, conditional formatting, sorting, cell referencing, functions and shortcuts. Functions covered include SUM, IF, COUNT, DATE, TEXT and logical functions. It also discusses auditing cell dependencies and precedents.
Microsoft Excel is a component of MS Office used to enter, analyze, and present quantitative data. It uses a spreadsheet format laid out in a grid of rows and columns. Excel is commonly used in business for tasks like budgeting, inventory management, and decision making. The Excel window interface includes elements like the ribbon, tabs, quick access toolbar, worksheet, formula bar, and status bar that allow the user to navigate, enter data and formulas, and view information. Formulas in Excel use operators to calculate and return values based on cell data.
Excel is an electronic spreadsheet program that allows users to store, organize, and manipulate data in a grid of rows and columns called a worksheet. Worksheets contain cells that can hold text, numbers, or formulas. Excel provides tools like functions, charts, and data analysis features to help work with large amounts of data. Users can enter values, edit data, search, zoom, and print worksheets.
This document provides a 3-paragraph summary of a PowerPoint presentation on Excel:
The presentation introduces Excel as a software program developed by Microsoft that allows users to organize and calculate data in a spreadsheet. It describes the basic Excel interface including worksheets, cells, formulas, and functions. Common functions like SUM, AVERAGE, MIN, and MAX are explained. The presentation also covers formatting text and numbers, inserting shapes and pictures, printing options, and other Excel features.
Excel functions and formulas are demonstrated including relative and absolute cell references. Logical IF functions are introduced to conditionally format cells based on comparisons. Syntax for IF functions is provided. Common Excel elements like toolbars, menus, sorting, and conditional formatting
Excel can be used for calculations, data management, charts and graphs. It contains worksheets organized into rows and columns within a workbook. Each worksheet has cells located at the intersection of rows and columns that can be referenced by their address. Data is entered into cells and basic navigation uses keyboard shortcuts like tab, arrow keys, page up/down and Ctrl+home. Cells, rows and columns can be selected using the mouse or keyboard for editing.
Ms excel basic about Data, graph and pivot table Alomgir Hossain
Microsoft Excel can be used to store, organize, and manipulate data. It allows data to be organized in workbooks containing worksheets with rows and columns made up of cells. Excel contains various built-in functions, formulas, charts, and data analysis tools. This document provides an overview of Excel's basic features and functions, how to enter and format data, use formulas and functions, sort and filter data, insert and delete rows/columns, and create basic charts and graphs. It demonstrates the core capabilities of Excel for organizing and analyzing data.
The document is a tutorial for using Microsoft Excel. It provides step-by-step instructions on how to navigate the Excel interface and use basic functions. The tutorial covers topics such as navigating the Excel screen, entering formulas and data, formatting worksheets, creating charts, and using keyboard shortcuts. It also includes explanations and instructions for common Excel tasks like opening and saving files, editing data, printing worksheets, and more.
MS Excel Learning for PPC Google AdWords Training CourseRanjan Jena
MS Excel learning to get expertise in Google AdWords training course. Learn all important tips and techniques in MS Excel for your fast and easy approach to Google AdWords analysis and reporting formats.
Ranjan Jena conducts Adwords Training session in Bangalore, currently with more than 45 students already graduated under his guidance and mentorship. For any training need, you can directly reach him at +91-7760969452
Microsoft Word is word processing software that allows users to create a variety of documents. It has features like tables, illustrations, fonts, and formatting tools. Documents can be opened, saved, printed, and shared. The ribbon interface contains tabs for common tasks like inserting objects, formatting text, and manipulating paragraphs. Users can also search and replace text, add page borders, and insert watermarks.
This document provides an introduction to Microsoft Excel. It begins with opening Excel and navigating within workbooks and worksheets. It describes entering different types of data like numbers, text, formulas. It discusses selecting cells, entering and editing data, copying and moving data using fill handle. It also covers saving workbooks in compatibility mode to allow opening in older Excel versions. The document is presented by Abdulbasit H. Mhdi and contains guidance, instructions and screenshots to explain key Excel concepts.
The document discusses various data analysis and visualization techniques in Microsoft Excel including filtering, sorting, formulas, functions, pivot tables, charts and conditional formatting. It provides step-by-step instructions on how to use these tools to extract insights from data by filtering to select specific records, using formulas and functions like VLOOKUP to perform calculations, sorting data, creating pivot tables and pivot charts to summarize and visualize data relationships, and applying conditional formatting to highlight important values.
This document provides an overview of word processing software and Microsoft Word. It describes the basic components of the MS Word interface and how to perform common word processing tasks like creating, editing, formatting and printing documents. Functions covered include saving, viewing and retrieving documents, as well as editing features, character formatting, paragraph formatting, page formatting, and tools to enhance document accuracy.
The document provides an overview of Microsoft Excel and its features. It discusses how Excel allows for data organization, calculation, charting and formatting. Key features mentioned include functions, formulas, sorting/filtering data, and creating charts. Examples are given of entering formulas for addition, subtraction, multiplication and division. The document also discusses entering and manipulating data, creating charts, and printing in Excel.
This document provides an introduction to using Adobe Photoshop. It discusses what Photoshop is, how it can be used for publications, websites, and video/digital materials. It also covers starting Photoshop, the interface including menus and tools, understanding layers and how to work with layers, common file formats like JPEG and TIFF, creating image archives, and image resolution. The document serves as a beginner's guide for getting familiar with the Photoshop environment and basic image editing and manipulation tasks.
Lesson 13: cooperative Learning with the Computermiss yhda
This document discusses cooperative learning with computers. It defines cooperative learning as students working in small groups on a common task. The elements of cooperative learning include having a common goal, interdependence, interaction, individual accountability, and social skills. Some advantages are that it encourages active learning, motivates students, improves performance, and teacher effectiveness. Disadvantages include some students talking off-topic, becoming impatient, or one student doing most of the work. The document also discusses how computers can be used to support cooperative learning while still developing students' social skills.
Hypermedia is a form of multimedia that presents information and integrates student activities in a virtual learning environment. It allows for non-linear navigation through various forms of media, including text, graphics, audio, and video. Some examples of hypermedia applications are tutorial software, knowledge webpages, simulation games, and learning management systems. While it provides learner control over pacing and navigation, hypermedia does not replace real-life experiences.
The document discusses how cooperative learning can help address the lack of sufficient computers in classrooms. It defines cooperative learning as students working in small groups on a common task, and identifies five key elements: common goal, interdependence, interaction, individual accountability, and social skills. Cooperative learning has benefits like improved academic performance, literacy, language skills, and teacher effectiveness. When using computers, students generally prefer working together rather than alone, as the shared display screen fosters positive social interactions. However, teachers must structure cooperative computer activities effectively by grouping students strategically and ensuring tasks support collaboration.
EdTech2 Lesson 11: The Computer as Teacher's Toolbhanj_10
This document discusses how computers can support constructivist and social constructivist learning paradigms. It describes constructivism as knowledge constructed by individuals and social constructivism as knowledge constructed within social contexts. The computer is presented as a tool that can provide information, foster social knowledge building, and enhance communication. Specifically, it can serve as an informative tool, communication tool, constructive tool, co-constructive tool, and situating tool to support different aspects of individual and social learning.
Microsoft Office is a suite of desktop applications and services used for word processing, spreadsheets, presentations, notes, and more. It was first introduced in 1989 and includes programs like Word, Excel, PowerPoint, Outlook, Access, and Project. Microsoft Office has seen many versions over the years and has expanded to include additional programs like Publisher, InfoPath, OneNote, and Visio. It provides programs for tasks like managing documents, databases, schedules, and graphics across Windows and Mac operating systems.
Excel 2007 Training 2012 Module 1 (Self Study Materials)Amann Group
This presentation is designed for the Beginners in Excel 2007. I also published the outline of my next Two Modules. My two modules for Intermediate & Advance Learners will be coming soon. For some excel based application, I would suggest you to visit my LinkedIn Profiles\' Box Application.
This document provides an overview of Adobe Photoshop and some of its key tools. It describes Photoshop as the premier photo editing software that can be used to enhance images for webpages, presentations, and printed documents. The document then lists and describes seven categories of Photoshop tools: 1) cropping and slicing, 2) drawing, 3) painting, 4) measuring and navigating, 5) selection, 6) typing, and 7) retouching. It provides examples of tools within each category and their functions. Finally, it outlines three activities for applying basic text effects, changing an image's background, and applying a picture with text effects to a new background.
How to Insert a Graph into Microsoft Excel 2007nfasano
This document provides instructions for inserting a graph into Microsoft Excel 2007. It includes 7 steps: 1) Open a new Excel document, 2) Enter category data into columns for the x and y axes, 3) Enter values into cells below the category headings, 4) Highlight the selected cells, 5) Insert a graph from the options, 6) Select a graph type such as a line graph, 7) Use the chart tools to add titles, labels, and format the graph. The chart tools allow customizing the graph layout, format, and design. When complete, the graph remains editable on the Excel spreadsheet.
Educational Technology 2: The software as an educational resourceAbhy Casulla
This document discusses different types of software used for educational purposes. It defines systems software, applications software, and instructional software. Instructional software is used specifically for teaching and self-instruction through methods like drill and practice, tutorials, simulations, instructional games, and problem-solving. The document also provides guidelines for teachers to evaluate instructional software resources to ensure they are accurate, coherent, logically presented and achieve learning objectives without biases.
This document discusses the role of computers in education. It notes that computers were originally designed to perform mathematical and logical operations, and that the invention of the microcomputer and PC allowed them to be used for programmed instruction. The computer can act as a tutor for students, relieving some responsibilities from teachers. However, teachers still must plan activities and evaluate students. The document outlines the roles of students, computers, and teachers in computer-assisted instruction. It suggests that drill-and-practice software can reinforce basic skills when integrated appropriately into lessons by teachers. Different types of educational software are also summarized.
The document provides an introduction to using Photoshop for beginners. It discusses organizing the Photoshop workspace by customizing menus, toolbars, and palettes. It also covers basic tasks like opening and saving files, using layers, and an overview of the toolbox and common selection tools. The summary is aimed at new Photoshop users to help them navigate the interface and perform essential functions.
There are several conceptual models of learning that can be effectively supported through educational technology, including meaningful learning, constructivism, and generative learning. Meaningful learning connects new experiences to existing knowledge through hands-on activities and relating classroom lessons to real-world examples. Discovery learning allows students to uncover new ideas through engaging personally with open-ended tasks. Different models are suited to different instructional goals and subject matters.
The document discusses how technology can enhance learning environments by allowing students to take a more active role in discovering and constructing knowledge. It describes four key learning theories supported by technology: meaningful learning through relating new concepts to prior experience, discovery learning by exploring new ideas, generative learning by mentally connecting concepts, and constructivism by actively problem-solving real-world issues through hands-on activities and simulations. Overall, the document advocates for learning approaches empowered by technology that engage students in knowledge generation rather than passive memorization.
Hypermedia is an educational software that presents information and learning activities in a virtual environment by integrating text, graphics, audio, animation and video clips. It allows non-linear navigation, meaning learners can follow their own path through the material. Key characteristics include learner control over their sequence and pace, and the use of a variety of media types. Examples include tutorial software, online courses, simulations, and learning management systems.
Computers as information and communication technologyJunarie Ramirez
The document discusses the uses of computers as information and communication technology (ICT) in education. It describes how computers can be used as both instructional media through audiovisual aids like multimedia, and communication media through the Internet for email, chat rooms, blogs, and accessing educational websites and resources. It explains that with the advent of the personal computer (PC) and microprocessor, the distinction between instructional and communication media has merged, as the PC allows for both audiovisual creation and media communication through various software programs preinstalled on modern PCs.
Edtech2: Information Technology In support of Student Centered learningLouisa Anne Tansiongco
This document discusses student-centered learning (SCL) and how it compares to traditional classrooms. It outlines a systematic approach to teaching with SCL that focuses on defining objectives, choosing appropriate methods and experiences, implementing instruction, and evaluating outcomes. SCL places the student at the center of the learning process and encourages highly active and individualized pedagogical methods, in contrast to the traditional expositive instruction of traditional classrooms.
The document discusses the importance of the Internet for education. It defines the Internet as the largest and far-flung system connecting over 25,000 networks worldwide. The Internet has been one of the most important developments in human communication since call waiting. It allows for easy access to information through browsing and has the potential to positively transform education, organization, and participation in society.
This document provides an introduction and overview of key concepts in Microsoft Excel including worksheets, cells, formatting, formulas, functions, charts, and pivot tables. It explains how to create and manage worksheets, format cells, perform calculations with formulas and functions, create charts to visualize data, build pivot tables to summarize and filter data, and consolidate data across multiple worksheets. Examples and step-by-step instructions are provided for common Excel tasks like renaming sheets, merging cells, using arithmetic and logical operators in formulas, and linking worksheets to consolidate data.
MS-Excel is a GUI-based software application that allows users to create and edit electronic workbooks. A workbook contains multiple sheets where users can enter and manipulate data across rows and columns of cells. Each cell has a unique address where data and formulas can be added or edited. The formula bar displays the cell's address and is used to enter or modify its contents. Workbooks allow for multiple interconnected sheets while a worksheet is contained to a single sheet.
This document provides an introduction to Microsoft Excel by covering the Excel interface, opening and saving worksheets, entering and editing data, building formulas and functions, and formatting and printing data. It explores the components of the Excel window including the standard toolbar, formatting toolbar, formula bar, name box, row and column headings, active cell, and fill handle. It also describes how to enter and edit data, move around the worksheet, copy and move data, and work with Excel documents by opening, saving, and creating new workbooks.
Microsoft Excel is a spreadsheet application that allows users to organize and calculate data across rows and columns in a workbook. It can import various data types and formats them for analysis. Excel uses formulas and functions to perform calculations on cell values. Common functions include SUM to add values and AVERAGE to calculate means. Charts and graphs can visually represent spreadsheet data. Workbooks may contain multiple worksheets to organize different data sets.
Microsoft Excel is a spreadsheet application that allows users to organize and calculate data across rows and columns in a workbook. It can import various data types and formats them for analysis. Excel uses formulas and functions to perform calculations on cell values. Common functions include SUM to add values and AVERAGE to calculate means. Charts and graphs can visually represent spreadsheet data. Workbooks may contain multiple worksheets to organize different data sets.
Microsoft Excel is a spreadsheet application that allows users to organize and calculate data across rows and columns in a workbook. It can import various data types and formats them for analysis. Excel uses formulas and functions to perform calculations on cell values. Common functions include SUM to add values and AVERAGE to calculate means. Charts and graphs can visually represent data. Workbooks may contain multiple worksheets to organize related data in different tables.
This document provides an overview of Microsoft Excel and its key functions and features:
- MS Excel is a spreadsheet program used to organize and analyze numerical data more efficiently using functions and formulas. It has a grid of rows and columns that allows data to be entered into cells.
- The Excel screen has various elements like the ribbon, worksheet, scrollbar, etc. that allow the user to navigate, enter, edit and format data across multiple spreadsheets or worksheets.
- Cells in a worksheet are identified by their column and row names. Adjacent and non-adjacent groups of cells can be selected or referred to.
- Data of various types can be entered into cells. Multiple cells can be filled
PPT On Microsoft Excel 2007 Full Information.Umesh Kumar
Microsoft Excel is a powerful tool used to create and format spreadsheets. Spreadsheets allow information to be organized in rows and columns and analyzed with automatic calculations. In Excel, workbooks contain worksheets which are made up of cells organized into rows and columns. Cells can contain numbers, text, formulas, and more. Formulas allow calculations to be performed on cell values and functions pre-written formulas that perform common calculations. Charts can be inserted to visually represent spreadsheet data.
Microsoft Excel Glossary & Keyboard Shortcuts-Function Keyssdturton
This document provides a glossary of Microsoft Excel keyboard shortcuts and functions organized into the following sections: Function Keys, Basic Keys, Formatting Keys, Insert and Layout Keys, Functions and Data Shortcuts, and Other Keyboard Shortcuts. It defines common Excel terms such as active cell, cell references, charts, AutoFilter, and more. The glossary contains over 50 terms and their descriptions to help users understand Excel functions and shortcuts.
Microsoft Excel is a spreadsheet application that allows users to enter and organize data into worksheets and cells. Worksheets contain rows and columns that make up a grid, and data is entered into the grid's cells. Excel includes functions and formulas to perform calculations on data and create charts for visual representation. Users can format and style worksheets, enter formulas, filter and sort data, and perform other analysis. Google Sheets provides similar spreadsheet functionality to Excel in a web-based format.
The document provides an overview of key features in Microsoft Excel 2007, including spreadsheets, the ribbon interface, formulas, charts, and other formatting and analysis tools. It describes spreadsheet components like workbooks, worksheets, and cells. It explains the ribbon tabs and groups that contain formatting and function tools. It also provides instructions for common tasks like entering formulas, creating charts, formatting cells and text, hiding and arranging worksheets, and printing worksheets.
This document provides instructions for using basic features in Microsoft Excel, including:
- Opening and navigating the Excel interface
- Entering data into cells
- Formatting cells and adjusting column widths/row heights
- Using AutoSum to calculate totals
- Saving workbooks
- Inserting and deleting rows/columns of data
- Using basic formulas
- Printing and previewing worksheets
- Autofilling data to expand budgets over multiple periods
Microsoft Office includes applications such as Word for word processing, Excel for spreadsheets, and PowerPoint for presentations. Word allows users to create documents and includes features for formatting, adding graphics, and printing. Excel allows users to enter data into spreadsheets and perform calculations using formulas. PowerPoint enables the creation of slideshows with elements like text, images, animations, and transitions to present information to audiences. These applications are commonly used for office and business purposes like documentation, financial analysis, and presentations.
Excel can be used to create spreadsheets, charts, and simple databases. It contains worksheets made up of rows and columns that intersect to form cells. Cells can contain labels, values, or formulas. Functions like SUM can perform calculations on ranges of cells. Conditional formatting can change cell appearances based on values. Data can be sorted, filtered, and organized into tables or charts for visualization.
The document provides an introduction to Excel basics, including:
- What a spreadsheet is and its key components like rows, columns, and cells.
- How to enter and format data, insert and delete rows and columns, and move or copy data within a spreadsheet.
- How to use formulas with mathematical and logical operators, functions, and cell references.
- Features for analyzing data like sorting, filtering, and creating charts and graphs.
This document is a handbook for basic Excel tasks. It contains 4 parts that cover background information, Excel 101 tasks, formatting and appearance, and tips for working efficiently. Key topics include Excel terminology, inserting and deleting rows and columns, formatting cells, sorting data, adding headers and footers, and printing options. The handbook is intended as a reference for users who will view and print Excel reports.
Excel allows users to create and edit spreadsheets. It contains tools for entering and formatting data, performing calculations with formulas and functions, and creating charts and graphs. Common Excel functions include SUM, AVERAGE, COUNT, and financial calculations. Users can format cells, insert and delete rows/columns, move or copy data, and fill cells automatically with a series.
- Excel is a spreadsheet application that allows data to be organized into worksheets and cells. Worksheets can contain tables, charts, and formulas.
- Each worksheet contains a grid of rows and columns that make up individual cells identified by column letters and row numbers. Cells can contain text, numbers, formulas, and other data.
- Formulas and functions allow calculations and analysis to be performed on the data in cells and ranges. Common functions include SUM to add values and formulas can reference multiple cells and perform calculations.
This document provides an overview of how to customize the Ribbon interface in Excel 2010. It explains how to hide the Ribbon with one click. It describes how to add new tabs and groups to the Ribbon using the Customize Ribbon option in the Excel Options dialog box. Commands can then be added to these new custom tabs and groups. The document provides step-by-step instructions on how to create a new group, rename it, and add commands to it. This allows the user to customize the Ribbon with frequently used commands for improved productivity in Excel 2010.
Machine Learning 2 deep Learning: An IntroSi Krishan
The document provides an introduction to machine learning and deep learning. It discusses that machine learning involves making computers learn patterns from data without being explicitly programmed, while deep learning uses neural networks with many layers to perform end-to-end learning from raw data without engineered features. Deep learning has achieved remarkable success in applications involving computer vision, speech recognition, and natural language processing due to its ability to learn representations of the raw data. The document outlines popular deep learning models like convolutional neural networks and recurrent neural networks and provides examples of applications in areas such as image classification and prediction of heart attacks.
The document discusses bringing artificial intelligence (AI) to business intelligence (BI). It provides an overview of the current BI environment and how it is lacking in its ability to answer "why" questions and provide prescriptive recommendations. The document then defines different types of AI, from weak AI to artificial general intelligence. It also outlines various AI technologies, especially machine learning techniques like supervised and unsupervised learning. The overall document serves to introduce the topic of integrating AI capabilities into BI tools and analytics.
This document provides an introduction to machine learning. It discusses what machine learning is, using examples like credit default prediction using logistic regression. The key reasons for the popularity of machine learning currently are the availability of large amounts of cheap data, numerous algorithm development companies, and cloud-based machine learning platforms. Various machine learning concepts are also introduced, such as feature vectors, supervised vs unsupervised learning, and terminology.
Continues with Excel basics giving information on cell addressing styles and worksheet functions and their nesting. Also gives an example of precision setting
How to Do Research: Seven Steps to Successful ResearchSi Krishan
This document provides guidance on how to conduct research. It discusses what research is, different knowledge sources, and a seven step process for successful research: defining the research question, gathering information, forming a hypothesis, implementation/analysis, organizing results, communicating results, and revising. It also covers defining a good research question, reading papers, organizing references, and the nonlinear nature of research. The overall document serves as a guide for students and researchers on how to effectively plan and execute a research project.
The document provides an overview of data, information, knowledge, and data mining. It defines data as facts/observations/measurements, information as processed data that is useful (e.g. for decision making), and knowledge as patterns in data/information with a high degree of certainty. Data mining is described as the process of extracting useful but non-obvious information from large databases through an interactive and iterative process. Common business applications and technologies involved in data mining are also discussed.
Machine learning and multimedia information retrievalSi Krishan
The document summarizes a presentation on machine learning and multimedia information retrieval. It discusses how machine learning helps bridge the semantic gap in multimedia search by exploiting context from surrounding text, tags, and other metadata. It also describes how machine learning is used for tasks like detecting events in videos, classifying images into categories, and suggesting tags. Current applications of multimedia information retrieval discussed include biological image retrieval, fashion search engines, and visual search for suspects.
In ScyllaDB 6.0, we complete the transition to strong consistency for all of the cluster metadata. In this session, Konstantin Osipov covers the improvements we introduce along the way for such features as CDC, authentication, service levels, Gossip, and others.
MongoDB vs ScyllaDB: Tractian’s Experience with Real-Time MLScyllaDB
Tractian, an AI-driven industrial monitoring company, recently discovered that their real-time ML environment needed to handle a tenfold increase in data throughput. In this session, JP Voltani (Head of Engineering at Tractian), details why and how they moved to ScyllaDB to scale their data pipeline for this challenge. JP compares ScyllaDB, MongoDB, and PostgreSQL, evaluating their data models, query languages, sharding and replication, and benchmark results. Attendees will gain practical insights into the MongoDB to ScyllaDB migration process, including challenges, lessons learned, and the impact on product performance.
Database Management Myths for DevelopersJohn Sterrett
Myths, Mistakes, and Lessons learned about Managing SQL Server databases. We also focus on automating and validating your critical database management tasks.
CNSCon 2024 Lightning Talk: Don’t Make Me Impersonate My IdentityCynthia Thomas
Identities are a crucial part of running workloads on Kubernetes. How do you ensure Pods can securely access Cloud resources? In this lightning talk, you will learn how large Cloud providers work together to share Identity Provider responsibilities in order to federate identities in multi-cloud environments.
How to Optimize Call Monitoring: Automate QA and Elevate Customer ExperienceAggregage
The traditional method of manual call monitoring is no longer cutting it in today's fast-paced call center environment. Join this webinar where industry experts Angie Kronlage and April Wiita from Working Solutions will explore the power of automation to revolutionize outdated call review processes!
Radically Outperforming DynamoDB @ Digital Turbine with SADA and Google CloudScyllaDB
Digital Turbine, the Leading Mobile Growth & Monetization Platform, did the analysis and made the leap from DynamoDB to ScyllaDB Cloud on GCP. Suffice it to say, they stuck the landing. We'll introduce Joseph Shorter, VP, Platform Architecture at DT, who lead the charge for change and can speak first-hand to the performance, reliability, and cost benefits of this move. Miles Ward, CTO @ SADA will help explore what this move looks like behind the scenes, in the Scylla Cloud SaaS platform. We'll walk you through before and after, and what it took to get there (easier than you'd guess I bet!).
The document discusses fundamentals of software testing including definitions of testing, why testing is necessary, seven testing principles, and the test process. It describes the test process as consisting of test planning, monitoring and control, analysis, design, implementation, execution, and completion. It also outlines the typical work products created during each phase of the test process.
Guidelines for Effective Data VisualizationUmmeSalmaM1
This PPT discuss about importance and need of data visualization, and its scope. Also sharing strong tips related to data visualization that helps to communicate the visual information effectively.
In our second session, we shall learn all about the main features and fundamentals of UiPath Studio that enable us to use the building blocks for any automation project.
📕 Detailed agenda:
Variables and Datatypes
Workflow Layouts
Arguments
Control Flows and Loops
Conditional Statements
💻 Extra training through UiPath Academy:
Variables, Constants, and Arguments in Studio
Control Flow in Studio
TrustArc Webinar - Your Guide for Smooth Cross-Border Data Transfers and Glob...TrustArc
Global data transfers can be tricky due to different regulations and individual protections in each country. Sharing data with vendors has become such a normal part of business operations that some may not even realize they’re conducting a cross-border data transfer!
The Global CBPR Forum launched the new Global Cross-Border Privacy Rules framework in May 2024 to ensure that privacy compliance and regulatory differences across participating jurisdictions do not block a business's ability to deliver its products and services worldwide.
To benefit consumers and businesses, Global CBPRs promote trust and accountability while moving toward a future where consumer privacy is honored and data can be transferred responsibly across borders.
This webinar will review:
- What is a data transfer and its related risks
- How to manage and mitigate your data transfer risks
- How do different data transfer mechanisms like the EU-US DPF and Global CBPR benefit your business globally
- Globally what are the cross-border data transfer regulations and guidelines
For senior executives, successfully managing a major cyber attack relies on your ability to minimise operational downtime, revenue loss and reputational damage.
Indeed, the approach you take to recovery is the ultimate test for your Resilience, Business Continuity, Cyber Security and IT teams.
Our Cyber Recovery Wargame prepares your organisation to deliver an exceptional crisis response.
Event date: 19th June 2024, Tate Modern
Communications Mining Series - Zero to Hero - Session 2DianaGray10
This session is focused on setting up Project, Train Model and Refine Model in Communication Mining platform. We will understand data ingestion, various phases of Model training and best practices.
• Administration
• Manage Sources and Dataset
• Taxonomy
• Model Training
• Refining Models and using Validation
• Best practices
• Q/A
Communications Mining Series - Zero to Hero - Session 2
Intro to Excel Basics: Part I
1.
2. What is Excel?
Excel is a spreadsheet application software from Microsoft
Some spreadsheet programs are also available free of
charge. For example, Google Docs application suite
Beginning with Excel 2 for Windows, many versions of
Excel have appeared so far. Excel 2013 is the latest version
for Windows. [The latest Mac version of Excel is Excel
2011]
3. Spreadsheet Origin
Dan Bricklin and Bob
Frankston
Invented in 1979
VisiCalc for Apple II
Took 20 hours of work
per week from some
people and made it into
15 minutes of work
Sold and developed into
Lotus 1-2-3
4. Excel 2007 & Beyond
Excel 2007 and versions thereafter
differ significantly from earlier versions
of Excel
These versions offer a totally different
look and feel of the user interface from
earlier versions
Expanded features and capabilities with
every new release
5. Getting Familiar with Excel
Start screen
Excel interface elements
Backstage view
Workbooks and worksheets
Moving around in a worksheet
Data in Excel
Excel Formulas
Formatting
6. Start Screen
You can save your files in
OneDrive, a built-in
cloud support in Office
2013
8. The Ribbon
Common across all applications in Microsoft Office for
consistent look and feel.
File button Tabs Only one tab is active at
any time. The active tab
is highlighted
9. Tabs
Only one tab can be active. The active tab is shown
highlighted. You can make a tab active by clicking on it.
The Ribbon shows a set of panels below the tabs row
The set of panels shown corresponds to the active tab.
If you make another tab active, the panel set changes
Each panel shows a group of related buttons or icons
Some tabs appear only based upon certain actions.
Such tabs are known as contextual tabs
21. Mini toolbar: gives quick
access to frequently used
formatting command
buttons
Shortcut menu appears
upon right clicking the
pointer. The actual list of
commands in the shortcut
menu varies based on
context
Mini Toolbar and Shortcut Menu Bar
Mini Toolbar & Shortcut Menu Bar
26. Workbooks and Worksheets
An Excel workbook is made
up of worksheets and chart
sheets. The chart sheets are
special sheets for storing
charts
The number of worksheets
that a workbook can hold is
limited only by the
computer memory. By
default, Excel 2013 opens a
new workbook with only
one worksheet with the
default name Sheet1.
(Previous versions had
three default worksheets)
28. Workbooks and Worksheets
Although many workbooks can be open at any time, only one
workbook is designated as the active workbook. Similarly only
one worksheet can be the active worksheet at any time
When you open a new Excel file, it is given the default name of
Book1. If you open another new file, it will open with name as
Book2.
29. Worksheet Specs
Every Excel worksheet has 16,384 columns and
1,048,576 rows
The intersection of a row and a column is called a cell
The columns are numbered from A to XFD, and rows
from 1 to 1,048,576
30. Mouse Pointer Appearance
Mouse pointer changes its appearance to
indicate what action can be performed
Arrow: select item from the Ribbon or scrolling or
other commands
I-beam: type text in formula bar
White plus sign: as the pointer moves over worksheet
surface
Small black arrow: when the pointer is over the
column or row indicators to select a column or a row
A cross with double arrow: when placed at the
boundary of a selected column or row to change
column width or row height
31. Cells
Cell reference
A cell is referred by the letter for the column in which the cell is located
followed by the number of the row holding the cell. Thus, B5 refers to
the cell in Column B located in the fifth row. AZ23 means a cell in
column AZ and row 23. Cell reference is also known as cell address.
32. Cells
A cell must be active if we wish to enter data into it. An
active cell has a thick dark boundary, called cell selector,
along it.
The bottom right corner of the cell selector is marked by a
small square, called the fill handle
36. Renaming, Inserting, and Deleting
Worksheets
The shortcut menu of commands upon right-clicking a
sheet tab
Excel permits worksheet names
limited to 31 characters. Blank
spaces are permitted in worksheet
names.
To rename a sheet, double-click the
sheet tab and enter the new name.
38. Selecting a Group of Cells
You can select a group of cells by selecting the top left cell of
the group and then dragging the pointer over the cells you
want to select
To select a full row, click on the row number. Do the same to
select a column
To select multiple rows, select the first row and then drag
the pointer over row numbers to the desired row. Similar
action for multiple columns
A group of selected cells. The first cell in the group in white is the
active cell.
39. Excel Data Types
Data types implies the types of cell
entries Excel recognizes
Three different types of entries
Text or label
Value
Formula
40. Text
Any combination of letters, numbers, and special
characters
Cannot be used for calculations
Left aligned in cell (default setting)
Examples:
Names of places/persons
Telephone number
Security number
Column headings, for example Monthly sales
42. Value Entries
Numbers, dates, times
Can be used for calculations
Right justified in cell (default setting)
Examples:
378 11/29/94 4:40:31 (9876)
Number Date Time Negative Number
3/15/08 is a recognized as a valid date and
hence a valid value entry
15/15/08 is treated as a text entry because
15/15/08 is not a valid date
43. Value Entries
Suppose you have an order number 10-16-70. Excel
will incorrectly treat it as a valid date (October 16,
1970). In such cases you should enter ‘10-16-70 to let
Excel know that it is not a date
44. Formulas
A cell entry beginning with an equal sign (=) is
treated as a formula in Excel
A formula is an expression telling Excel to perform
an operation
Excel allows many types of operations; however,
we shall consider only arithmetic operations for
now
Examples
=159*3.7
=A1+A2+A3
=(2*A1-B1)*C1
=A1/B1+C1^2.5
Operator
Operands
48. Parentheses Nesting
Nesting allows you to tell Excel how a formula should
be evaluated. For example in the following formula, the
expression within blue parentheses will be evaluated
first followed by green and red parentheses
=(B2*(D2^(C2−2)+A2/C2)+6.75)*B4
49. Worksheet Functions
Excel provides a large number of worksheet
functions or simply called functions. We will look
at them later.
Some examples of formulas with functions are:
=SQRT(A1)+5
=SUM(A1,B1,C1)
=SUM(A1,B1,C1)/(SQRT(A1)+5)
51. Formatting
Controls how information in cells is displayed
Two aspects of formatting
Stylistic formatting
Governs font type, size, color, cell background and border style
etc
Numeric formatting
Governs how a value appears in a cell. For example, the
number of digits after a decimal point
54. Creating a Worksheet
We want to create a worksheet that:
Shows name, id, and the semester of a student at a
university
Shows the courses taken by the student
Shows the credit hours and the grades obtained
Calculates the grade point average (GPA)
The final worksheet should look similar to as shown in
the next slide
56. Step 1: Starting Excel
Start Excel. You can start Excel by clicking on the Excel
icon on your desktop. Alternately, click on the Start
button at the bottom left of your Windows desktop,
and then point to All Programs to display the programs
your computer has. Next, point to Microsoft Office and
click on Excel to start it.
Excel will open a new workbook with the default name
Book1 and cell A1 as the active cell.
57. Step 2: Formatting Cells A1 to F4
Select cell A1, click the left button on the mouse
and drag it over cells in columns A-F and row 1-4.
Your worksheet will appear as shown below
58. Step 3: Merge Cells A1 to F4
We will be entering the university name in cells A1 to
F4. So we need to merge these cells to act as one large
cell
Click the Merge & Center button in the Alignment
panel
59. Step 4: Set Wrap Text & Alignment
Click the Wrap Text button to ensure that any text entered
in the merged cells will be wrapped around
Click the Center button in the Alignment panel to instruct
Excel that you want text horizontally centered
Click the Middle Align button to vertically center the text
as well
60. Step 5: Setting Font and Fill Color
Click on the Font Selection button in the Font panel
and select Arial font.
Set Font size to 24 via the Font Size button
Select Bold as the font style
Select a background of your liking by clicking the Fill
Color button
61. Step 6: Enter Information
Enter a name for the university in the merged cells
Enter the student name in cell A5. Enter the ID and
semester information in cells A6 and E5
Enter the headings in cells A7 to E7
Enter course numbers, titles, credits, and grades in
cells A9 to D13. You can makeup your own courses,
credits, and grades, if you desire. You might need to
increase the widths of columns A and B. You can do so
by dragging the right boundaries of columns A and B
62. Entering/Editing Cell Entries
Select cell
Click in formula bar or press function key F2
Enter/Edit cell content
Type in the desired information
Backspace key (removes character on left)
Delete key (removes character on right)
Highlight by dragging over characters to change, then
type correction (will replace what is highlighted)
Press Enter key
63. Step 7: Change the worksheet
Name
Right click on Sheet1 tab and select Rename
from the shortcut menu
Enter a new name, for example Gradesheet
64. Step 8: Writing Formulas
Points calculation for a course
Remember, the points are given by multiplying the credits with
the numerical grade in the course
Thus for cell E9 which is suppose to show points for the
course in cell A9, the formula will be =C9*D9. We select cell E9
and enter this formula in the formula bar and press Enter. Cell
E9 should now show the result
Write similar formulas for cells E10 to E13
65. Step 8: Writing Formulas (Contd.)
Formula for Total Credit Hours in cell C15
The total credit hours are given by adding credit hours
from different courses
Thus for cell C15, the formula is
=C9+C10+C11+C12+C13. You can also do the
summation by using the built-in Excel function SUM and
write the formula as =SUM(C9,C10,C11,C12,C13)
Important: Make sure you do not have a
space preceding the equal sign while
entering a formula
66. Step 8: Writing Formulas (Contd.)
Formula for GPA in cell E15
The GPA is calculated by dividing the total points by the total
credit hours
Thus for cell E15, the formula is
=(E9+E10+E11+E12+E13)/C15
Note, the use of parenthesis to instruct Excel to add points
first. Also note the use of already calculated total credit hours
in C15
You will see that Excel shows the result with many
places after the decimal. Use the Decrease Decimal
button to show only two places after the decimal
67. Step 9: Saving Your Worksheet
Click on the File tab and select Save As command
Select the Excel Workbook option
In the ensuing dialog box, enter an appropriate name for
your workbook and click Save
You will notice the name you have given to your
workbook now appears in the title bar at the top
replacing the default name Book1
68. Printing a Worksheet
Click the Office Button and select the Print command
Select the print settings through the Print dialog box
Use the Print Preview option to preview your sheet
before printing
69. Printing a Worksheet
You can also use the View tab for previewing and
printing
Click on the View tab to make it active
Click the Page Layout button in the Workbook Views panel
Click the line Click to add header and type the desired header
70. Worksheet Templates
A template is an Excel file that is already formatted, has
formulas, and cells marked for data entry. You fill in
your specific information and cell values to create a
working sheet from it
Excel comes with several templates. To open a
template, select New from the File menu and then
select the desired in the Backstage window
Microsoft Office Online also provides many templates
72. Excel 2013 File Formats
Several formats are available
Default format is .xlsx
Saving in .xls (Excel 2003) format is advised when you
are sharing your files with others
Excel templates have .xltx format
Workbooks with macros are saved with .xlsm
extension
73. Customizing Excel Settings
Click File > Option
Several categories of options are available for
customization
Some examples of options:
Turn on/off the Mini Toolbar
Customize Excel window
Change the default font setting
Calculation mode
76. Calculation Modes
Excel automatically updates the results of formulas
as you make changes in cells referenced in
formulas
You can also set Excel to manual calculation mode.
In this mode Excel updates the calculation results
only after you press the function key F9
You can do this in Excel Options window by
selecting the Formula category of options
78. Formula View
In the Formula View, Excel shows cell formulas in
place of showing the formula results
The Formula View is good for sharing a worksheet to
show how the calculations are being performed
To select the Formula View, click on the Formulas tab,
and then click on Show Formulas button in the
Formula Auditing panel. You can do the same via Excel
Options also
80. Seeking Help in Excel
The question mark
in the upper right
corner of the Ribbon
stands for Excel
Help. You can also
invoke Help by
pressing the function
key F1
Excel responds by
opening the Excel
Help window where
you can browse
through help topics
or do a search
81. Adding Comments to Cells
It is a good practice to add comments to cells with
formulas for better understanding and sharing of
worksheets
To add comments to a cell
Select the cell
Make the Review tab active
Click the New Comments button in the Comments panel
Enter the comments and click on any other cell