Learn to create and modify basic PivotTables for quickly summarizing and highlighting data. Learn to work with the Format Cells dialog to apply text rotation and borders, and to center data across multiple cells. Learn to build your own custom number formats to display dates, values and variances how you want to see them.
Learn how to create an effective column chart by reducing ink and 'noise' that distract from the main messages. Try it! How to create an effective line chart through careful manipulation of chart elements to enhance its story telling ability. Use to restrict users ability to enter invalid data in cells by providing them with a drop down list of valid options. Learn about page setup options, fitting print jobs on a page, headers and footers, and other ways to customize print jobs.
Would highly recommend to anyone looking to discover the powerful tools of Excel. Would recommend to anyone wanting to learn Excel. Would highly recommend! Join our newsletter today for free Microsoft Excel content Subscribe Join , others. Toggle navigation GoSkills. Search for courses or lessons. Get started View pricing. Get certified. Video tutorials are recorded in Microsoft Excel for Mac Auto p p p.
- payday 2 save editor mac;
- Learn from the experts?
- Other Quick Starts.
- quinoa shells mac and cheese!
- Modern workplace training.
- Welcome to Office Help & Training!
Skill level Beginner. Certificate Yes learn more. Lessons Accredited by CPD. Pre-requisites None. Video duration 4h 14m. Estimated study time 24h 30m for all materials. Accreditations and approvals. Getting to Know Excel. The Ribbon Identify the terminology and elements of the Ribbon.
Navigation Utilize the keyboard or mouse to select cells and ranges in a spreadsheet. First File Create your first Excel file, enter data and create a table.
Find a Microsoft Store near you
Formatting Format cells by selecting fonts and color fills to make information more attractive. Basic Math Utilize basic mathematics including multiplication and division in Excel.
- Office for Mac Training and Tutorials.
- movie cutter free download for mac;
- mac and pc compatible nas!
- What will you do?;
- Microsoft Excel for Mac - Basic & Advanced?
- Was this information helpful??
Essential Formula Knowledge. Cell Referencing Learn about working with absolute and relative cell referencing, and techniques for copying formulas. Function Anatomy Use to understand the anatomy of Excel functions, and what their components mean. Understanding Time Understand how time works in Excel, and how to change from whole numbers into time increments and back again.
Intermediate Formula Knowledge. Formula Auditing Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation. External Links Learn about creating and updating external links, and about the potential dangers of external links in Excel.
Optimizing Data. Sorting Learn to sort data in Excel by a single column or by multiple columns. Filtering Learn to filter Excel data for specific words, dates, and apply multiple filters to a single data table. Naming Ranges Learn about creating named ranges, and the benefits of doing so. Excel Tables Learn about creating Excel tables, and their advantages. Recording Macros Learn to record basic Excel macros to automate your actions instead of doing them manually. Data Analysis. Creating PivotTables Learn to create and modify basic PivotTables for quickly summarizing and highlighting data. Plus, personalized course recommendations tailored just for you.
To access Lynda.com courses again, please join LinkedIn Learning
Get LinkedIn Premium features to contact recruiters or stand out for jobs. Learn how to use Office for Mac, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Show More. Get unlimited access to more than 6, courses, including personalized recommendations. You are now leaving Lynda. To access Lynda.
Microsoft Excel for Mac - Basic & Advanced | Online Training Course
Visit our help center. Office for Mac. Preview Course. Excel for Mac Shortcuts Curt Frye.